AI-Driven ETL QA Engineer (Data Warehouse)

Virtusa; New York (NY); On-site; USD 110,000 - 160,000; Full time

Job summary

Virtusa in New York is seeking an EDW QA professional to ensure data accuracy in the data warehouse. You will validate ETL processes, test data transformations using AI tools, and verify source-to-target mappings, collaborating with data engineers and business analysts.

The role requires 5+ years of QA/testing in healthcare analytics, strong SQL skills, and familiarity with Medicaid datasets, HL7, ICD/CPT. This position may involve collaboration across cloud data platforms and BI tools.

Qualifications

• 5+ years QA/testing in data warehouse/ETL or healthcare analytics.
• Bachelor's degree in CS / IS / data analytics.
• Deep proficiency in SQL and relational databases.
• Experience with Medicaid datasets and HL7/ICD/CPT knowledge.
• Familiar with cloud data platforms and data visualization tools.

Responsibilities

• Perform backend testing to compare source systems to Medicaid EDW data.
• Verify source-to-target data mappings and transformation logic.
• Write complex SQL queries to validate ETL outputs against rules.
• Design test plans, test cases, and scenarios for ETL and DWH processes.
• Collaborate with ETL developers to resolve defects and perform system tests.

Skills

SQL proficiency

Healthcare data knowledge

QA/testing in DWH/ETL

Data warehouse testing

ETL concepts

Education

Bachelor's degree in computer science / information systems / data analytics

Tools

Python

SQL Alchemy

Pandas

GitHub

Job description

Virtusa in New York is seeking an EDW QA professional to ensure data accuracy in the data warehouse. You will validate ETL processes, test data transformations using AI tools, and verify source-to-target mappings, collaborating with data engineers and business analysts.

The role requires 5+ years of QA/testing in healthcare analytics, strong SQL skills, and familiarity with Medicaid datasets, HL7, ICD/CPT. This position may involve collaboration across cloud data platforms and BI tools.