Key Responsibilities :

- Build an integration pipeline between IQVIA OneKey and the Data lake for automated, scalable data ingestion.

- Analyze OneKey extract files and formats; design ingestion patterns to support adds, updates, and deactivations (IQVIA change model).

- Design and implement ETL/ELT pipelines to transform OneKey data into Reltio-compatible structures (staging, canonical, and publish layers).

- Map OneKey entities and attributes to the Reltio data model (e.g, HCO/HCP, addresses, affiliations, identifiers, hierarchies-based on scope).

- Define and implement Reltio survivorship rules, crosswalk rules, and match/merge strategies for OneKey IDs and related identifiers.

- Implement data quality checks and validation gates leveraging DBT models (completeness, validity, referential integrity, duplicate detection, freshness, reconciliation).

- Create monitoring and alerting for pipeline health (load counts, rejects, schema drift, latency, failure handling).

- Produce runbooks and technical documentation for operational support (data mappings, rule definitions, job schedules, SLAs).

- Collaborate with MDM, data engineering, and governance stakeholders to validate outcomes and support UAT.

Job Highlights :

- We are looking for an experienced MDM / Data Integration Engineer to design and build an end-to-end integration pipeline between IQVIA One Key and data lake, and to operationalize mastered entity ingestion into Reltio.

- This role will focus on entity mapping, survivorship and matching strategies, Reltio-compatible data structures, and strong data-quality validation using DBT models