Job Summary

We are seeking an experienced MDM Engineer to design build and support data integration pipelines that bring contactHCP Healthcare Skilled and siteinvestigator data from Veeva CTMS into the enterprise Master Data Management MDM platform using Microsoft Fabric as the primary integration and data engineering platform. The resource will work closely with onshore data architects MDM stewards and Veeva CTMS businessfunctional teams to ensure clean deduplicated and governed contact master data

Responsibilities

Design and develop data pipelines in Microsoft Fabric Data Factory pipelines Dataflows Gen2 LakehouseWarehouse Notebooks to extract contact and related reference data from Veeva CTMS via API OData or intermediate staging layers

Build and maintain ETLELT workflows to cleanse standardize transform and load contact data into the MDM hub eg Informatica MDM Reltio SAP MDG Profisee or equivalent specify per your stack

Implement data quality match merge survivorship and deduplication rules for contactHCP master data in coordination with MDM stewards





Develop and manage medallion architecture BronzeSilverGold layers in Microsoft Fabric Lakehouse for staging curating and publishing contact master data

Collaborate with Veeva CTMS functionalbusiness analysts to understand source data structures Contacts Sites Investigators Study Roles and map them to MDM target data models

Build monitoring logging and reconciliation processes to ensure endtoend data integrity between Veeva CTMS and MDM

Support incrementalCDC Change Data Capture based syncs to keep MDM contact records current with Veeva CTMS updates

Work with securitycompliance teams to ensure data handling aligns with GxP GDPR and pharma data privacy requirements where applicable

Participate in Agile ceremonies sprint planning standups retrospectives and provide regular status updates to onshore leads

- Prepare technical documentation: data mapping specs pipeline design docs and run books

Provide L2L3 support for production data pipelines and troubleshoot data sync issues between Veeva CTMS and MDM

📌 Architect (Chennai)
🏢 Cognizant
📍 Chennai