Cape Town, Western CapePermanentThe ETL Analyst Developer contributes and provides consulting 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 database and toolset architecture. The ETL Analyst Developer builds the ETL environment with the specific toolset required by the client.
The ETL Analyst Developer may also provide input to the database designer to optimize the data loading of the physical database.
Job Requirements : Areas of responsibilityCapture 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. Skills required : Knowledge of Teradata Database. Knowledge of ODI as an ETL tool.
Skill Category Skill Mapping Databases Primary Skill Tools ETL Primary Skill Software Development Skills Primary Skill Teradata Active Data Warehousing Knowledge Primary Skill Tools Development Primary Skill Tools Teradata Primary Skill Tools Enterprise Application Integration Secondary Skill Tools ERP Software Secondary Skill Tools Job Control and Scheduling Secondary Skill Operations Skills Knowledge Tools Modeling Knowledge Tools Operating Systems / Networking Knowledge Tools Security Knowledge Job Related Experience Required Time Span Essential / Desirable ETL Design and development 5 years Essential Oracle Data Integrator 5 years Essential Teradata Database 5 years Essential