Avatar for Virtusa
Sparking innovation, one sprint at a time
  • B2B
  • Public Stage
    Publicly traded company
  • Top Investors
    This company has received a significant amount of investment from top investors

ETL Tester

Posted: 1 month ago
Job Location
Remote Work Policy

In office

Visa Sponsorship

Not Available

RelocationAllowed
Skills
Python
SQL
Data Warehouse
ETL
Pandas
Sql alchemy
Healthcare Analytics

About the job

Job Requirements

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 Amp Qualifications

Technical Skills 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

Work Experience

5-7Years

About the company

Virtusa company logo
Sparking innovation, one sprint at a time5000+ Employees
  • B2B
  • Public Stage
    Publicly traded company
  • Top Investors
    This company has received a significant amount of investment from top investors
Learn more about Virtusa image

Funding

AMOUNT RAISED
$2B
FUNDED OVER
1 round
Round
S
$2000000000
Seed - Sep 2020

Similar Jobs

Archesys company logo
Archesys
Improving the government services that impact everyday lives
Super company logo
Super
Super is the AI assistant for property management
Alloy company logo
Alloy
Alloy helps banks and fintech companies make safe and seamless fraud, credit
CashClever company logo
CashClever
Turn Smarter Insights Into Real Financial Growth
Cloaked company logo
Cloaked
Fight against surveillance, spam, & identity theft