What are the responsibilities and job description for the Snowflake Tester (Must have Integrated Eligibility (IE) Experience) position at Synapse Business Systems?
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