Senior ETL & Data Warehouse QA (Healthcare)

UPWIA; United States; A distancia; USD 120.000 - 160.000; Jornada completa

Descripción de la vacante

UpWia, acting as a sourcing partner, seeks a data validation engineer to test ETL/ELT pipelines across Bronze/Silver/Gold healthcare datasets.

You will write SQL queries and Python scripts to validate source-to-target mappings, perform quality checks, and collaborate with data engineers.

H-1B and H4 EAD candidates are welcome; 11+ years in data/ETL testing and experience with Snowflake/Oracle/SQL Server/PostgreSQL are preferred.

Formación

• 11+ years of experience in data/ETL testing.
• Strong SQL proficiency across Snowflake, Oracle, SQL Server, or PostgreSQL.
• Python scripting for data validation and test automation.
• Healthcare domain or Medicaid/MMIS data migration experience.
• Bachelor's degree in Computer Science, IT, or equivalent.

Responsabilidades

• Validate ETL/ELT data pipelines across Bronze (raw), Silver (cleansed), and Gold (curated) layers.
• Perform source-to-target mapping verification and data quality checks on healthcare-domain datasets.
• Write SQL queries and Python scripts for automated data reconciliation and testing.
• Collaborate with data engineers on test plan creation and defect triage.
• Use AI-assisted coding tools as part of day-to-day testing work.

Conocimientos

SQL

Python

ETL testing

Data validation

Healthcare data

Educación

Bachelor's degree in CS/IT

Herramientas

Snowflake

Oracle

SQL Server

PostgreSQL

GitHub Copilot

Descripción del empleo

UpWia, acting as a sourcing partner, seeks a data validation engineer to test ETL/ELT pipelines across Bronze/Silver/Gold healthcare datasets.

You will write SQL queries and Python scripts to validate source-to-target mappings, perform quality checks, and collaborate with data engineers.

H-1B and H4 EAD candidates are welcome; 11+ years in data/ETL testing and experience with Snowflake/Oracle/SQL Server/PostgreSQL are preferred.