ETL Data Warehouse Tester- 10 yrs- USA Remote
Summary
Tests ETL/ELT pipelines for Medicaid/MMIS data, validating data quality and business logic across Medallion architectures using SQL and Python.
Job Description: Key Responsibilities: Validate ETL/ELT data pipelines across Bronze (Raw), Silver (Cleansed), and Gold (Curated) Medallion architectures. Perform source-to-target mapping verification, data quality checks, and complex business logic validation on Medicaid/MMIS datasets. Write advanced, multi-table SQL queries and Python scripts to perform automated data reconciliation, null checks, and referential integrity testing. Collaborate with data engineers and business analysts to creat…