You will design and implement data quality rules to validate file formats, schema consistency, and business logic compliance.
Responsibilities
Design and implement data quality rules in Informatica Data Quality (IDQ) to validate schema consistency, completeness, and business logic.
Establish SLA monitoring frameworks to track external file delivery timeliness, frequency, and compliance.
Create alerting and exception workflows for missing, late, or malformed file deliveries.
Profile incoming data in Azure Blob Storage and Snowflake for null values, duplicates, schema drift, or logic violations.
Collaborate with data engineering, business, and governance stakeholders to define quality thresholds and integrate validation into ingestion pipelines.
Generate documentation, dashboards, and issue logs to track quality metrics and perform root-cause analysis on quality breaches.
Required Skills
3+ years of advanced experience with Informatica Data Quality (IDQ) for rule creation, profiling, and monitoring.
3+ years of experience working with Azure Blob Storage and Snowflake Snowpipe.
3+ years of familiarity with data quality dimensions including accuracy, completeness, validity, and timeliness.
2+ years of experience designing and supporting SLA monitoring and alerting systems for data intake.
2+ years of experience working with FactSet.
Proficiency in Snowflake and managing large datasets.
Familiarity with financial datasets, including security master and holding datasets.
Execution level familiarity with ETL orchestration, data contracts, or third-party file delivery standards.