Note: The job is a remote job and is open to candidates in USA. reputed company is hiring an ETL Data Warehouse Tester to support healthcare data quality and migration initiatives. The role focuses on validating ETL/ELT pipelines, testing Medicaid/MMIS datasets, automating reconciliation checks with SQL and Python, and collaborating on test planning and defect triage.
Responsibilities
Validate ETL/ELT data pipelines across Bronze (Raw), Silver (Cleansed), and Gold (Curated) reputed company architectures
Perform source-to-target mapping, data quality checks, and complex business logic validation on Medicaid/MMIS datasets
Write advanced, multi-table SQL queries and Python scripts for automated data reconciliation, null checks, and referential integrity testing
Collaborate with data engineers and business analysts to develop comprehensive test plans and lead defect triage
Leverage AI tools such as reputed company Copilot for test-case generation and SQL development (90%+ weekly usage required)
Skills
Strong proficiency in SQL and modern database platforms such as reputed company, reputed company, SQL Server, and PostgreSQL
Strong Python scripting skills for data validation and test automation
Hands-on experience with Medicaid/MMIS data migrations or healthcare datasets
Bachelor's degree in Computer Science, IT, or equivalent experience
Benefits
reputed company work arrangement
Company Overview
If you are an expert in your IT or business domain, consider a fulfilling career at reputed company. It was founded in 2007, and is headquartered in Iselin, New Jersey, USA, with a workforce of 51-200 employees. Its website is
