Requirements
- 5+ years of experience in software testing and quality assurance.
- 5+ years of experience testing backend, database, EDW, or ETL systems.
- 4+ years of strong SQL experience and hands-on work with at least one RDBMS (e.g., Teradata, SQL Server).
- 4+ years of experience in UI, smoke, end-to-end, and integration testing.
- 4+ years of strong troubleshooting and analytical skills, with the ability to debug and resolve complex technical issues.
- 4+ years of experience in test design and working with at least one test management tool.
- Bachelor’s degree or higher in Information Technology, Computer Science, Mathematics, Statistics, Analytics, Business Technology, or related field.
- Technical Skills: Deep proficiency in SQL and relational database systems (Oracle, SQL Server, PostgreSQL).
- Healthcare Domain Knowledge: Direct experience with Medicaid systems, HIPAA, claims (837/835), 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 Dimensions (SCD1/SCD2).
- Tools: Experience with ETL tools (such as Informatica, Talend, SSIS, ADF) and test management tools (Such as Azure DevOps, JIRA, HP ALM).
- Analytical Skills: Ability to compare datasets, identify root causes of discrepancies, and validate against business rules.
- Soft Skills: Excellent communication and collaboration skills; ability to work in Agile/Scrum sprint cycles.
- 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
Nice to Have
- Knowledge of Medicaid reporting, encounter data, and data mart validation.
- Experience with Medicaid Enterprise Systems (MES)
- Familiarity with Illinois HFS or other state Medicaid agencies.
- Python Test Automation and GitHub Code Management tool
- Informatica Tool Knowledge.
