Informatica IDMC Data Quality Developer

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 DeveloperExperience: 4–6 yearsTechnology: Informatica IDMC / Cloud Data Quality (CDQ), SQLOnsite - Riyadh , KSAJob 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.● Implement DQ checks covering: ○ Completeness ○ Accuracy ○ Validity ○ Consistency ○ Uniqueness ○ Referential integrity ○ Timeliness● 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.● Strong SQL skills.● 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:● Informatica IDMC certification.● 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.For more details, please inbox in moumita.p@dautom.com