Quality Assurance Analyst​/ETL Tester

Description

Briljent is seeking an experienced Quality Assurance
Analyst -
ETL Tester to support a State Government Medicaid Enterprise Data Warehouse (EDW) initiative. In this role, you will design, automate, and execute test strategies that ensure the accuracy, integrity, and reliability of healthcare data flowing through enterprise ETL pipelines.

You will work closely with data architects, ETL developers, and business stakeholders in an Agile environment—leveraging Informatica Power Center
, Teradata
, and Azure Dev Ops to validate complex Medicaid data transformations and loading processes.

• Review Change Requests (CRs) and participate in requirement analysis for new EDW extracts and transformations.
• Collaborate in data modeling and requirement‑gathering sessions to ensure testing aligns with business and regulatory needs.

• Perform backend testing to compare data from source systems to target Medicaid EDW tables.
• Validate source‑to‑target mappings, transformation logic, and business rules.
• Ensure data quality, standardization, completeness, and load accuracy.

• Write and execute complex SQL queries (multi‑table joins, aggregations, validations).
• Perform row counts, null checks, duplicate detection, and referential integrity testing.

• Design and maintain ETL test plans, scenarios, and test cases.
• Execute manual and automated testing for full‑load and incremental data loads.
• Document results clearly and communicate findings to technical and business stakeholders.

• Identify, document, and track defects using tools such as Azure Dev Ops, JIRA, or HP ALM.
• Partner with ETL developers to troubleshoot issues, retest fixes, and support regression testing.

• Develop automated data validation scripts using Python, SQL Alchemy, and Pandas
  .
• Create shell scripts for ETL monitoring and log analysis.
• Integrate test automation into CI/CD pipelines within Azure Dev Ops.

• Competitive compensation and flexible work arrangements

Requirements

• 5+ years of experience in software testing and quality assurance.
• 5+ years of experience testing backend systems, databases, EDW, or ETL pipelines.
• 4+ years of strong SQL experience with at least one RDBMS (Teradata, SQL Server, Oracle, Postgre
  
  SQL).
• 4+ years of experience with UI, smoke, end‑to‑end, and integration testing.
• 4+ years of troubleshooting and analytical problem‑solving experience.
• 4+ years of test design experience using a test management tool.
• Bachelor’s degree (or higher) in Computer Science, Information Technology, Data Analytics, Mathematics, or a related field.

Technical & ETL Knowledge

• Deep understanding of EDW and ETL concepts, including Star/Snowflake schemas and SCD Type 1 & 2.
• Hands‑on experience with ETL tools such as Informatica Power Center (preferred), Talend, SSIS, ADF, or similar.

Healthcare & Medicaid Domain Experience

• Direct experience with Medicaid systems and healthcare data.
• Knowledge of HIPAA, claims transactions (837/835), eligibility, provider data, and clinical standards (ICD‑9/10, CPT, HL7).

Tools & Methodologies

• Azure Dev Ops (Boards, Test Plans, Pipelines), JIRA, or HP ALM.
• Agile/Scrum sprint‑based delivery environments.

Soft Skills

• Strong written and verbal communication skills.
• Ability to collaborate across technical and non‑technical teams.
• Detail‑oriented with a commitment to data accuracy and quality.

• Experience validating Medicaid reporting, encounter data, and data marts.
• Familiarity with Medicaid Enterprise Systems (MES).
• Experience working with state Medicaid agencies.
• Python‑based test automation and Git Hub source control.
• Advanced Informatica Power Center expertise.

• Purpose‑driven work supporting Medicaid programs and public health initiatives
• Collaborative, respectful, and people‑first culture
• Opportunities to work on large, impactful state‑level systems

Physical Requirements

This position requires the ability to remain in a stationary position for extended periods of time and to use a computer and other standard office equipment. Occasional travel may be required, including the ability to navigate airports and client sites. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions of this role.

Briljent is a solutions‑based company. Solutions come from creative ideas; ideas come from being creative with differences. Briljent believes perspective and collaboration are critical to the success of the company. Employment at Briljent is based on merit and professional qualifications. We do not discriminate against any employee or applicant because of race, creed, color, religion, gender, sexual orientation, national origin, disability, age, veteran status, marital status, or any other basis protected by federal, state, or local law, regulation, or ordinance.