ETL Tester

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

Position Summary

An EDW QE professional is responsible for ensuring the accuracy integrity and quality of data within the data warehouse environment Their key responsibilities include validating ETL processes using AI tools verifying source-to-target data mappings, testing data transformations leveraging AI CoPilot Python and ensuring that reports and dashboards reflect accurate business information. They collaborate closely with data engineers, business analysts, and developers to identify data issues, create comprehensive test plans and test cases and support defect resolution throughout the development lifecycle.

Key Responsibilities

Requirement Analysis

• Perform backend testing to compare data in source systems to target Medicaid Enterprise Data Warehouses
• Verify source-to-target data mapping and transformation logic for Medicaid datasets
• Validate data quality standardization rules and loading accuracy. SQL amp Scripting
• Write complex SQL queries to validate ETL outputs against business rules
• Design test plans, test cases and test scenarios for ETL and data warehouse processes
• Collaborate with ETL developers to resolve defects and perform system test system integration test smoke test & regression testing.

Automation

• Develop automated database validation scripts using AI tools
• Python SQL Alchemy and Pandas
• Exposure to AI ML model validation or testing data pipelines that support machine learning workflows

Required Skills & Qualifications

• Deep proficiency in SQL and relational database systems
• Healthcare Domain Knowledge Direct experience with Medicaid systems, HIPAA, claims eligibility, provider data, or clinical standards like ICD 9 10 CPT and HL7
• ETL Knowledge Strong understanding of EDW and ETL concepts, including Star/Snowflake schema, Slowly Changing
• Work Experience Minimum 5 years of QA/testing experience in data warehouse ETL or healthcare analytics environments
• Education: Bachelor's degree in computer science information systems data Analytics or related field
• Experience with cloud data platforms and familiarity with data visualization tools

Required AI Skills

• Consistent Use Maintain a minimum of 90% weekly usage of AI tools such asGitHub

Preferred Qualifications

• Familiarity with state Medicaid agencies
• Python Test Automation and GitHub Code Management tool