Line Cook

Afrocentric Group; Gauteng; On-site; ZAR 40,000 - 80,000; Full time

Job summary

An established industry player is seeking an ETL Developer to enhance its data warehouse capabilities. In this role, you will design and implement ETL pipelines, ensuring that all business requirements are met while adhering to project standards. You will analyze system functions, provide operational support, and recommend improvements to enhance efficiency and quality. If you have a passion for data and a proven track record in data warehousing and programming, this is an exciting opportunity to make a significant impact in a dynamic environment.

Qualifications

• 5-10 years' experience in programming and database design.
• Knowledge of ETL tools and Data Warehousing.

Responsibilities

• Design, develop, and implement ETL pipelines and support BI solutions.
• Analyze new functions and ensure operational support.

Skills

Data Modeling

Task Management

Communication

Problem-Solving

Attention to Detail

Customer Focus

Numerical Ability

Education

Diploma/Degree in IT

Degree in Computer Science

Tools

DataStage 8.2+

UNIX

Job description

ETL Developer Job Description

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

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 & Responsibilities

1. Accountabilities: Design, code, debug, and correct programs to ensure business requirements are met.
2. Analyze the effect of new functions on the existing system, prepare test cases according to the System Development Lifecycle methodology, and conduct thorough in-house testing per operational procedures.
3. Implement practical solutions that utilize specialist and departmental systems and processes.
4. Provide input and recommendations to improve efficiency, compliance, and quality objectives related to the area of specialization.
5. Identify problems and develop solutions to present to leaders or stakeholders.
6. Ensure operational support is provided to enhance performance.
7. Cost containment: Support the identification, development, and implementation of cost-effective processes to increase efficiency and reduce costs.
8. Review cost/benefit and ROI within the area of specialization.
9. Drive customer-centricity: Support improved delivery by understanding client and stakeholder needs, satisfaction, and service delivery.
10. Knowledge management: Share and maintain knowledge within the organization, provide training as needed.
11. Maintain expertise level: Engage with professional bodies and meet CPD requirements annually.
12. Network key relationships: Engage with internal and external resources and partners.
13. Specialist support to projects: Provide expertise, ensure best practices, and represent the department on committees.
14. Specific deliverables: Design, develop, and implement ETL pipelines, debug programs, perform performance tuning, support BI solutions, analyze new functions, and ensure operational support.

Competency Requirements

• Credibility: Lead with integrity and build trust.
• Entrepreneurship: Improve customer experiences.
• Influence: Engage with customers and colleagues.
• Collaboration: Build networks and share knowledge.
• Ownership: Make decisions aligned with organizational and customer interests.
• Knowledge: Understand SDLC methodology and relevant legislation.
• Skills: Task management, data modeling, communication, business writing, system design, attention to detail, problem-solving, customer focus, numerical ability.

Experience & Qualifications

• 5-10 years' experience in programming, database design, and system analysis.
• 5-10 years' experience in Data Warehousing.
• Knowledge of ETL tools (DataStage 8.2+).
• Basic UNIX scripting skills.
• Diploma/Degree in IT, Computer Science, or related field (3-4 years).

Package & Remuneration: Competitive.