Connecting...

W1siziisinrozw1lx2fzc2v0cy9wzw9wbgvzb2x2zwqvanbnl2jhbm5lci1kzwzhdwx0lmpwzyjdxq

Analyst Developer (Fixed-Term Contract) - (5364)

Analyst Developer (Fixed-Term Contract) - (5364)

Job Title: Analyst Developer (Fixed-Term Contract) - (5364)
Location: Western Cape
Industry:
Reference: JN -122016-7300
Job Published: March 01, 2017 14:06

Job Description

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 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 can grow into a Lead Consultant on a project should they show the potential over time.
 
Job Requirements:
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.
 
Skills required:
In depth knowledge of the Teradata Database.
In depth knowledge of ODI as an ETL tool.
 
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.
 
Skills required:
In depth knowledge of the Teradata Database.
In d Knowledge of ODI as an ETL tool.
 
Skill CategorySkill Mapping
DatabasesPrimary Skill
Tools & ETLPrimary Skill
Software Development SkillsPrimary Skill
Teradata Active Data Warehousing KnowledgePrimary Skill
Tools & DevelopmentPrimary Skill
Tools & TeradataPrimary Skill
Tools & Enterprise Application IntegrationSecondary Skill
Tools & ERP SoftwareSecondary Skill
Tools & Job Control and SchedulingSecondary Skill
 
Operations Skills
Knowledge
Tools ModelingKnowledge
Tools Operating Systems/NetworkingKnowledge
Tools SecurityKnowledge
















 
Job Related Experience RequiredTime SpanEssential / Desirable
ETL Design and development3 yearsEssential
Oracle Data Integrator2 yearsEssential
Teradata Data Warehousing2 yearsDesirable
Ab Initio1-2 yearsDesirable
 PeopleSolved is a leading specialist recruitment firm solving the needs of and for people globally
 
 

Get similar jobs like these by email

By submitting your details you agree to our T&C's