SUMMARY:
ETL/ELT Developer-JHB-OnSite-12 Month Contract
POSITION INFO:
ETL/ELT Developer
Location
Gauteng, Johannesburg
Job Type
Contract – Full-Time hours
Primary Industry
Banking and Finance
Job Description
The ETL/ELT Developer is responsible for designing, developing, and maintaining efficient Extract, Transform and Load (ETL) or Extract, Load and Transform (ELT) processes to support data integration and data warehousing needs within the banking and finance sector. This role involves working closely with business analysts, data architects, and other technical teams to ensure data quality, integrity and availability for reporting and analytics purposes. The postholder ensures that data movement processes adhere to organisational standards and regulatory requirements.
Job Duties
- Build mappings, transforms and loads
- Develop, test, and implement ETL/ELT workflows to extract data from multiple source systems and transform it according to business requirements.
- Maintain and optimise existing ETL/ELT processes to improve performance and reliability.
- Collaborate with data architects and analysts to design data models and ensure accurate data mapping and integration.
- Ensure data quality by performing validation, reconciliation, and error handling during data processing.
- Monitor ETL/ELT jobs and troubleshoot issues promptly to minimise downtime.
- Document ETL/ELT processes, standards, and best practises for reference and compliance purposes.
- Support data governance initiatives by adhering to data security and privacy policies.
- Participate in code reviews, testing phases, and deployment activities to ensure robust delivery.
- Stay up to date with developments in ETL/ELT tools and industry best practises, recommending improvements where appropriate.
Required Qualifications
- Informatica/Datastage.dbt/Matillion., SQL
- Strong experience in ETL/ELT development within a banking or financial services environment.
- Proficiency in ETL tools such as Informatica, Talend, Microsoft SQL Server Integration Services or similar.
- Solid understanding of relational databases and SQL, including optimisation techniques.
- Experience with data warehousing concepts and dimensional modelling.
- Knowledge of data governance, data quality frameworks, and regulatory compliance requirements.
- Ability to write clear and maintainable technical documentation.
- Familiarity with scripting languages such as Python, Shell scripting or similar is advantageous.
- Strong analytical and problem-solving skills with meticulous attention to detail.
Education
- A degree in Computer Science, Information Technology, Data Science, or a related discipline is preferred.
- Relevant professional certifications in ETL tools or data management are advantageous.
Experience
- A minimum of three to five years’ experience in ETL/ELT development within a complex data environment.
- Proven track record of delivering ETL/ELT solutions in the banking and finance sector is highly desirable.
- Experience working on contract assignments or within fast-paced project teams is beneficial.
Knowledge and Skills
- Comprehensive knowledge of data extraction, transformation, and loading processes.
- Strong SQL skills with the ability to write optimised queries and troubleshoot performance issues.
- Understanding of data warehousing methodologies and architecture.
- Familiarity with cloud-based data platforms and modern data integration techniques is a plus.
- Excellent communication skills to liaise effectively with both technical and non-technical stakeholders.
- Ability to manage multiple priorities and work independently within a structured environment.
- Attention to detail to ensure data accuracy and compliance with standards.
Preferred Qualifications
- Experience with big data technologies and frameworks such as Hadoop, Spark or similar.
- Knowledge of programming languages such as Java or Scala.
- Understanding of regulatory frameworks applicable to banking data, including data protection legislation.
- Previous experience within a financial institution or related sector.
Working Conditions
The role is based in Johannesburg and requires full-time hours with the possibility of remote work on occasion, subject to project requirements. The position involves working primarily in an office environment with standard working hours; however, flexibility may be required to meet deadlines or resolve critical issues. The candidate must be able to work collaboratively within diverse teams and communicate effectively across different departments. Occasional extended hours may be necessary to support deployments or system maintenance.
