landing_page-logo
Sign Up
DATAMAXIS logo

Quality Assurance Analyst / ETL Tester (Remote)

DATAMAXISSpringfield, IL
Apply with Sonara

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.1

Reclaim your time by letting our AI handle the grunt work of job searching.

We continuously scan millions of openings to find your top matches.

pay-wall

Overview

Schedule
Full-time
Career level
Senior-level
Remote
Remote

Job Description

Quality Assurance Analyst / ETL Tester – Enterprise Data Warehouse

Location: Remote 

Position Summary:

  • The ETL Tester will be responsible for designing, automating, and executing test cases for Enterpris Data Warehouse (EDW) ETL processes in a State Government Medicaid environment. In this role, you will be responsible for ensuring the accuracy, integrity, and reliability of data as it moves through our ETL processes. You will leverage your expertise to design and execute test strategies that validate both functional and non-functional requirements of our data pipelines.
  • The tester will leverage ETL tools — primarily Informatica PowerCenter for extraction, transformation, and loading, and Teradata RDBMS for core data store validation — within Azure DevOps and agile sprint cycles to ensure data quality, identify defects, and automate repeatable testing processes.

Required Qualifications:

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

    • Key Responsibilities

    Requirement Analysis

  • 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 aligns with business needs

    • Data Validation –

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

    • SQL & Scripting

  • Write complex SQL queries (including multi-table JOINs, aggregations) to validate ETL outputs against business rules.
  • Conduct row counts, null checks, duplicate checks, referential integrity validation.

    • Test Strategy & Execution

  • Design test plans, test cases, and test scenarios for ETL processes.
  • Document test results and provide detailed feedback to stakeholders, highlighting areas for improvement
  • Execute manual and automated tests for both full-load and incremental-load cycles.

    • Defect Management

  • Identify, document, and track discrepancies using tools like JIRA, HP ALM, or Azure DevOps Test Plans.
  • Collaborate with ETL developers to resolve defects and perform regression testing.

    • Automation

  • Develop automated database validation scripts using Python, SQL Alchemy, and Pandas.
  • Create shell scripts for ETL monitoring and log analysis.
  • Integrate automation into CI/CD pipelines in Azure DevOps.

    • Required Skills & Qualifications

  • 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

    • Preferred Qualifications

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

    Automate your job search with Sonara.

    Submit 10x as many applications with less effort than one manual application.

    Apply with SonaraApply manually
    pay-wall

    FAQs About Quality Assurance Analyst / ETL Tester (Remote) Jobs at DATAMAXIS

    What is the work location for this position at DATAMAXIS?
    This job at DATAMAXIS is located in Springfield, IL, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.
    What pay range can candidates expect for this role at DATAMAXIS?
    Employer has not shared pay details for this role.
    What employment applies to this position at DATAMAXIS?
    DATAMAXIS lists this role as a Full-time position.
    What experience level is required for this role at DATAMAXIS?
    DATAMAXIS is looking for a candidate with "Senior-level" experience level.
    Does DATAMAXIS allow remote work for this role?
    Yes, this position at DATAMAXIS supports remote work, giving candidates the flexibility to work outside the primary office location.
    What is the process to apply for this position at DATAMAXIS?
    You can apply for this role at DATAMAXIS either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.