Data Test Automation Engineer (Tosca DI / Snowflake)

About the Role We're looking for a Data Test Automation Engineer to lead validation testing for a large-scale Snowflake data migration program in the rail/transportation sector. This role covers full-volume data integrity testing across a medallion architecture (Bronze → Silver → Gold), using Tosca Data Integrity (Tosca DI) for source-to-Snowflake reconciliation, working alongside a Data Engineering team's existing Snowflake stored-procedure validation. Responsibilities * Design and build Tosca DI test frameworks for source-to-Snowflake (Bronze layer) reconciliation across multiple heterogeneous source systems (Oracle, SQL Server, PostgreSQL, Informatica) * Set up Tosca DI folder structures, test modules, and data-driven test cases (Excel data pools) for full-volume validation — no sampling * Configure Tosca DI ↔️ Snowflake connectivity via ODBC * Collaborate with Data Engineering to align Tosca DI validation with existing Snowflake stored-procedure/CTL Query validation for Silver/Gold layers * Build out a business rules test matrix from requirements documentation, translating business logic into testable assertions * Maintain full requirements-to-test-case-to-defect traceability (e.g., via qTest/Jira) * Identify and prioritize critical data validation points; flag risks and data quality issues proactively Required Experience * 4+ years hands-on Tosca DI experience — must have personally built Data Integrity test frameworks from scratch, not just used Tosca for UI automation * Strong SQL skills — comfortable writing complex queries (joins, aggregations, CTEs) to validate transformation logic * Experience with Snowflake or a similar cloud data warehouse (BigQuery, Redshift) — understanding of schemas, streams, CDC concepts * Experience with ETL/data migration testing — row count reconciliation, schema validation, deduplication logic, referential integrity checks * Familiarity with medallion/lakehouse architecture concepts (Bronze/Silver/Gold or equivalent) Nice to Have * Experience with qTest or similar test management tools * Exposure to dbt (understanding how it differs from/complements Tosca DI is a plus) * Rail, logistics, or other data-heavy regulated industry experience * Experience with CI/CD-triggered data validation pipelines