[Hiring] QA Analyst / ETL Tester @CSpring

Role Description

At CSpring, we believe in the power of people and data to drive real-world impact. We’re a purpose-driven consulting firm that helps organizations solve complex problems, gain insights, and achieve measurable results. Our clients span the public and private sectors, and our work — from data strategy and engineering to workforce transformation — improves lives across Indiana and beyond. We’re seeking talented professionals who are collaborative, curious, and committed to making a difference.

Why You’ll Love Working Here

• Work that carries real weight: You'll be validating data pipelines that support a state Medicaid system — your attention to detail has a direct downstream effect on how healthcare information reaches the people who need it.
• A team that takes quality seriously: CSpring has a culture of rigor and care. We don't ship sloppy work, and we hire people who feel the same way — you'll be surrounded by colleagues who hold the same standard.
• Room to grow your craft: You'll work across a modern, meaningful stack — Informatica PowerCenter, Teradata, Azure DevOps, and Python automation — with the latitude to improve and automate the processes you own.
• Collaboration without silos: Our teams work in tight Agile cycles with real communication between QA engineers, ETL developers, and business stakeholders.
• Purpose-driven clients: Our government and healthcare clients are doing work that matters to their communities. When you support their data infrastructure, you're part of that mission too.

What You’ll Do

• 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.

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

Preferred Qualifications

• Hands-on experience with Informatica PowerCenter
• Knowledge of Medicaid reporting, encounter data, and data mart validation
• Familiarity with Medicaid Enterprise Systems (MES) or a state Medicaid agency (e.g., Illinois HFS)
• Python test automation and GitHub for code management
• Experience integrating automated tests into CI/CD pipelines

Company Description

At CSpring, we unlock the potential of people and data. If you’re ready to lead meaningful work, collaborate with passionate teams, and grow your career in a people-first consulting environment — apply today!