Unlocking the power and potential of data.
QA Analyst, ETL Tester
Location
Illinois
Posted
34 days ago
Salary
0
Seniority
Senior
Job Description
QA Analyst, ETL Tester
CSpring
• You'll own the quality of data as it moves through ETL pipelines in a state Medicaid environment — from reviewing requirements all the way through defect resolution, regression testing, and automation. • Review Change Requests (CRs) and participate in requirement analysis for new EDW extracts and transformations. • Participate in data modeling and requirement gathering sessions to ensure testing stays aligned with business needs. • Perform backend testing to compare data in source systems to target Medicaid Enterprise Data Warehouses (EDW); verify source-to-target data mapping and transformation logic for Medicaid datasets. • Validate data quality, standardization rules, and loading accuracy across full-load and incremental-load cycles. • Write complex SQL queries — multi-table JOINs, aggregations, row counts, null checks, duplicate checks, and referential integrity validation — to validate ETL outputs against business rules. • Design test plans, test cases, and test scenarios for ETL processes; execute both manual and automated tests. • Identify, document, and track discrepancies using JIRA, HP ALM, or Azure DevOps Test Plans; collaborate with ETL developers to resolve defects and perform regression testing. • Develop automated database validation scripts using Python, SQLAlchemy, and Pandas; create shell scripts for ETL monitoring and log analysis. • Integrate test automation into CI/CD pipelines in Azure DevOps. • Document test results and provide detailed, actionable feedback to stakeholders.
Job 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 (Teradata, SQL Server, Oracle, or similar)
- 4+ years of experience in UI, smoke, end-to-end, and integration testing
- 4+ years of experience in test design and working with at least one test management tool (Azure DevOps, JIRA, HP ALM)
- Strong understanding of EDW and ETL concepts, including Star/Snowflake schema and Slowly Changing Dimensions (SCD1/SCD2)
- Direct experience in a Medicaid, healthcare, or government data environment, including familiarity with HIPAA and healthcare data standards (837/835 claims, ICD-9/10, CPT, HL7)
- Bachelor's degree in Computer Science, Information Technology, Data Analytics, Mathematics, or a related field
- Hands-on experience with Informatica PowerCenter (preferred qualification)
- Knowledge of Medicaid reporting, encounter data, and data mart validation (preferred qualification)
- Familiarity with Medicaid Enterprise Systems (MES) or a state Medicaid agency (e.g., Illinois HFS) (preferred qualification)
- Python test automation and GitHub for code management (preferred qualification)
- Experience integrating automated tests into CI/CD pipelines (preferred qualification).
Benefits
- Work that carries real weight.
- A team that takes quality seriously.
- Room to grow your craft.
- Collaboration without silos.
- Purpose-driven clients.
Related Guides
Related Categories
Related Job Pages
More QA Engineer Jobs
Quality Engineer – Integrations
ThriveReinventing how businesses connect people, knowledge, skills and systems.
• Collaborate closely with development teams to identify automation opportunities and improve test coverage • Develop, maintain, and optimise a robust automation framework across both frontend and backend systems • Provide training and guidance to developers on writing effective, maintainable automation tests • Conduct code reviews to ensure high standards for automation quality and reliability • Monitor test performance and continuously improve coverage and stability • Contribute to overall test strategy, planning, and process improvement initiatives • Mentor junior engineers and champion best practices in automation across teams
• Design, implement, and maintain comprehensive QA Strategies focusing on automation. • Build and maintain scalable, efficient testing frameworks using Cypress and Playwright/Pest4 for front end and back end services • Triage bugs, define quality metrics and coverage, defects and update on release.
• Review clinical incidents • Follow SOP to determine root cause, risk, and resolution • Process interim medical orders • Perform follow-up calls for high-risk patients • Communicate with clients, caregivers, and key stakeholders • Follow regulatory guidelines for clinical incidents • Share insights from aggregate data for quality improvement • Collaborate with assistant director of nursing services
• We're looking for a QA Analyst to join our Product & Engineering team. • You'll be responsible for ensuring the quality and reliability of the Hivebrite platform through thorough manual testing, clear documentation, and close collaboration with developers and product managers. • You'll take ownership of quality within your squad's functional scope, contribute to test planning, drive bug resolution, and actively look for ways to improve how we test — including leveraging AI tools. • Design and execute detailed manual test cases covering functional, usability, and edge-case scenarios for your squad's features. • Perform regression testing to ensure new changes don't break existing functionality. • Contribute to test planning by defining test objectives, scope, and strategy alongside developers and product managers. • Conduct exploratory testing to uncover issues that scripted tests might miss. • Own the full bug lifecycle within your functional scope — from identification and clear documentation in Jira, through triage, to resolution tracking. • Collaborate with developers on root cause analysis and validate fixes thoroughly. • Plan and execute QA activities within sprint timelines, ensuring quality without becoming a bottleneck. • Maintain clear, well-structured test documentation in Qase — including test plans, cases, and execution reports. • Use AI assistants and explore quality metrics.




