site design templates

ETL Technical Lead

ETL Technical Lead

City: Johannesburg, Linksfield, Edenvale


A client based in the north eastern suburbs of Johannesburg is recruiting an ETL Technical Lead to work for the organisation on a permanent basis.

Key Job Responsibilities

  • Orchestrate integration projects and corresponding strategies between business units, data stewards and development teams
  • Ensure that integration projects meet business requirements and goals, fulfil end-user requirements, and identify and resolve systems issues
  • Develop standards and processes to support and facilitate integration projects and initiatives
  • Revise data integration architectures when required to be compatible with changing business needs and client standards so that all legal, compliance and operational requirements, such as data security and privacy policies are accounted for
  • Maintain high standards of data quality through the introduction and enforcement of information handling processes and organisation of the data integration processes
  • Collaborate with Business Intelligence Specialists to establish overarching strategies and Service Oriented Architecture
  • Conduct research on emerging data integration products, languages and standards in support of procurement, development, security and integration efforts in relation to Business Intelligence, Big Data Management and Master Data Management
  • Manage the selection, deployment and maintenance of data integration tools for the organisation
  • Lead testing phase of data integration development in order to identify and remedy potential problem areas
  • Liaise with developers as well as specialists within the team to address issues in data patterns and ETL architecture
  • Build relationships with development and infrastructure engineering teams to gain an understanding of different data architectures and required functionality
  • Build solutions to monitor, measure and manage the data integration process within the Surveillance Data Warehouse.


Minimum Requirements and Key Competencies

  • Four-year University Degree in Information Technology, Engineering or Biological Sciences (Masters’ Degree is desirable)
  • Relevant technical certifications e.g. Informatica, Datastage (highly advantageous)
  • Data quality training
  • Minimum of 15 years’ experience in informatics
  • 10 -12 years’ of experience using relational databases e.g. Oracle, IBM, Netezza, SQL Server
  • 10-12 years’ of experience structured/procedural query language (SQL and PL/SQL) and use of data query tools
  • 10 -12 years’ in data warehousing and/or data analysis and/or data quality
  • 10-12 years’ experience in the development of data integration solutions using enterprise tools e.g. Informatica or Datastage
  • Five years’ Informatica experience
  • Proven experience in overseeing the linking of cross functional databases between disparate business units and systems
  • Experience with business and technical requirements analysis and data mapping
  • Extensive experience with data integration architectures
  • Technically fluent in programming languages, including PL/SQL, XML and OS (Microsoft and Linux) scripting
  • Knowledge of relational database design and data modeling
  • Good project management skills and/or substantial exposure to project-based work structures, project lifecycle models etc.
  • Knowledge of network protocols and standards, including firewalls and secure file transfer protocols
  • Knowledge of data quality management practices
  • Knowledge of Python and or R
  • Experience specific to healthcare industry would be desirable
  • Exposure to an LIS (Laboratory Information System) would be desirable