Job ID:
J55818
Job Title:
Data Warehouse Tester
Location:
Florida, FL
Duration:
9 Months + Extension
Domain Exposure:
Healthcare
Client:
To Be Discussed Later
Employment Type:
W-2, 1099, C2C
Work Authorization:
US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other
Title: Data Warehouse Tester
Location: Florida
Duration: 9 Months+ Extension
Bill Rate: $69/hour(C2C)
Job Type: W-2, 1099, C2C
Client: To Be Discussed Later
Work Authorization: USC, GC, H-1B, OPT-EAD, GC-EAD, H4-EAD
Job Summary
A Data Warehouse (DWH) / ETL Tester ensures the accuracy, integrity, performance, and reliability of data moving through extraction, transformation, and loading (ETL) pipelines into a centralized data warehouse
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 create comprehensive test plans and lead defect triage.
Leverage AI tools (e.g., GitHub Copilot) daily to streamline test-case generation and SQL writing ($\ge$90% weekly usage required).
Key Requirements:
Deep proficiency in SQL and modern database platforms (Snowflake, Oracle, SQL Server, PostgreSQL).
Strong scripting skills in Python for data validation and test automation.
Hands-on experience with Medicaid/MMIS data migrations or healthcare domain datasets.
Bachelors degree in Computer Science, IT, or equivalent experience.
We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.