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. Accountabilities: Continuous improvement - Design, code, debug and correct programs to ensure business requirements are met - new and maintenance - Analyse the effect of new functions on the existing system - Compile test cases according to System Development Lifecycle methodology and conduct thorough inhouse 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 leader 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 Generic Objectives Specific deliverables: Continuous improvement: -Design and produce art and copy layouts for material to be presented by visual communications media -Prioritise, track, handle, and maintain records of the elements, costs, and time schedules of multiple projects -Design, code, debug and correct programs to ensure business requirements are met; new and maintenance -Analyse the effect of new functions on the existing system -Compile test cases according to System Development Lifecycle methodology and conduct thorough inhouse testing per operational procedure Drive customer centricity: -Consult with client or supervisor to evaluate individual project needs Position Specific Outputs -Design, development and implementation of ETL pipelines. -Debug and correct programs to ensure business requirements are met, this includes 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 inhouse 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 -Living the values and being transparent -Entrepreneurship: Take chances to continuously improve our Customer's experiences -Driving operational efficiencies -Influence: Engage with Customers and colleagues to advance the organisation's welfare -Making work happen -Collaboration: Build work-related network and share knowledge with colleagues -Building networks -Ownership: Make critical decisions based on what's right for AfroCentric and Customers -Owning operational decisions and knowing oneself Knowledge -Knowledge and application of the System Development Life Cycle (SDLC)methodology -Knowledge and application of relevant legislation Skill -Task Management -Adobe Creative Suite -Data modelling and evaluation -Computer Technology Skills -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 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. Competitive. Apply Now

Share this job with someone you think should apply!

Facebook

Development Engineer Roodepoort - Roodepoort

Related Jobs

Specialist Roodepoort - Roodepoort

Team Leader Operations Roodepoort - Roodepoort

Sap Business Analyst Roodepoort Settlement, South Africa - South Africa

Nurse Roodepoort - Roodepoort

Quality Technician Roodepoort - Roodepoort

Want to do another search?