Development Engineer Roodepoort

Afrocentric Group; Gauteng; On-site; ZAR 200 000 - 300 000; Full time

Job summary

A leading health solutions provider in Gauteng is seeking an experienced ETL Developer to enhance their data warehouse system. The role involves developing ETL pipelines, ensuring performance tuning, and providing operational support for business intelligence solutions. Candidates should have 5-10 years of experience in data warehousing and strong SQL/PLSQL skills. This position offers a competitive package along with medical and health benefits.

Benefits

Medical insurance

Health and social care benefits

Qualifications

• 5-10 years' experience in programming and understanding of database design.
• Minimum of 5-10 years Data Warehousing experience.
• Knowledge of system development lifecycle (SDLC) methodology.

Responsibilities

• Develop and enhance the back-end of the data warehouse.
• Design, code, debug and correct programs to meet business requirements.
• Implement and support BI solutions and performance tuning.

Skills

Programming

Database design

SQL/PLSQL knowledge

Data Warehousing

ETL Tool knowledge (DataStage)

Basic UNIX scripting

Data modelling

Problem-solving

Education

3-4 Years Diploma/Degree in Information Technology or Computer Science

Job description

Overview

ETL Developer Job DescriptionThe purpose of the ETL Developer is to develop extraction, translation and loading jobs which will populate the Data Warehouse.

Responsibilities

Develop and enhance the back-end of the data warehouse to satisfy specified and agreed user requirements in conformance with standards, time and cost parameters agreed for each project / request.

Duties & ResponsibilitiesAccountabilities : Design, code, debug and correct programs to ensure business requirements are met. Analyse the effect of new functions on the existing systempile test cases according to System Development Lifecycle methodology and conduct thorough in-house testing per operational procedure. Implement practical solutions that use the specialist and departmental systems and processes. Provide specialist input and recommendations to improve the efficiency, compliance and quality objectives related to the area of specialisation. Identify problems and develop and propose solutions to present to appropriate leaders or stakeholders. Ensure day-to-day operational support required from area of specialisation is provided to enhance performance.

Cost Containment : Support the identification, development and implementation of cost-effective processes to increase efficiency and reduce cost drivers related to area of specialisation. Continuously review cost / benefit and Return on Investment within area of specialisation. Drive Customer-Centricity : Maintain a high level of impact on other departments to support improved delivery. Continually increase understanding of client and stakeholder needs, satisfaction and service delivery.

Knowledge Management : Ensure that adequate knowledge regarding specialisation is shared as required and maintained within the research library. Provide advice and / or training as required. Maintain, develop and implement specialist knowledge within the day-to-day operations of the organisation. Maintain Expertise Level : Be a member of related professional bodies. Ensure CPD or similar accreditation requirements are met annually to ensure maintained specialist accreditation. Network Key Relationships : Engage with and provide support to the established network of internal and external expert resources and partners.

Specialist Support to Projects : Provide specialist expertise and ensure best practice related to specialisation is implemented in projects, when required. Conform to project management disciplines when participating in projects. Represent department or project on appropriate committees related to area of specialisation. Position Specific Outputs : Design, development and implementation of ETL pipelines. Debug and correct programs to ensure business requirements are met, including new and maintenance work. Performance tuning of long-running queries and recommending any performance improvement strategies. Performing data extracts. Support implemented BI solutions by monitoring data loads, addressing user questions concerning data integrity, doing performance tuning, archiving strategy and communicating functional and technical issues. Analyse the effect of new functions on the existing systempile test cases according to System Development Lifecycle methodology and conduct thorough in-house testing per operational procedure. Ensure day-to-day operational support, identify problems and propose solutions to be presented to appropriate leaders or stakeholderspetency Requirements : Attribute : Credibility : Lead with integrity and trust others as you would like to be trusted. Entrepreneurship : Take chances to continuously improve our Customer's experiences. Influence : Engage with Customers and colleagues to advance the organisation's welfare. Collaboration : Build work-related network and share knowledge with colleagues. Ownership : Make critical decisions based on what's right for AfroCentric and Customers. Knowledge : Knowledge and application of the System Development Life Cycle (SDLC) methodology. Knowledge and application of relevant legislation. Skill : Task Management. Data modelling and evaluationmunication Skills. Business Writing Skills. System design and development skills. Attention to Accuracy and Detail. Problem solving and decision making skills. Customer Focus. Numerical Ability.

Desired Experience & Qualifications

Experience : 5-10 years' experience in programming, understanding of database design and system analysis. Minimum of 5-10 years Data Warehousing experience. SQL / PLSQL knowledge essential. ETL Tool knowledge (DataStage 8.2 and above). Data Modelling Tool Experience preferred. Basic UNIX scripting. Qualifications : 3-4 Years Diploma / Degree in Information Technology, Computer Science or data-related qualifications.

Package & Remuneration

Competitive. Medical, Health & Social Care. Pharmaceutical Sector.