QA Analyst, ETL Tester

🕒 May 5

🌽 Illinois – Remote

🌽 Illinois – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

🔧 QA Engineer (Quality Assurance)

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

CSpring

WebsiteLinkedInAll Job Openings

51 - 200 employees

CSpring delivers the solutions and expertise needed to achieve technology-enabled business goals. Our team of full-time consultants focus on data-driven solutions that align business goals with technology and make information accessible, reliable, and engaging.

📋 Description

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

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