Data Engineer II at FNB South Africa

Job Description

• To ensure effective movement, collection, integration, storage, and provisioning of data to meet business objectives through sound understanding of business unit requirements and frequent collaboration with relevant stakeholders (such as Enterprise Architecture, Database and Solution Architects, Business Intelligence Developers, Data Scientists and Product Owners, etc.)

Hello, future Data Engineer II

• We are looking for an experienced Data Engineer II with deep knowledge and experience in Master Data Management (MDM) to design, build, and maintain robust MDM solutions that support enterprise-wide data governance and data quality initiatives. The ideal candidate will be proficient in Informatica, strong in SQL development, and have a proven history of delivering end-to-end MDM implementations.
• This role requires a deep understanding of the data development lifecycle, data modeling, and MDM best practices to ensure trusted, high-quality master data across critical business domains.

Key Responsibilities

MDM Solution Design & Implementation

• Design and implement end-to-end MDM solutions using Informatica MDM and other related tools.
• Develop Data pipelines, ETL processes, and integration workflows to support the ingestion, cleansing, and distribution of master data.
• Define and implement match/merge rules, survivorship logic, and hierarchy management strategies.
• Collaborate with Data architects to design scalable MDM data models and reference data structures.
• Experience with using API’s (e.g. SIF)
• Confer with end users, clients, or senior management to understand business requirements for complex development or enhancements
• Assist with gap analysis and business cases including cost and effort analysis.
• Participate in Architecture forum (as and when required).
• Grow online technical knowledge platform, identify best practices and develop guidelines for optimum usage of tools.
• Develop, encourage and nurture collaborative relationships across area of specialisation.

Data Development Lifecycle

• Contribute to all phases of the Data development lifecycle, including data profiling, ingestion, transformation, testing, deployment, and monitoring.
• Ensure Data engineering practices follow governance, security, and compliance standards.
• Maintain and optimize data integration frameworks across source systems, MDM platforms, and downstream consumers.
• Learn from the Subject Matter Expert on technical environment or tools for own area of expertise.

Data Governance & Stewardship Support

• Work closely with Data Stewards, Governance Leads, and Business Stakeholders to support data quality initiatives.
• Implement data validation, cleansing, and exception handling mechanisms.
• Support the creation and maintenance of data lineage documentation, metadata repositories, and data quality scorecards.

Performance Optimization & Maintenance

• Monitor and tune MDM performance, scalability, and reliability.
• Troubleshoot and resolve issues related to data loads, data quality, and system integration.
• Maintain technical documentation and follow DevOps/CI-CD practices for MDM releases.

Minimum Requirements

• Qualification: A relevant bachelor's degree in Data Engineering, Data Science and/or Information management
• Experience: A minimum of 5 years relevant experience as a Data Engineer or MDM Developer in enterprise environments.
• Hands-on experience with Informatica MDM Suite.
• Strong proficiency in MSSQL, including complex queries, performance tuning, and stored procedures.
• Proven track record of implementing full lifecycle MDM solutions, from requirements to production deployment.
• Build working relationships across teams and functional lines to enhance work delivery, collaboration and innovation.
• Strong understanding of MDM concepts: golden record creation, data survivorship, data quality, metadata, and stewardship.
• Experience with ETL development (e.g., Informatica PowerCenter, IICS) and integrating MDM with multiple source/target systems.
• Familiarity with data modeling tools and entity relationship modeling for MDM domains (customer, product, vendor, etc.).
• Experience working in Agile environments and tools (e.g., Git, JIRA).

Preferred Qualifications

• Experience with MDM platforms (Informatica Suite, Informatica Cloud, etc.).
• Exposure to Semarchy or other modern MDM tools (Advantageous).
• Familiarity with data privacy, governance frameworks (e.g., DAMA-DMBOK).
• Knowledge of data cataloging, business glossaries, and metadata management tools.
• Scripting capabilities in Python or Shell for automation and orchestration (Advantageous).