Senior ETL Developer

Discovery Limited; Johannesburg; On-site; ZAR 800,000 - 1,200,000; Full time

Job summary

A leading company in healthcare is seeking a Senior ETL Developer to construct complex Business Intelligence assets. This role involves mentoring junior developers, developing ETL architecture, and ensuring high-quality code delivery. With a strong focus on technology such as SQL, MS SSIS, and data modelling techniques, the ideal candidate will bring extensive experience in a fast-paced environment and contribute to innovative solutions.

Qualifications

• 10-15 years’ experience in software development for large commercial entities.
• At least 10 years’ experience in Data warehouse code development.
• Understanding of Integrated star schemes.

Responsibilities

• Construction of complex Business intelligence assets based on specifications.
• Mentoring and supporting junior developers.
• Conduct unit testing and fix any defects found.

Skills

SQL-Server

Oracle

T/SQL

PL/SQL

SSIS

SSAS

Software architecture

Data modelling techniques

Batch execution

Dimension modelling

Education

Tertiary degree (B. Engineer, B. Com, BSC)

MOF or equivalent contemporary development methodology

Tools

MS SSIS

SSAS

SSRS

Job description

Discovery Health

Senior ETL Developer

About Discovery

Discovery’s core purpose is to make people healthier and to enhance and protect their lives. We seek out and invest in exceptional individuals who understand and support our core purpose, and whose own values align with those of Discovery. Our fast-paced and dynamic environment enables smart, self-driven people to be their best. As global thought leaders, Discovery is passionate about innovating in order to not only achieve financial success, but to ignite positive and meaningful change within our society.

Key Purpose

Construction of complex Business intelligence assets based on specifications produced by BI Architects and System Analysts, including mentoring and supporting junior developers.

Key Outputs

• Translates and not limited to, the Source to Target Mappings into executable code without errors.
• Finds effective software solutions to technical issues.
• Ensure that the application performs the functions as required by business.
• Releases source code with zero defects.
• Actively coach other developers during the code review process to understand and apply the Business Intelligence coding standards whilst ensures that business objectives are reflected in the technical processes in which they manage.
• Respond to incidents escalated by the support teams.
• Conduct unit testing, and fix any defects found.
• Review error logs and provide systems/BI analysts with updates on fixes found in testing.
• Consult and assist the system/BI analysts in reviewing defects found in testing.
• Perform standby as required and handle any defects as raised in the production process.
• Workshop solutions with System Analysts to compile relevant technical specifications
• Maintain all code and resolve morning batch failures within SLA’s.
• Review ETL architecture and amend changes to production systems.

Personal Attributes and Skills

Knowledge:

• Processes: SDLC, ITIL (Incident, Change, Release, Problem Management)
• Technologies: SQL-Server, Oracle, T/SQL and PL/SQL, SSIS, SSAS
• Other: Software architecture, facilitating JAD sessions, data modelling techniques
• Health Insurance knowledge (advantageous)
• Excellent understanding of batch execution relating to Production databases
• Practical experience on developing Type 2 and type 3 dimensions, with waterline and catch-up functionality
• Strong ability to build Metadata into all packages and code developments.
• Maintain the development, QA and production environment waterlines.
• Monitoring dead times within the production system and apply solutions within the week.
• Participate in design reviews and code reviews
• Understanding archiving strategies within the production system.
• Make amendments to existing code and complete the delivery into production - rerun the affected artefacts and downstream dependencies.
• Develop Microsoft SSIS packages

Technical skills

• MS SSIS, SSAS, SSRS
• Database and stored procedure optimization techniques
• Hardware and resource management
• Project Management
• Dimension modelling star-schema design
• Solution Architecture on Sql server, Oracle and Netezza
• Software development and testing
• Excellent knowledge of SQL constructs, collections and variables.
• Excellent T-Sql knowledge

Behavioural skills

• Result Orientation
• Change Readiness
• Time Management
• Communication (written, verbal and listening)
• Creativeness
• Innovation

Education and Experience

Education:

• Essential: Tertiary degree (B. Engineer, B. Com, BSC)
• MOF or equivalent contemporary development methodology.

Minimum Required Experience :

• 10 to 15 years’ experience in software development for large commercial entities.
• At least 10 years’ experience in Datawarehouse code development.
• Understanding of Integrated star schemes

EMPLOYMENT EQUITY

The Company’s approved Employment Equity Plan and Targets will be considered as part of the recruitment process. As an Equal Opportunities employer, we actively encourage and welcome people with various disabilities to apply.