Data Engineer II

FNB South Africa; Cape Town; On-site; ZAR 60 000 - 100 000; Full time

Job summary

An established industry player is on the lookout for a skilled Data Engineer II to join their team in Cape Town. In this pivotal role, you will design and implement Master Data Management solutions using Informatica, ensuring high-quality data governance and integration across various business domains. Your expertise in SQL and data modeling will be crucial as you collaborate with cross-functional teams to optimize data pipelines and enhance data quality. This position offers a unique opportunity to contribute to impactful data initiatives while working in a dynamic and innovative environment.

Qualifications

• 5+ years of experience in enterprise data engineering or MDM development.
• Hands-on experience with Informatica MDM Suite and SQL.
• Strong understanding of MDM concepts and data quality.

Responsibilities

• Design and implement MDM solutions with Informatica MDM.
• Develop ETL processes and data pipelines for master data management.
• Collaborate with data stewards to improve data quality.

Skills

Informatica MDM

SQL

Data Governance

ETL Processes

Data Modeling

Agile Methodologies

Collaboration Skills

Education

Bachelor's degree in Data Engineering

Bachelor's degree in Data Science

Bachelor's degree in Information Management

Tools

Informatica PowerCenter

Informatica Cloud

Git

JIRA

Job description

Job title : Data Engineer II

Job Location : Western Cape, Cape Town Deadline : May 29, 2025

Job Description

This role involves ensuring effective movement, collection, integration, storage, and provisioning of data to meet business objectives. It requires collaboration with stakeholders such as Enterprise Architecture, Database and Solution Architects, Business Intelligence Developers, Data Scientists, and Product Owners.

Hello, future Data Engineer II

We are seeking an experienced Data Engineer II with expertise in Master Data Management (MDM). The candidate will design, build, and maintain MDM solutions supporting enterprise data governance and quality initiatives. Proficiency in Informatica, strong SQL skills, and experience in end-to-end MDM implementations are essential.

This position demands a deep understanding of the data development lifecycle, data modeling, and MDM best practices to ensure high-quality master data across business domains.

Key Responsibilities

MDM Solution Design & Implementation

• Design and implement MDM solutions with Informatica MDM and related tools.
• Develop data pipelines, ETL processes, and integration workflows for master data management.
• Define match/merge rules, survivorship logic, and hierarchy strategies.
• Collaborate with data architects on scalable data models and reference data structures.
• Utilize APIs (e.g., SIF) for integration.
• Engage with end users and stakeholders to understand requirements.
• Assist in gap analysis, business cases, and effort estimations.
• Participate in architecture forums as needed.
• Develop best practices and guidelines for tool usage.
• Foster collaborative relationships across teams.

Data Development Lifecycle

• Participate in all phases of data profiling, ingestion, transformation, testing, deployment, and monitoring.
• Ensure practices adhere to governance, security, and compliance standards.
• Maintain and optimize data integration frameworks.
• Learn from SMEs and stay updated on technical environments.

Data Governance & Stewardship Support

• Collaborate with data stewards and governance teams to improve data quality.
• Implement validation, cleansing, and exception handling.
• Maintain data lineage, metadata, and quality documentation.

Performance Optimization & Maintenance

• Monitor and improve MDM performance and scalability.
• Troubleshoot data and system issues.
• Maintain documentation and follow DevOps practices for releases.

Minimum Requirements

• Bachelor's degree in Data Engineering, Data Science, or Information Management.
• At least 5 years of relevant experience in enterprise data engineering or MDM development.
• Hands-on experience with Informatica MDM Suite.
• Proficiency in MSSQL, including complex queries and tuning.
• Experience with full lifecycle MDM solutions.
• Strong collaboration skills across teams.
• Understanding of MDM concepts like golden records, survivorship, and data quality.
• Experience with ETL tools (Informatica PowerCenter, IICS) and system integration.
• Knowledge of data modeling and ER diagrams for MDM domains.
• Experience working in Agile environments with tools like Git and JIRA.

Preferred Qualifications

• Experience with other MDM platforms (Informatica Cloud, etc.).
• Knowledge of Semarchy or similar MDM tools.
• Understanding of data privacy and governance frameworks (e.g., DAMA-DMBOK).
• Familiarity with data cataloging and metadata tools.
• Scripting skills in Python or Shell for automation (advantageous).
• Experience in research or data analysis roles.