Informatica IDMC

Job Description

Strong hands-on experience with Informatica IDMC, especially Cloud Data Quality and Cloud Data Profiling.

Practical experience building rule specifications, mappings, dictionaries, reusable DQ assets, profiling tasks, scorecards, exception management, and monitoring processes.

Strong understanding of data quality dimensions, rule design, thresholds, controls, root-cause analysis, remediation, and data-quality KPIs.

Proficiency in SQL for profiling, reconciliation, source validation, test-data preparation, and defect analysis.

Experience with cloud data lakes and file-based ingestion, preferably Azure Data Lake Storage Gen2, CSV-based landing patterns, and enterprise data pipelines.

Experience integrating IDMC with relational databases, ERP systems, cloud platforms, catalog/metadata capabilities, and downstream reporting solutions.

Working knowledge of data governance concepts, including CDEs, business glossaries, stewardship, technical metadata, lineage, policy linkage, workflows, and data marketplaces.

Ability to create clear technical specifications, rule inventories, traceability documents, test evidence, deployment guides, and runbooks.

Preferred Experience

5+ years of overall data management, data engineering, or data quality experience, including at least 2-3 years of hands-on Informatica cloud data quality implementation.

Experience delivering enterprise DG/DQ programs through phased or sprint-based rollouts.

Experience working with SAP source data or SAP-to-data-lake integration patterns.

Exposure to Informatica Cloud Data Governance and Catalog, metadata scanning, lineage, workflow, and marketplace capabilities.

Experience supporting Power BI or other DQ monitoring dashboards.

Experience in energy, petrochemicals, manufacturing, or similarly complex regulated environments is an advantage.