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, the company is supporting their strategic initiatives by connecting them with exceptional talent to drive business growth and transformation.
Ready to apply for roles like this?
Unlock the company name and direct application link. Subscribers get instant access to fresh jobs across Dubai, Abu Dhabi and Riyadh, many with visa support.
Unlock employer & apply directly
You will be 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, and 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 Skills:
- 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.
