Senior Etl Developer

Discovery Limited; Gauteng; On-site; ZAR 600 000 - 900 000; Full time

Job summary

A leading company in the healthcare sector is seeking a Senior ETL Developer to construct complex Business Intelligence assets and mentor junior developers. The ideal candidate will have extensive experience in software development and data warehousing, with a strong focus on SQL and ETL processes. This role offers the opportunity to work in a dynamic environment that values innovation and personal growth.

Qualifications

• Minimum 10-15 years in software development for large entities.
• At least 10 years in Data Warehouse code development.
• Understanding of star schema design.

Responsibilities

• Construct complex Business Intelligence assets and mentor junior developers.
• Translate Source to Target Mappings into error-free executable code.
• Ensure application functions as required by business.

Skills

SQL proficiency

Software architecture

Data modeling

Batch execution understanding

Monitoring production dead times

Education

Tertiary degree (B.Eng, B.Com, BSc)

MOF or equivalent

Tools

MS SSIS

SQL Server

Oracle

T/SQL

PL/SQL

Job description

Select how often (in days) to receive an alert :

Senior ETL Developer

Business Unit :

Discovery Health

Date :

15 May

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 Responsibilities

1. Construct complex Business Intelligence assets based on specifications from BI Architects and System Analysts, including mentoring junior developers.
2. Translate Source to Target Mappings into error-free executable code.
3. Find effective software solutions to technical issues.
4. Ensure application functions as required by business.
5. Release source code with zero defects.
6. Coach developers during code reviews to adhere to BI coding standards and reflect business objectives.
7. Respond to escalated incidents from support teams.
8. Perform unit testing and fix defects.
9. Review error logs and update systems/BI analysts on fixes.
10. Assist in defect review and resolution during testing phases.
11. Manage standby duties and handle production defects.
12. Collaborate with System Analysts to develop technical specifications.
13. Maintain all code and resolve batch failures within SLAs.
14. Review and amend ETL architecture as needed.

Knowledge and Skills

• Processes: SDLC, ITIL (Incident, Change, Release, Problem Management)
• Technologies: SQL Server, Oracle, T/SQL, PL/SQL, SSIS, SSAS
• Other: Software architecture, JAD facilitation, data modeling, archiving strategies
• Health Insurance knowledge (advantageous)
• Batch execution understanding for production databases
• Experience with Type 2 and Type 3 dimensions, waterline, catch-up functionality
• Metadata management in packages and code
• Monitoring production dead times and applying solutions
• Design review participation
• Code review and amendments for production deployment
• Developing SSIS packages

Technical Skills

• MS SSIS, SSAS, SSRS
• Database optimization techniques
• Hardware and resource management
• Solution architecture on SQL Server, Oracle, Netezza
• Software development and testing
• SQL proficiency

Personal Attributes

• Result-oriented
• Change readiness
• Time management
• Effective communication

Education and Experience

• Essential: Tertiary degree (B.Eng, B.Com, BSc) and MOF or equivalent
• Minimum 10-15 years in software development for large entities
• At least 10 years in Data Warehouse code development
• Understanding of star schema design

Employment Equity

The company's Employment Equity Plan and Targets will be considered in recruitment.

We encourage applications from people with disabilities.