ETL Developer

Job Description

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

Technical /Functional Skill Category

Skill Mapping

Business Consulting Service Offers

Secondary Skill

Consulting Service Offers

Primary Skill

Databases

Primary Skill

Industry Knowledge

Knowledge

Teradata Active Data Warehousing Knowledge

Primary Skill

Teradata Applications

Knowledge

Tools – Development

Primary Skill

Tools – Enterprise Application Integration

Secondary Skill

Tools – ERP Software

Secondary Skill

Tools – ETL

Primary Skill

Tools – Job Control and Scheduling

Secondary Skill

Tools – Modeling

Secondary Skill

Tools – Operating Systems/Networking

Knowledge

Tools – Security

Knowledge

Tools – Teradata

Nice to have