ETL tester

Job Details Key Responsibilities : Validate ETL pipelines after data migration from legacy systems to new data warehouses or cloud platforms. Test and verify Cognos reports for accuracy, completeness, formatting, and compliance with defined business rules. Develop and execute test plans, test cases, and scripts for both ETL and reporting validation. Perform data reconciliation between source, staging, and target systems to ensure integrity and correctness. Collaborate with data engineers and business analysts to understand reporting requirements and ETL transformations. Identify, log, and track defects or discrepancies using JIRA. Support the state team during User Acceptance Testing (UAT) for migrated data and reports. Document testing activities, results, and provide summary reports and recommendations. Ensure testing adheres to HIPAA, CMS, and state Medicaid compliance standards. Required Skills and Experience : 8 years of experience in software testing, preferably in Medicaid or healthcare data systems. Knowledge of Medicaid data (eligibility, enrollment, claims, encounters, providers Hands-on experience validating ETL processes and data migration projects. Strong experience testing Cognos reports Proficiency in SQL for data validation and troubleshooting. Familiarity with data warehouses, staging, and OLAP environments. Experience with test management tools (JIRA, Selenium etc Strong analytical, documentation, and problem-solving skills. 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.