Job Description
Job Description Job Title: Snowflake Testers Job Location: Remote Client: Deloitte We are seeking a Snowflake Tester with strong ETL testing experience using Informatica (IICS/PowerCenter) and proven exposure to State/Federal government (IE – Integrated Eligibility, Medicaid, or public assistance systems). The role involves validating complex data pipelines, ensuring compliance with government data standards, and supporting large-scale data warehouse/cloud transformation initiatives. Key Responsibilities Perform end-to-end data validation for Snowflake data warehouse implementations in government/public sector projects Validate ETL pipelines built using Informatica (IICS/PowerCenter) Conduct source-to-target data validation for systems like: Medicaid / Healthcare eligibility systems Benefits systems (SNAP, TANF, Child Support, etc.) Write and execute complex SQL queries in Snowflake for data validation and reconciliation Validate data migration from legacy systems to Snowflake Ensure data accuracy, completeness, and compliance with government regulations Perform data profiling, data quality checks, and anomaly detection Validate interfaces with federal/state systems (e.g., eligibility, verification systems) Support UAT, SIT, and regression testing cycles