Data Development Engineer

SUMMARY:
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. 3-4 Years Diploma/Degree in Information Technology, Computer Science or data related qualifications.
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. Cloud-based data storage solutions like AWS and Azure.
Technical ETL expertise in creating star schema data models.
Administration of DataStage 8.2 and above.
Certified Data Management Professional (CDMP).

POSITION INFO:
Key Responsibilities

• 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.

• 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.

• 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

• 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.

• Be a member of related professional bodies.
• Ensure CPD (continual professional development) or similar accreditation requirements are met annually to ensure maintained specialist accreditation.

• Engage with and provide support to the established network of internal and external expert resources and partners.

• 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 area of specialization.

• 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

• 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.

• Be a member of related professional bodies.
• Ensure CPD (continual professional development) or similar accreditation requirements are met annually to ensure maintained specialist accreditation.

• Engage with and provide support to the established network of internal and external expert resources and partners.

• 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 area of specialization.

• 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.

• Make critical decisions based on what's right for Customers - Owning operational decisions and knowing oneself

• Knowledge and application of the System Development Life Cycle (SDLC)methodology.
• Knowledge and application of relevant legislation

• Task Management.
• Data modelling and evaluation.
• Computer Technology.
• Business Writing.
• System design and development.
• Attention to Accuracy and Detail.
• Problem solving and decision-making.
• Customer Focus.