Junior Data Integration for DWH Tools (ETL Consultant)


Company Type


ETL Consultant

 Role Description

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, and test processes for extracting data from legacy systems or production databases.
•           Design, develop, and test processes for validating and conditioning data prior to loading into a data warehouse.
•           Design, develop, and test processes for loading initial and cyclical data into a data warehouse.
•           Design the processes to meet service level agreements for data timeliness and frequency.
•           Determine which data elements are historic and the retention period for historic data.
•           Determine data growth trends and peak business periods.



•           In depth knowledge of the Teradata Database.
•           In depth knowledge of ETL tools.

Skill Category   Skill Mapping
Databases        Secondary Skill
Operations Skills           Knowledge
Software Development Skills     Primary Skill
Teradata Active Data Warehousing Knowledge   Primary Skill
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           Knowledge
Tools – Operating Systems/Networking  Knowledge
Tools – Security Knowledge
Tools – Teradata           Primary Skill





Primary Location

Europe, Middle East & Africa-Egypt-Cairo


EMEA Sales & Services

Read Full DescriptionHide Full Description
Confirmed 22 hours ago. Posted 30+ days ago.

Discover Similar Jobs

Suggested Articles

One Step Register
Need an account? Sign Up