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
Accountabilities:
- Design, code, debug, and correct programs to ensure business requirements are met.
- Analyse the effect of new functions on the existing system.
- Compile 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 efficiency, compliance, and quality objectives related to the area of specialization.
- Identify problems and develop and propose solutions to present to appropriate leaders or stakeholders.
- Ensure day-to-day operational support required from the area of specialization 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 the area of specialization.
- Continuously review cost/benefit and Return on Investment within the area of specialization.
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 specialization 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 organization.
Maintain expertise level:
- Be a member of related professional bodies.
- Ensure CPD (Continual Professional Development) 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 specialization is implemented in projects when required.
- Conform to project management disciplines when participating in projects.
- Represent department or project on appropriate committees related to the area of specialization.
Specific deliverables:
- 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 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 system.
- Compile 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 stakeholders.
Competency 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 organization's welfare.
- Collaboration: Build work-related networks 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 evaluation.
- Communication 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 & Qualification
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.
#J-18808-Ljbffr
