DataStage Developer at Vito Solutions

DESCRIPTION OF POSITION:

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

KNOWLEDGE AND SKILLS:

• DataStage essential (intermediate level)
• Data Warehousing
• Warehousing in terms of ETL processes
• Business Objects
• SQL
• DB2

Competencies:

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

QUALIFICATIONS REQUIRED:

• Matric

EXPERIENCE REQUIRED:

• 3 years of IT experience
• Must have strong DB2 skills
• Experience in working with life Insurance product/asset data
• ETL experience essential
• Strong database background in DB2, using it as a 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

ADVANTAGEOUS SKILLS:

• Linux scripting
• A tertiary qualification