What are the responsibilities and job description for the Snowflake Tester (Must have Integrated Eligibility (IE) Experience) position at Jobs via Dice?
Dice is the leading career destination for tech experts at every stage of their careers. Our client, Synapse Business Systems, is seeking the following. Apply via Dice today!
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
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