Senior SDET: Data Warehouse Test Automation Lead

Virtusa Corporation; New York (NY); Presencial; USD 120.000 - 150.000; Jornada completa

Descripción de la vacante

Virtusa Corporation in New York invites a Senior EDW Quality Engineer to validate data pipelines and data models across Databricks, Snowflake, and Azure. You will collaborate with data engineers and analysts within Agile sprints to ensure data accuracy and reliability.

The role requires strong SQL and ETL testing skills, healthcare data familiarity (Medicaid/HIPAA), and experience with AI-assisted testing workflows. Expect modern tooling and CI/CD integration.

Formación

• Proficiency in SQL with multiple RDBMS and data warehouse schemas.
• Experience with Medicaid, HIPAA, claims data, or healthcare standards.
• Familiarity with ETL testing management tools and data visualization platforms.
• Experience with AI-assisted testing workflows is a plus.

Responsabilidades

• Validate requirements and data architecture using Medallion Architecture (Bronze/Silver/Gold) in Databricks, Snowflake, Azure.
• Perform Medicaid data validation, verify source-to-target mappings, standardization rules, and transformation logic.
• Execute complex SQL queries (multi-table JOINs, aggregations) to audit row counts, nulls, duplicates, and referential integrity.
• Design test plans, cases, and scenarios; conduct manual and automated tests for full-load and incremental-load cycles.
• Log and track defects using JIRA, HP ALM, or Azure DevOps; perform Smoke, SIT, and Regression testing.
• Build automated data validation scripts using Python (Pandas, SQLAlchemy) and Snowflake AI Cortex; integrate tests into CI/CD pipelines.

Conocimientos

SQL & ETL

Healthcare domain

ETL tools

Cloud platforms

AI proficiency

Herramientas

Azure DevOps

JIRA

HP ALM

Power BI

Tableau

Snowflake

Azure

Descripción del empleo

Virtusa Corporation in New York invites a Senior EDW Quality Engineer to validate data pipelines and data models across Databricks, Snowflake, and Azure. You will collaborate with data engineers and analysts within Agile sprints to ensure data accuracy and reliability.

The role requires strong SQL and ETL testing skills, healthcare data familiarity (Medicaid/HIPAA), and experience with AI-assisted testing workflows. Expect modern tooling and CI/CD integration.