Assistant ETL Specialist and Developer

Flextecs Nepal Pvt Ltd

Flextecs Nepal is a subsidiary company of Flexible Techonology Solution LLC having its headquarter in Atlanta, USA. FlexTecs is a global Accounts Payable Audit Recovery Firm. The objective of FlexTecs is to “Help Companies Help Themselves”, by improving their internal controls of disbursements across the various divisions of their organization.

Details / requirements:

Salary: negotiable

Description:

The ETL (Extract, Transform, Load) Developer develops, designs and supports ETL processes and tools. Responsibilities include data loading and manipulation to ensure data from various sources and formats are efficiently and effectively integrated into company’s data warehouse system.

Job Description:

  • Develop and manage effective working relationships with other departments, groups and personnel with whom work must be coordinated or interfaced 
  • Establish and enforce data warehousing standards to meet requirements and business needs 
  • Evaluate existing subject areas stored in the data warehouse and determines where data should be stored 
  • Create SSIS ETL solutions with Microsoft SQL Server environment
  • Utilizes SQL development to produce effective database development 
  • Develops solutions to minimize implementation risk and time and/or improve system reliability and performance 
  • Review ETL programs for compliance with best practices, standards, enterprise architecture and documentation requirements, ETL process, programs and scripts 
  • Conduct root cause analysis and resolve performance and production problems and data issues
  • Validate the data in the database and test the developed routines 
  • Provide ongoing maintenance and support of assigned ETL applications 
  • Assist in several components of the overall ETL process and data warehouse system 
  • Document tasks for end-user, technical, and managerial review to ensure high quality customer service 
  • Perform quality assurance testing of data integration and report development and monitor data load operations to ensure accuracy
  • Meet professional obligations through efficient work habits such as, meeting deadlines, honoring schedules, coordinating resources and meetings in an effective and timely manner, and demonstrate respect for others 
  • All work responsibilities are subject to having performance goals and/or targets established

REQUIREMENTS:

Education:

  • Bachelor’s Degree in Computer Science or Information Systems; or equivalent combination of education and relevant experience

Experience:

  • Three years’ ETL development, preferably for large, complex data sets
  • Experiment in using SSIS and C# development focused handling large data files
  • Experience working with relational databases
  • Experience working with programming concepts
  • Experience working statistical concepts
  • Experience using various tools and techniques for data warehouse technologies and implementations
  • Experience designing, debugging database models
  • Experience writing SQL scripts including functions, stored procedures, triggers and views
  • Experience writing programs in C#
  • Experience using statistics for data verification

Knowledge, abilities and skills:

  • Ability to work under pressure and under minimal guidance 
  • Ability to execute project requirements with/for multiple employees and meet deadlines
  • Highly skilled in logical and analytical modeling
  • Highly skilled in SQL development 
  • Understanding of relational database models
  • Knowledge of data warehousing, and data administration
  • Ability to work independently and as a part of a team
  • Strong verbal and written communication skills
  • Wiling to work outside of 9-5-time constraint depending on projects

Candidates can send in their resume directlly to careers@flextecs.com.

Overview

Category Web Development
Openings 2
Experience 3+ years
Education B.E. in Computer Science
Posted Date 28 Nov, 2018
Apply Before 28 Dec, 2018
City Lalitpur