Informatica IDMC Data Quality Developer

Dautom; Riyadh; On-site; SAR 180,000 - 240,000; Full time

Job summary

Dautom in Riyadh, Saudi Arabia seeks an Informatica IDMC Data Quality Developer to design, implement, and maintain data quality rules for KPI-driven projects. You will collaborate with a major client and internal teams to ensure data accuracy and timeliness across data pipelines.

You will profile data, build DQ mappings and scorecards, validate KPI results, and support deployments. 4–6 years of relevant experience is preferred.

Qualifications

• Hands-on experience with Informatica IDMC / Cloud Data Quality.
• Strong understanding of data warehousing and ETL/ELT concepts.
• Experience with data profiling and data quality dimensions.
• Experience in developing DQ rules, mapplets and exception handling.

Responsibilities

• Analyze project KPI requirements and translate them into data quality rules and validation checks.
• Perform data profiling across source systems, data warehouse/data lake and KPI datasets.
• Develop and configure Informatica IDMC Data Quality mappings, rules, profiles and scorecards.
• Validate KPI calculations and underlying datasets against source systems and approved business definitions.
• Develop SQL queries to perform independent data validation and reconciliation.
• Identify data anomalies, investigate root causes and coordinate with data/source-system teams for resolution.
• Maintain DQ rule documentation, KPI-to-source mappings and technical specifications.
• Support execution and monitoring of DQ jobs and investigate failed or unexpected results.
• Prepare DQ reports and dashboards highlighting KPI data quality scores, exceptions and trends.
• Support UAT and business validation of DQ rules.
• Implement reusable DQ rules and frameworks for multiple project KPIs.
• Support production deployment and post-deployment validation.

Skills

Informatica IDMC

CDQ

SQL

Data profiling

Data quality rules

KPI validation

Job description

In this role, you will collaborate closely with one of our esteemed clients—a globally recognized leader in their industry, distinguished by their commitment to excellence, innovation, and delivering exceptional value. As a trusted IT consulting partner, Dautom is supporting their strategic initiatives by connecting them with exceptional talent to drive business growth and transformation.

About the Role :

Role: Informatica IDMC Data Quality Developer

Experience: 4-6 years

Technology: Informatica IDMC / Cloud Data Quality (CDQ), SQL

Onsite - Riyadh , KSA

Job Description:

Responsible for designing, developing, and maintaining data quality processes and rules in Informatica IDMC to ensure the accuracy, completeness, consistency, validity, and timeliness of data feeding the project KPIs.

Key Responsibilities:

• Analyze project KPI requirements and translate them into data quality rules and validation checks.
• Perform data profiling across source systems, data warehouse/data lake and KPI datasets.
• Develop and configure Informatica IDMC Data Quality mappings, rules, profiles and scorecards.
• Validate KPI calculations and underlying datasets against source systems and approved business definitions.
• Develop SQL queries to perform independent data validation and reconciliation.
• Identify data anomalies, investigate root causes and coordinate with data/source-system teams for resolution.
• Maintain DQ rule documentation, KPI-to-source mappings and technical specifications.
• Support execution and monitoring of DQ jobs and investigate failed or unexpected results.
• Prepare DQ reports and dashboards highlighting KPI data quality scores, exceptions and trends.
• Support UAT and business validation of DQ rules.
• Implement reusable DQ rules and frameworks for multiple project KPIs.
• Support production deployment and post-deployment validation.

Required Skills:

• Hands-on experience with Informatica IDMC / Cloud Data Quality.
• Good understanding of data warehousing and ETL/ELT concepts.
• Experience with data profiling and data quality dimensions.
• Experience in developing DQ rules , mapplets and exception handling.
• Ability to analyze complex datasets and identify data anomalies.
• Experience with KPI validation and source-to-target reconciliation.
• Good documentation and communication skills.

Preferred:

• Experience with Power BI or other BI/dashboard platforms.
• Experience with enterprise data lakes/data warehouses.
• Experience in utilities, energy, banking or other large-scale enterprise environments.
• Knowledge of Informatica Cloud Data Integration (CDI), Data Governance and Data Catalog.