Datamaxis is a WMBE corporation and committed to provide IT services to commercial and government organizations.
Quality Assurance Analyst – ETL Tester
Location
Illinois
Posted
30 days ago
Salary
0
Seniority
Senior
Job Description
Quality Assurance Analyst – ETL Tester
DATAMAXIS, Inc
• 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.
Job 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 (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
- Health insurance
- Flexible work hours
- Professional development opportunities
Related Guides
Related Categories
Related Job Pages
More QA Engineer Jobs
Principal Quality Engineer
Heartbeat HealthHeartbeat Health is a venture-backed health tech company focused on making cardiovascular care accessible everywhere. It is revolutionizing how heart care is delivered by combining
• Quality strategy for our clinical platform • Define what quality means at Heartbeat, how we measure it, and how we improve it - across partner-specific configurations, clinical decision support, workflow orchestration, and integration points. You own the quality outcomes, not just the test artifacts. • Validation architecture • Design the systems that make validation fast, reliable, and low-friction - test data strategies, environment management, automation frameworks, CI/CD integration. Give engineers back time by making quality infrastructure a force multiplier, not a tax. • Release confidence • Strengthen release predictability by systematizing validation earlier in the development lifecycle. When something ships, the team should know - with evidence - that it works. • Embedded cross-functional partnership • This is not a handoff role. You'll sit inside the development process - participating in refinement, influencing how work is scoped and acceptance criteria are defined, shaping what "done" means. You're a core member of a small, high-impact team where everyone has direct access to product, engineering, and clinical leadership. • Exploratory testing where it matters • Perform targeted exploratory testing on high-risk areas - new features, edge cases, partner-specific configuration behavior, clinical workflow paths. You know when automation is the right tool and when human judgment is the only tool.
Perform quality engineering for new product development, assess product risks and mitigation strategies, support design validation protocols, and troubleshoot production issues utilizing problem-solving techniques and statistical analysis.
QA Engineer
CKEditorGet total back- and front-end control over your WYSIWYG editor. Build anything imaginable, with limitless possibilities.
• Owning end-to-end testing of complex back-end and cloud services running on AWS, Docker, and (where needed) VM setups • Designing, writing, and adapting automation scripts for API and environment testing across both SaaS and on-premises deployments • Validating integrations between CKEditor Cloud Services and depending components like CKEditor 5, Customer Portal • Running performance, stress, and regression testing on CKEditor ecosystem services • Partnering with developers to reproduce, triage, and resolve customers' technical and integration issues • Proactively identifying quality risks in the system and proposing improvements to test coverage, tooling, and CI reliability
• Define the scope and acceptance criteria for tests based on system requirements. • Develop test plans and strategies to ensure adequate coverage. • Identify risks and potential impacts related to software failures. • Specify test cases based on requirements and business rules. • Create test scripts for functional, regression, integration, usability, load, and security testing. • Execute manual and/or automated tests. • Identify, document, and report defects. • Validate bug fixes and perform regression testing. • Develop and maintain test automation scripts (when applicable). • Record and document test results. • Recommend improvements based on test analysis. • Collaborate with developers, requirements analysts, and software architects. • Participate in refinement sessions and requirements-definition meetings. • Ensure software quality best practices are followed.



