ETL Tester

Job Requirements Position Summary An 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 to identify data issues, create comprehensive test plans and test cases and support defect resolution throughout the development lifecycle Key Responsibilities Requirement Analysis Perform 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 datasets Validate data quality standardization rules and loading accuracy. SQL amp Scripting Write complex SQL queries to validate ETL outputs against business rules Design test plans, test cases and test scenarios for ETL and data warehouse processes Collaborate 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 tools Python SQL Alchemy and Pandas. Exposure to AI ML model validation or testing data pipelines that support machine learning workflows Required Skills Amp Qualifications Technical 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 HL7 ETL 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 environments Education: Bachelor’s degree in computer science information systems data Analytics or related field Experience with cloud data platforms and familiarity with data visualization tools Required AI Skills Consistent Use Maintain a minimum of 90% weekly usage of AI tools such asGitHub Preferred Qualifications Familiarity with state Medicaid agencies Python Test Automation and GitHub Code Management tool Work Experience 5-7Years