Our client is dedicated to advancing IT strategy in the financial, telecommunications and multimedia arenas. Their focus is in the management of customers, services and resources in these industry verticals. Currently they are looking for an experienced ETL Analyst Developer.
 
Job type: 12 month contract
Location: Cape Town
Salary: R40k – R55k p/m
Primary Skill: ETL, Teradata Data Warehousing
Job Level: Experienced
Qualification required: Bachelor’s Degree or Equivalent experience
 
Job Description  
The Analyst 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 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 grow into a Lead Consultant role on the project.
     
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 Category:

• Databases
• Operations Skills
• Software Development Skills
• Teradata Active Data Warehousing Knowledge

 
Tools

• Development
• Enterprise Application Integration
• ERP Software
• ETL
• Job Control and Scheduling
• Modeling
• Operating Systems/Networking
• Security
• Teradata

 
Job Related Experience Required

• ETL Design and development
• Teradata Data Warehousing
• Informatica
• AbInitio
• Oracle Warehouse Builder

 
Competencies

• Adaptability
• Building Customer Loyalty
• Building a successful team
• Building strategic working relationships
• Coaching
• Communication
• Continuous Learning
• Contributing to team success
• Customer Focus
• Decision Making 

 
If you meet the above requirements and are interested in pursuing this opportunity, kindly apply online or email your detailed CV.