ETL Developer (Cobol & DB2)

ETL Developer (Cobol & DB2)

Job Title: ETL Developer (Cobol & DB2)
Location: Western Cape
Salary: 330000.00
Reference: JN -042017-8136
Job Published: April 07, 2017 11:25

Job Description

Key Responsibilities Purpose:
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. 
  • 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