Senior ETL QA Engineer – Medicaid/EDW- 5+ yrs- New York, United States- Onsite

Job Requirements Position SummaryAn 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 toidentify data issues, create comprehensive test plans and test cases and support defect resolution throughout the development lifecycleKey ResponsibilitiesRequirement AnalysisPerform 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 datasetsValidate data quality standardization rules and loading accuracy. SQL amp ScriptingWrite complex SQL queries to validate ETL outputs against business rulesDesign test plans, test cases and test scenarios for ETL and data warehouse processesCollaborate 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 toolsPython SQL Alchemy and Pandas. Exposure to AI ML model validation or testing data pipelines that support machine learning workflowsRequired Skills amp QualificationsTechnical 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 HL7ETL 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 environmentsEducation: Bachelor’s degree in computer science information systems data Analytics or related fieldExperience with cloud data platforms and familiarity with data visualization tools Required AI SkillsConsistent Use Maintain a minimum of 90% weekly usage of AI tools such asGitHubPreferred QualificationsFamiliarity with state Medicaid agenciesPython Test Automation and GitHub Code Management toolWork Experience 5-7Years