An exciting vacancy exists in Sandringham for a Senior Developer: ETL .

Key Job Responsibility

• To develop and maintain new and existing data marts and ETL processes which enable the acquisition of source system into CDW
• To ensure integrity of data from the source systems into the respective marts in the CDW to ensure accuracy of the reporting from CDW
• To develop new functionality in order to support the broader stakeholder business intelligence
• To assist in the development and maintenance of business intelligence back end processes in order to provide the foundation for data transformation and data cleansing.
• To assist with data aggregation in order to optimize performance and improve end user experience.
• To support the collection, integration and transformation of large volumes of data with data structures ranging from simple to highly complex in order to process the laboratory information
• To utilize methods in the data integration environment that maximise speed flexibility and effectiveness when building, deploying and updating data warehouse objects
• To liaise with users, analysts and support staff in order to maximise the efficiencies of the CDW team
• To collaborate or actively test new development to ensure accuracy of information
• To mentor junior members of the team.

Minimum requirements & key competency

• National Diploma/ Degree in Information Systems or Computer Science
• Post graduate qualification in data warehousing / ETL
• Minimum 4 years’ experience in data warehousing/ETL
• Inclusive of 4 years practical Data Warehouse Development Life Cycle and SQL programming
• Trouble shooting with Information ETL design tool
• Oracle database/ other mainstream relational database/ data warehouse appliance
• Knowledge of Informatics
• Dimensional Data modelling and design understanding
• ETL development knowledge
• Knowledge of methodologies underlying data warehouse development
• Knowledge of data warehouse 

Ref: JHB005072/SM