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.
 
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

 
Requirements
Qualifications

• Grade 12
• Relevant Information Technology Qualification

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)

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

 
Competencies

• 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