Role: Data Quality Engineer - (Informatica IDQ / SQL / L2 ProductionSupport)
Location: Remote
Duration: Long Term Contract
Job Description:
1. Position Overview
The Data Quality Engineer will be responsible for finalizing, validating, deploying, and maintaining the existing Data Quality (DQ) framework using Informatica Data Quality (IDQ).
The resource will work closely with business stakeholders, data engineering teams, data providers, and application support teams to understand existing data processes, refine and implement data quality rules, and ensure the accuracy, completeness, and consistency of enterprise data.
The role will also establish and manage a structured monthly Data Quality review process, coordinate incident management activities, lead Root Cause Analysis (RCA), track issue resolution, and develop comprehensive technical documentation and operational support procedures.
2. Key Responsibilities
A. Data Quality Reports and Framework Maintenance
· Review, finalize, validate, and deploy approximately 12 existing Data Quality workflows and reports using Informatica Data Quality (IDQ).
· Maintain and enhance existing DQ workflows, reports, and validation processes.
· Refine existing data quality rules and develop new rules based on business and data requirements.
· Perform data validation and reconciliation using SQL and Informatica IDQ.
· Identify data quality gaps, anomalies, and inconsistencies and coordinate corrective actions.
· Monitor deployed workflows and reports to ensure ongoing accuracy, reliability, and operational effectiveness.
B. Monthly Data Quality Reviews
· Establish and coordinate a structured monthly Data Quality review process with business and data teams.
· Coordinate with business stakeholders to prepare EAC data for monthly reviews.
· Define and execute validation checks to ensure data accuracy, completeness, and consistency.
· Implement appropriate error-handling mechanisms and exception reporting.
· Review DQ results, analyze identified exceptions, and coordinate remediation activities.
· Track recurring data quality issues and recommend improvements to prevent future occurrences.
C. Incident Management and Root Cause Analysis
· Lead weekly Data Quality incident review meetings with relevant business and technical stakeholders.
· Manage and track approximately 100 reported data quality issues annually.
· Coordinate incident intake, classification, prioritization, triage, escalation, and resolution.
· Work with data engineering teams, data providers, application teams, and business stakeholders to investigate and resolve data issues.
· Lead and coordinate Root Cause Analysis (RCA) for recurring and high-impact data quality incidents.
· Track issue resolution progress, dependencies, action items, and resolution timelines.
· Maintain incident logs and provide regular status updates to stakeholders.
· Identify recurring issues and recommend preventive and corrective actions to improve overall data quality.
D. Technical Documentation and Operational Support
· Develop and maintain technical documentation covering Data Quality processes and operational procedures.
· Document incident intake, triage, diagnosis, escalation, and resolution workflows.
· Create and maintain support procedures, troubleshooting guides, and operational runbooks.
· Document data quality rules, validation logic, workflows, dependencies, and reporting processes.
· Maintain knowledge repositories to support operational continuity and knowledge transfer.
· Ensure documentation remains current and aligned with deployed processes and support requirements.
3. Required Technical Skills
· Strong SQL skills, including data analysis, data validation, reconciliation, and troubleshooting.
· Good understanding of Data Quality principles, including:
o Data Accuracy
o Data Completeness
o Data Consistency
o Data Validity
o Data Uniqueness
o Data Integrity
· Understanding of Data Governance principles and practices.
· Experience with incident management, issue tracking, and resolution coordination.
· Strong analytical and problem-solving skills, including Root Cause Analysis (RCA).
· Ability to develop and maintain technical documentation and operational procedures.
· Experience working with cross-functional business and technical teams.
4. Preferred Skills
· Hands-on experience with Informatica Data Quality (IDQ).
· Experience with comparable enterprise Data Quality platforms.
· Familiarity with Informatica workflows, mappings, data profiling, and data quality rules.
Alchemy: Transforming Your Professional Vision into Reality
Since our inception in 2013, Alchemy has been dedicated to reshaping organizational performance through innovative IT services. With a vision to empower businesses seeking a transformative edge, we’ve positioned ourselves at the forefront of digitization and software modernization.
Our name reflects our mission: to transmute technology into gold-standard solutions for our esteemed clients. We proudly serve a diverse range of sectors, including IT and ITES, BFSI, Telecom and Media, Automotive, Manufacturing, Energy, Oil and Gas, Real Estate, Retail, Healthcare, and more.
With a global footprint spanning the USA, India, Europe, Canada, Singapore, Japan, and parts of Central and West Africa, we harness a unique blend of competencies, frameworks, and cutting-edge technologies. Together, we drive growth and innovation across industries, helping organizations turn their visions into reality.
Alchemy – Connecting Talent with Opportunities (Diversity, Equity and Inclusion)