ETL Developer

ETL Developer

Job Title: ETL Developer
Location: Western Cape
Salary: 320000.00
Reference: JN -012017-7496
Job Published: January 25, 2017 11:05

Job Description

Position Description 


To develop and maintain Data Warehouse and loyalty system extract transform and load (ETL) processes. To ensure that all developed processes are adequately tested, error-free and compliant with the business solution requested. To update data models and other documentation so that changes are reflected. To support and provide standby for production ETL processes.

Key Responsibilities 


  • Analysis of business requirements

  • Assessing feasibility & impacts

  • Advising & recommending on appropriate solutions

  • Communication with clients in terms of requirements
  • Analysis of change requests received for own systems and interfaces with other systems
  • Recommendations and cost / man-day estimates for implementing changes
  • Analysis and documentation of changes required to systems (functional and/or technical specifications)
  • Interpretation of specifications received (includes data models), if applicable
  • Design of prototypes as required
  • Maintenance of existing programs according to change requests
  • Development of new programs according to change requests
  • Testing of own programs to ensure correctness
  • Testing of interfaces to other systems, if applicable
  • Debugging of programs
  • Provision of test information to Business Solutions (testers), if required
  • Implementation of changes into the production environment, as part of the change management process
  • Documentation of changes implemented and programs
  • Updates of data model documentation
  • Publishing of documentation as required to a central point
  • Problem solving and user assistance for own systems supported (functional, not technical)
  • Technical support assistance to others on own technology.
  • Provision of user guides / training material for own system and changes being implemented
  • Provision of hands-on training for own system and changes being implemented
  • Provision of standby time / support including night support
  • Support and assistance with DRP(Disaster Recovery Process)
  • Correction of errors / bugs in production
  • Knowledge of systems interfaced with
  • Management of own time and delivery of tasks according to deadlines
Minimuim Requirements 1. Qualifications:
  • Grade 12
  • Relevant Information Technology Qualification

2. Experience:

  • At least 2 years IT Development & maintenance experience

  • Must have strong extract, transform and load (ETL) Development maintenance experience working with an ETL tool

  • Must have strong database skills (preferable DB2)

3. knowledge:

Knowledge and understanding of :

  • Databases (e.g. DB2)

  • SQL

  • Extract, transform and load (ETL) Development

Knowledge of the following  will be advantageous:

  • Business Intelligence (Data Warehouse modelling, ETL tools - DataStage, Reporting)
  • UNIX (basic scripting)
  • Programming in C/C++ or Java in a Unix environment


  • Communication

  • Building Relationships

  • Building customer loyalty

  • Influencing

  • Innovative thinking

  • Problem solving

  • Strong Interpersonal and people interaction skills

  • Analytical Skills

  • Adaptability

  • Continuous Learning

  • Team Success

  • Results Driven

  • Developing Others

  • Customer Service

Get similar jobs like these by email

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