DataStage Analyst Developer at Sanlam Group

What will you do?

Job Purpose:

• Analysis of change requests received for own systems and interfaces with other systems.
• Work with Business Analysts to provide input to estimations of T-Shirt sizes for proposed changes. 
• Analysis and interpretation of specifications and changes required to systems, including data models where applicable. 
• Maintenance of existing programs according to change requests
• Development of new programs according to change requests
• Optimising data transformation programs for efficiency or incorporating new changes. 
• Debugging and testing of own programs to ensure correctness.
• Testing of interfaces to other systems and/or upgrade testing
• Implementation of changes into the production environment, as part of the change management process
• Ensuring the wiki is updated to reflect all features, including functional and technical perspectives. 
• Updates of data model documentation
• Documentation of changes in programs implemented.
• 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
• Providing coaching/training to junior team members

What will make you successful in this role?

Role Requirements:
Qualifications:

• 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:

• DataStage essential (intermediate level)
• Data Warehousing
• Warehousing in terms of ETL processes
• Business Objects
• SQL
• DB2
• Linux scripting would be advantageous

Competencies:

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

Qualification and Experience

• Degree or Diploma and the required Certification with 6 to 8 years related experience.

Personal Attributes

• Decision quality - Contributing independently
• Interpersonal savvy - Contributing independently
• Plans and aligns - Contributing independently
• Optimises work processes - Contributing independently