Informatica IDQ Specialist

Job Description

Job Title: Informatica IDQ Specialist

Job Location: Dubai

Job Description:

Key Responsibilities:

• Data Profiling: Use Informatica Data Quality to profile and analyse data to identify data quality issues and anomalies. Document data quality rules and requirements based on profiling results.
• Data Quality Assessment: Continuously monitor and assess data quality using Informatica Data Quality. Define and track key data quality metrics and KPIs.
• Data Validation and Verification: Create data validation rules and perform data validation to ensure data accuracy. Verify data against externalsources or reference data sets.
• Data Quality Reporting: Generate data quality reports and dashboards to communicate data quality issues and improvements to stakeholders. Provide regular updates on data quality status.
• DQ Remediation: Provide DQ profiling results walkthrough to source applications and support applications towards enriching data quality with DQ remediation activities. Data Governance: Ensure compliance with data quality regulations and industry best practices.
• Data Documentation: Maintain comprehensive documentation of data quality processes, rules, and workflows. Document data quality issue resolutions and mitigation strategies.
• Data Quality Training: Provide training and guidance to data stewards and other team members on data quality best practices and IDQ usage.
• Data Integration: Work with ETL (Extract, Transform, Load) developers to integrate data quality processes into data pipelines. Ensure data quality checks are applied at appropriate stages of data integration.
• Data Quality Improvement Projects: Lead or participate in data quality improvement projects, including root cause analysis and corrective action planning. Implement data quality improvements and measure their impact.
• Data Quality Audits: Conduct regular data quality audits and reviews to identify areas for improvement. Collaborate with internal and external auditors on data quality assessments.
• Issue Resolution: Investigate and resolve data quality issues promptly, including data reconciliation and error handling.
  
  

• Data Quality Standards and templates
• Data Quality Rules and Standards
• Data Quality improvement plan and implementation
• Data Quality profiling scorecard, exception reports
• Data Profiling Results
• Data Quality Dashboards
• Data Quality Issue Logs and Resolutions
• Data Quality Metadata documentation
• Support Data Quality Remediation program
  
  

• Informatica Data Quality (IDQ) Expertise: Proficiency in Informatica Data Quality tools, including profiling, cleansing, parsing, standardization, and matching functionalities. Ability to create scorecards, data quality workflows, and reusable components.
• Data Profiling and Analysis: Capability to perform data profiling to assess quality levels, identify anomalies, and define data quality rules and improvements.
• ETL and Data Integration Tools: Basic understanding of ETL processes and familiarity with tools like Informatica PowerCenter for data integration tasks.
• SQL and Database Knowledge: Strong SQL skills for querying, analysing, and validating data in relational databases like Oracle, SQL Server, and MySQL, with optional exposure to NoSQL databases.
• Data Governance Principles: Knowledge of data governance frameworks, defining standards, and implementing policies to ensure consistent data quality.
• Reporting and Visualization: Ability to create dashboards and reports using tools like Power BI, Tableau, or Excel to communicate data quality insights.
• Analytical and Problem-Solving Skills: Strong analytical thinking to identify root causes of data issues, conduct gap analysis, and recommend corrective actions.
• Business Process Knowledge: Familiarity with workflows and processes in industries like banking, insurance, healthcare, or retail, and their reliance on high quality data.
• Communication and Collaboration: Strong communication skills to share findings with technical and non-technical stakeholders and collaborate with teams to resolve data quality issues.
• Preferred Skill: Related to Informatica DEI
• Soft Skills: Attention to detail, a problem- solving mindset, and good time management for handling multiple initiatives effectively.
• Optional Tools and Scripting: Knowledge of scripting in Python or R and experience with data modelling tools like ERwin or Visio can be an added advantage.
• Certifications: Relevant certifications like Informatica Data Quality Certification, CDMP, or Microsoft Certified: Power BI Data Analyst Associate can enhance credibility.