Quality Assurance Analyst / ETL Tester
Briljent · Illinois, United States
- Hybrid
- Full-time
- $95,000 / year
- Illinois, United States
This role may have been filled. Drop your résumé and we'll check if it's still open — or find you similar roles.
Job highlights
- ETL Tester role for Medicaid EDW initiative.
- Ensure data accuracy and integrity via ETL pipelines.
- Collaborate with data architects and developers.
- Utilize Informatica, Teradata, Azure DevOps.
- Requires strong SQL and backend testing skills.
About the role
Quality Assurance Analyst ETL Tester
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 PowerCenter, Teradata, and Azure DevOps to validate complex Medicaid data transformations and loading processes.
Key Responsibilities
Requirement Analysis
- 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.
Data Validation
- 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.
SQL & Scripting
- Write and execute complex SQL queries (multi-table joins, aggregations, validations).
- Perform row counts, null checks, duplicate detection, and referential integrity testing.
Test Strategy & Execution
- 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.
Defect Management
- Identify, document, and track defects using tools such as Azure DevOps, JIRA, or HP ALM.
- Partner with ETL developers to troubleshoot issues, retest fixes, and support regression testing.
Automation
- Develop automated data validation scripts using Python, SQLAlchemy, and Pandas.
- Create shell scripts for ETL monitoring and log analysis.
- Integrate test automation into CI/CD pipelines within Azure DevOps.
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, PostgreSQL).
- 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.
Required Skills & Expertise
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 PowerCenter (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 DevOps (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.
Preferred Qualifications
- 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 GitHub source control.
- Advanced Informatica PowerCenter expertise.
Why Briljent
- 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.
Key skills/competency
- Quality Assurance
- ETL Testing
- SQL
- Data Validation
- Test Automation
- Azure DevOps
- Informatica PowerCenter
- Medicaid Data
- Agile Methodologies
- Backend Testing
Skills & topics
- Quality Assurance Analyst
- ETL Tester
- SQL
- Data Validation
- Test Automation
- Azure DevOps
- Informatica PowerCenter
- Medicaid Data
- Agile
- Backend Testing
- Software Testing
- Database Testing
- EDW
- Python
- Healthcare Data
- HIPAA
- Teradata
- SSIS
- ADF
- Talend
- JIRA
- HP ALM
- CI/CD
- State Government
- Public Health
How to get hired
- Tailor your resume: Highlight your 5+ years of QA experience, ETL testing, SQL expertise (Teradata, SQL Server, Oracle, PostgreSQL), and familiarity with tools like Informatica PowerCenter and Azure DevOps. Emphasize your experience with healthcare/Medicaid data and HIPAA regulations.
- Showcase automation skills: Detail your experience with Python, SQLAlchemy, Pandas, and CI/CD integration within Azure DevOps if applicable. Quantify achievements in test automation and defect reduction.
- Demonstrate domain knowledge: Clearly articulate your understanding of EDW, ETL concepts (Star/Snowflake, SCD Type 1 & 2), and specific healthcare/Medicaid data (HIPAA, claims, eligibility).
- Prepare for technical and behavioral questions: Be ready to discuss your approach to data validation, SQL query writing, test strategy design, and how you collaborate with cross-functional teams in an Agile environment.
- Network and research: Connect with Briljent employees on LinkedIn and research their company culture, values, and recent projects. Understand their commitment to public health initiatives.
Technical preparation
Practice complex SQL queries for data validation.,Familiarize with Informatica PowerCenter concepts.,Study EDW and ETL concepts (Star/Snowflake, SCD).,Review Azure DevOps for CI/CD integration.
Behavioral questions
Describe a complex data validation challenge.,How do you collaborate with developers?,Explain your approach to requirement analysis.,How do you ensure data accuracy and quality?
Frequently asked questions
- What specific Medicaid data experience is Briljent looking for in an ETL Tester?
- Briljent seeks candidates with direct experience in Medicaid systems and healthcare data. This includes knowledge of HIPAA, claims transactions (837/835), eligibility, provider data, and clinical standards like ICD-9/10, CPT, and HL7. Familiarity with Medicaid Enterprise Systems (MES) and working with state Medicaid agencies is also highly valued.
- What are the primary tools and technologies used by the Quality Assurance Analyst ETL Tester at Briljent?
- The role heavily utilizes Informatica PowerCenter (preferred), Teradata, and Azure DevOps. Candidates should also be proficient in writing complex SQL queries and have experience with defect tracking tools like JIRA or HP ALM. Experience with Python, SQLAlchemy, and Pandas for test automation is a plus.
- How does Briljent approach test automation for their ETL processes?
- Briljent emphasizes test automation to ensure data accuracy and reliability. This involves developing automated data validation scripts using Python, SQLAlchemy, and Pandas, creating shell scripts for monitoring, and integrating these automation efforts into CI/CD pipelines within Azure DevOps. Experience with GitHub is also beneficial.
- What is the expected level of SQL proficiency for this ETL Tester role?
- A strong SQL background is crucial, with at least 4 years of experience. This includes the ability to write and execute complex queries involving multi-table joins, aggregations, and various validation types such as row counts, null checks, duplicate detection, and referential integrity testing.
- Can you describe the team environment for this Quality Assurance Analyst ETL Tester position at Briljent?
- This role operates within an Agile environment, requiring close collaboration with data architects, ETL developers, and business stakeholders. Briljent fosters a collaborative, respectful, and people-first culture, focusing on purpose-driven work supporting Medicaid programs.
- What are the key differences between the required and preferred qualifications for the ETL Tester role?
- Required qualifications include 5+ years in QA/ETL testing, 4+ years of strong SQL, and experience with specific tools. Preferred qualifications include experience with Python-based test automation (GitHub), advanced Informatica PowerCenter expertise, and direct experience validating Medicaid reporting, encounter data, data marts, or working with state Medicaid agencies.