Teradata ETL Consultant in Moscow, Russia
The ETL Consultant 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 Consultant designs and builds the ETL environment with the specific toolset required by the client. The ETL Consultant may also provide input to the database designer to optimize the data loading of the physical database. The ETL Consultant may be the Lead Consultant 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.
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
Business Consulting Service Offers
Consulting Service Offers
Teradata Active Data Warehousing Knowledge
Tools – Development
Tools – Enterprise Application Integration
Tools – ERP Software
Tools – ETL
Tools – Job Control and Scheduling
Tools – Modeling
Tools – Operating Systems/Networking
Tools – Security
Tools – Teradata