Description :

Data Quality / IDMC Engineer with 4+ years of experience in Informatica CDQ/CDI, developing DQ rules, mapplets, taskflows, and scorecards. Skilled in IDMC APIs, REST integrations, Databricks, SQL Server, Azure Data Lake, and end-to-end data quality management. Experienced in Power BI integration, Python, UNIX shell scripting, and Taskflow parameterization for automation and operational support.

Location : Remote.

Shift Timing : Normal (Day Shift).

Must Haves :

- SQL : Advanced - writing & Optimization

- CDQ : Advance - Hands-On-Experience

- CDGC : Advance - Hands-On-Experience

- CDP : Advance - Data Profiling - Hands-On-Experience

Nice to Have :

- PySpark

- DataBricks & ADF

- Unix

- CDI

- Scheduling Tools - Airflow, Informatica Scheduler, Control M, Autosys, etc.

Core Experience :

- 4+ years of hands-on experience with Informatica CDQ/CDI, including development, deployment, and maintenance of data quality solutions.

- Strong ability to design and code CDQ mapplets, task flows, and DQ rules to implement validation checks and generate scorecards.

- Experience creating integrations between CDGC and CDQ/CDI to surface unified rules, metrics, and scorecards within CDGC.

- 2+ years of experience with Databricks and SQL Server, including writing optimized SQL and working with Azure Data Lake environments.

Technical Skills :

- Must have skill sets - SQL - Advanced - writing & Optimization, CDQ & CDGC - Advanced - Hands-On-Experience, CDP - Advanced - Data Profiling.

- Good to have skill sets - PySpark, DataBricks & ADF, Unix, CDI, Scheduling Tools - Airflow, Informatica Scheduler, Control M, Autosys, etc.

- Solid understanding of IDMC APIs and experience integrating external systems using REST APIs.

- Expertise across the full data quality lifecycle : profiling, validation, standardization, cleansing, error handling, and monitoring within IDMC.

- Ability to create DQ rules as mapplets and configure reusable components.

- Experience preparing DQ scorecards across multiple data quality dimensions (completeness, accuracy, consistency, timeliness, etc.).

- Ability to integrate DQ dashboards with Power BI for business-facing reporting.

- Comfortable with API-based integrations within IDMC for automation and orchestration.

- Good working knowledge of UNIX shell scripting and Python for data processing, and operational support.