FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Quality Assurance Analyst – ETL Tester
DATAMAXIS, IncETL Tester responsible for designing and executing test cases for Enterprise Data Warehouse. Ensuring accuracy and reliability of data processes in a State Government Medicaid environment.
Tech Stack
Tools & technologiesETLRDBMSSQL
About the role
Key responsibilities & impact- The ETL Tester will be responsible for designing, automating, and executing test cases for Enterprise Data Warehouse (EDW) ETL processes in a State Government Medicaid environment.
- Responsible for ensuring the accuracy, integrity, and reliability of data as it moves through ETL processes.
- Leverage expertise to design and execute test strategies that validate both functional and non-functional requirements of data pipelines.
- Perform backend testing to compare data in source systems to target Medicaid EDW.
- Verify source-to-target data mapping and transformation logic for Medicaid datasets.
- Validate data quality, standardization rules, and loading accuracy.
- Write complex SQL queries to validate ETL outputs against business rules.
- Conduct row counts, null checks, duplicate checks, and referential integrity validation.
- 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.
Requirements
What you’ll need- 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.
Benefits
Comp & perks- Health insurance
- Flexible work hours
- Professional development opportunities
ATS Keywords
✓ Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
ETL testingSQLdata validationtest designbackend testingdata mappingdata qualitytest automationdata transformationRDBMS
Soft Skills
analytical skillstroubleshootingcommunicationattention to detailproblem-solving