About the Role
This role involves working as a key member of an agile team to develop and maintain robust Extract, Transform, Load (ETL) processes. These processes will extract data from various sources, transform it into a usable format, and load it into our data warehouse or other target systems.
The successful candidate will be responsible for communicating with business analysts and subject matter experts to define, understand, and document business requirements. They will design, code, and document complex programs and scripts from agreed specifications using agreed standards and tools.
This position requires the ability to identify and manage risks that are likely to affect the delivery of system releases. The candidate must also develop estimates of effort and duration for development tasks, monitor their own progress, and continually improve estimating accuracy.
The role involves reporting on progress, anomalies, risks, and issues associated with allocated development tasks. Additionally, the successful candidate will contribute technical expertise to requirements analysis to enhance the quality of solution design and improve solution processes within the organization.
Key Responsibilities
* Design, develop, and maintain ETL processes to extract data from various sources.
* Communicate with business analysts and subject matter experts to define and document business requirements.
* Develop and implement solutions to complex problems using programming languages and techniques.
* Monitor and report on project progress, identifying and mitigating risks as necessary.
* Collaborate with the team to ensure effective communication and knowledge sharing.
Requirements
* Proven experience in developing and maintaining ETL processes using DataStage, SQL, and other related tools.
* Knowledge of RDBMS databases such as DB2 and experience in dimensional modeling.
* Experience in working with agile methodologies and version control systems.
* Relevant qualification in information management, ICT, IT, or a related field.