ETL QA Tester (100% REMOTE/NO C2C)
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+11 more
Job description
- Develop and execute test strategies for legacy and Claimscore data integrations, ETL processes, APIs, and batch interfaces.
- Lead system integration, regression, end-to-end, and parallel processing validation.
- Create and maintain test plans, scenarios, scripts, and acceptance criteria based on business and technical requirements.
- Validate source-to-target mappings, transformation logic, record counts, and data completeness.
- Perform data reconciliation across legacy and Claimscore systems to identify discrepancies, duplicates, and processing inconsistencies.
- Verify consolidated data aligns with established enterprise data models and downstream application requirements.
- Utilize SQL and other tools to analyze data, validate results, and investigate defects.
- Support automated testing and data validation using SQL, Python, or comparable technologies.
- Coordinate defect tracking, root-cause analysis, resolution, and retesting with development and integration teams.
- Identify testing risks, dependencies, and quality concerns; communicate findings and readiness status to project leadership.
- Maintain testing documentation, defect logs, validation evidence, and quality metrics.
- Support production deployment validation, cutover activities, and post-implementation stabilization.
Requirements
- 7+ years of experience in IT quality assurance, quality control, or enterprise systems testing.
- Strong experience testing ETL processes, data integrations, APIs, and batch-processing systems.
- Advanced SQL skills for data validation, reconciliation, and troubleshooting.
- Experience developing test plans, test cases, and automated validation processes.
- Understanding of data warehousing, relational databases, enterprise data models, and source-to-target mappings.
- Experience validating REST APIs, JSON/XML, and file-based data integrations.
- Knowledge of integration, regression, system, and end-to-end testing methodologies.
- Experience with defect management, root-cause analysis, and quality reporting.
- Strong analytical, problem-solving, communication, and documentation skills.
- Ability to work independently and coordinate testing across technical and business teams.
Preferred Qualifications
- Healthcare claims processing experience, particularly Medicare claims.
- Experience testing legacy/mainframe integrations and modernization initiatives.
- Familiarity with claims, provider, beneficiary, and remittance data.
- Experience with Python, test automation frameworks, and enterprise testing tools.
- Experience validating parallel processing, data consolidation, and system migrations.
- Familiarity with enterprise data warehouses and production release processes., If youβre looking for rewarding employment and a company that puts its employees first, weβd like to work with you. Weβre driven, people driven
About the company
Our client, a US Fortune 50 organization and a leading provider of Health care and Health Insurance services, seeks an accomplished ETL QA Tester, Amerit Consulting is an extremely fast-growing staffing and consulting firm. Amerit Consulting was founded in 2002 to provide consulting, temporary staffing, direct hire, and payrolling services to Fortune 500 companies nationally; as well as small to mid-sized organizations on a local & regional level. Currently, Amerit has over 2,000 employees in 47 states. We develop and implement solutions that help our clients operate more efficiently, deliver greater customer satisfaction, and see a positive impact on their bottom line. We create value by bringing together the right people to achieve results. Our clients and employees say they choose to work with Amerit because of how we work with them - with service that exceeds their expectations and a personal commitment to their success. Our deep expertise in human capital management has fueled our expansion into direct hire placements, temporary staffing, contract placements, and additional staffing and consulting services that propel our clientsβ businesses forward.
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦