Data Engineer (Contract) – Isando Onsite/Offsite rotation – SO63W6565
| Location | Isando, South Africa |
| Date Posted | January 10, 2023 |
| Category |
Engineering
|
| Job Type |
Full-time
|
| Currency | ZAR |
Description
Our client requires the services of a Data Engineer
POSITION: Contract role for 3 months
COMMENCEMENT: Must be able to start ASAP.
Duties & Responsibilities
THE ROLE:
The primary responsibility for the role is to be a data engineer in the EPM programme responsible for data migration, designing and building ETL jobs/data pipelines, building data quality into processes, writing complex SQL queries, designing data models, perform data analysis and profiling.
Key deliverables and outputs
Develop Informatica and SAP Data Services ETL jobs.
Write Teradata jobs and queries.
Create Teradata tables, views, indexes and databases.
Collaborate with project and business teams.
Implement processes and systems to monitor data quality, ensuring production data is always accurate.
Write unit/integration tests, contribute to data engineering wiki, and document work.
Perform data analysis required to troubleshoot data related issues and assist in the resolution of data issues.
Design data integration solutions and error handling approaches for solutions.
Maintain technical and operational metadata during data solution development.
Has experience in advanced query performance and query optimisation.
Can develop complex SQL to implement complex business logic.
Translate the functional requirements to high level design and build technical specifications document.
Desired Experience & Qualification
REQUIREMENTS:
- Minimum 3 years’ experience in Informatica ETL development
- Minimum 2 years’ experience in SAP Data Services ETL development.
- Minimum 3 years’ experience in Teradata development including writing jobs & queries, creating tables, views, indexes and databases.
- Data analysis & profiling
Advantageous:
- Familiar with Group data environment
- Data analytics & mining
Essential Skills:
- Data Modelling
- SQL Skills
- DATA Analysis
Advantageous
- Financial Knowledge
- SAP background
- Kerridge Background