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 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 (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 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 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 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 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.
- Medical, Health & Social Care
- Pharmaceutical Sector
#J-18808-Ljbffr
