Lead Software Engineer

Virtusa; New York (NY); On-site; USD 120,000 - 150,000; Full time

Job summary

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.

Qualifications

• 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.

Responsibilities

• 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.

Skills

SQL & ETL

Healthcare domain

ETL tools

Cloud platforms

AI proficiency

Tools

Azure DevOps

JIRA

HP ALM

Power BI

Tableau

Snowflake

Azure

Job description

JP - UHGJP00124684

Role - SDET- Test Automation

Number of RRIDs required - 1

JD - Position Summary

The EDW Quality Engineer ensures the accuracy, integrity, and quality of data within enterprise data warehouse environments. Key focus areas include validating ETL/ELT pipelines, verifying source-to-target mappings, testing complex transformations, and leveraging Python and AI tools (Copilot, Snowflake AI Cortex). The role involves direct collaboration with data engineers, business analysts, and developers across Agile/Scrum sprint cycles.

Key Responsibilities

• Requirement Analysis & Data Architecture: Validate requirements alignment with business needs using Medallion Architecture (Bronze/Silver/Gold) in modern platforms (Databricks, Snowflake, Azure).
• Medicaid Data Validation: Perform backend testing comparing source systems to target Medicaid EDWs. Verify source-to-target mappings, standardization rules, and transformation logic.
• SQL Data Auditing: Execute complex SQL queries (multi-table JOINs, aggregations) to run row counts, null checks, duplicate checks, and referential integrity validations.
• Test Strategy Execution: Design test plans, cases, and scenarios. Conduct manual and automated tests for full-load and incremental-load cycles. Lead rigorous review/approval cycles.
• Defect Management: Identify, log, and track bugs using JIRA, HP ALM, or Azure DevOps. Perform Smoke, System Integration (SIT), and Regression testing.
• AI-Driven Automation: Build automated data validation scripts using Python (Pandas, SQLAlchemy) and Snowflake AI Cortex. Integrate tests into Azure DevOps CI/CD pipelines.

Required Qualifications Skills

• SQL & ETL Expertise: Deep proficiency in SQL (Oracle, SQL Server, PostgreSQL), Star/Snowflake schemas, SCD Type 1/2, STMs, and data pipeline transformations.
• Healthcare Domain: Experience with Medicaid, HIPAA, claims (837/835), eligibility, provider data, or clinical standards (ICD-9/10, CPT, HL7).
• Tools & Platforms: ETL Test Management (Azure DevOps, JIRA, HP ALM), Data Viz (Power BI, Tableau), Cloud (Snowflake, Azure).
• AI Proficiency: 90%+ weekly active usage of GitHub Copilot, M365 Copilot, and Snowflake AI Cortex to accelerate automation and testing workflows.

Preferred Qualifications

• Experience with MMIS data warehouse migration, data mart validation, and state Medicaid agencies.
• Hands-on Python test automation with GitHub code management