The ETL Developer specializes in the design and development of the ETL environment, processes, programs, and scripts to acquire data from source systems and apply the data to the tables in the database. This individual must have the skills necessary to understand the overall data warehouse architecture. The ETL Developer designs and builds the ETL environment with the specific toolset required by the client. The ETL Developer may also provide input to the database designer to optimize the data loading of the physical database. The ETL Developer may be the Lead Developer on a project.

Key Areas of Responsibility

• Capture ETL Requirements
• Design, develop, test, support processes for extracting and loading data from source systems to DWH and DM
• Design the processes to meet service level agreements for data timeliness and frequency
• Analyze and optimization current solutions, physical model optimization, query tuning

Requirements

• In depth knowledge of any enterprise relational database
• In depth knowledge of ETL tools: Informatica PowerCenter or SAS DI
• Knowledge of Metadata driven approach is an advantage
• Knowledge of BigData is an advantage
• Master degree in IT or related sphere
• English intermediate, Russian native