ETL Developer Data Warehouse at Sanlam Group

What will you do?

• 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
• 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
• Debugging of programs
• Implementation of changes into the production environment, as part of the change management process
• Documentation of changes in programs implemented
• 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)
• Provision of hands-on training for own system and changes being implemented
• Provision of standby time / support over week-ends and at year-end
• Correction of errors / bugs in production
• Support and assistance with DRP(Disaster Recovery Process)
• Management of own time and delivery of tasks according to deadlines

What will make you successful in this role?

Qualifications
Role Requirements:

• Grade 12
• A tertiary qualification will be advantageous

Experience

• 3 years IT experience
• Must have strong DB2 skills
• Experience in working with life Insurance product/asset data
• ETL experience essential
• Strong database background on DB2, using it as source and target of data. Develop SQL DDLs to validate testing of the completeness and accuracy of data during data loads and testing
• Linux environment

Knowledge
Knowledge and basic understanding of:

• Understanding and Experience of an Atomic Data Warehouse would be advantageous
• Warehousing in terms of ETL processes
• Business Objects
• SQL
• DB2
• SAP Hana knowledge would be advantageous
• DataStage essential (intermediate level)
• Linux scripting would be advantageous

Competencies

• Accountability
• Customer Service
• Communication
• Adaptability
• Innovation
• Continuous Learning
• Results Driven
• Interpersonal skills

Closing Date: 20th, May 2022