Senior ETL Backend Test Engineer (W2 ONLY)

Senior ETL Backend Test Engineer (W2 ONLY)

Posted Today by 1758184647

Negotiable
Outside
Remote
USA

Summary: The Senior Backend Test Engineer role focuses on backend testing, automation, and ETL testing for a leading health insurance provider. This position requires expertise in data migration projects, particularly transitioning from DB2 to MongoDB, and involves collaboration in an agile environment. Candidates must be based in Eastern or Central time zones and are expected to travel to Reston, VA quarterly for planning activities. The role is a W2 contract for 9 months and emphasizes strong testing and automation skills.

Key Responsibilities:

  • Designing and executing test plans, test cases, and test scenarios from scratch.
  • Creating and utilizing complex SQL queries to validate and verify backend processes.
  • Collaborating with cross-functional teams to review requirements, write defects, and contribute to agile ceremonies.
  • Conducting ETL testing, including processing and transforming large datasets for migration and organization.
  • Developing and automating test cases using Java and Jenkins.
  • Performing API testing and contributing to integration test strategies.
  • Mapping requirements to test cases and ensuring comprehensive coverage of test scenarios.
  • Actively participating in fast-paced team collaborations and effectively communicating technical details to stakeholders.

Key Skills:

  • At least 5 years of testing experience, with a focus on backend and ETL testing.
  • Proficiency in creating and using complex SQL queries.
  • Proficiency in writing code for automation using Java, Python, or similar.
  • Experience with automation testing, including proficiency in Selenium, Java, and Jenkins.
  • Hands-on experience with relational database management systems, such as DB2, Oracle, or SQL Server.
  • Strong understanding of the software development life cycle (SDLC).
  • Familiarity with Agile methodologies and tools, including Jira for test case repository and defect tracking.
  • Proven ability to develop test strategies, test plans, and test cases independently.
  • Excellent verbal and written communication skills for effective collaboration in large teams.
  • Healthcare or health insurance industry experience.
  • Experience with MongoDB.
  • API testing knowledge and experience.
  • Healthcare claims, enrollments, and/or contracts data expertise.
  • Any Generative AI experience.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:
***This is a W2 Oppoortunity
*** C2C/OPT candidates are NOT ELIGIBLE to apply for this role.
Role: Senior Backend Test Engineer - ETL
W2 Contract: 9 Months
Location: Remote
  • This position is remote. Candidates must be based in Eastern or Central time zones. Candidates based in a commutable distance to Reston, VA will be prioritized.
  • Candidates must be comfortable traveling to Reston, VA roughly once per quarter for PI planning activities.
Overview & Responsibilities
We are seeking highly skilled Senior Backend Test Engineers to join a dynamic team at a leading health insurance provider. The role focuses on backend testing, automation, and ETL testing to support data migration projects, including the transition from DB2 to MongoDB. These professionals will work in an agile environment to ensure the integrity, functionality, and quality of complex data transformations and integrations.
Key responsibilities include:
Designing and executing test plans, test cases, and test scenarios from scratch.
Creating and utilizing complex SQL queries to validate and verify backend processes.
Collaborating with cross-functional teams to review requirements, write defects, and contribute to agile ceremonies.
Conducting ETL testing, including processing and transforming large datasets for migration and organization.
Developing and automating test cases using Java and Jenkins.
Performing API testing and contributing to integration test strategies.
Mapping requirements to test cases and ensuring comprehensive coverage of test scenarios.
Actively participating in fast-paced team collaborations and effectively communicating technical details to stakeholders.
Required Skills & Experience
At least 5 years of testing experience, with a focus on backend and ETL testing.
Proficiency in creating and using complex SQL queries.
Proficiency in writing code for automation using Java, Python, or similar.
Experience with automation testing, including proficiency in Selenium, Java, and Jenkins.
Hands-on experience with relational database management systems, such as DB2, Oracle, or SQL Server.
Strong understanding of the software development life cycle (SDLC).
Familiarity with Agile methodologies and tools, including Jira for test case repository and defect tracking.
Proven ability to develop test strategies, test plans, and test cases independently.
Excellent verbal and written communication skills for effective collaboration in large teams.
Healthcare or health insurance industry experience.
Preferred Skills & Experience
Experience with MongoDB.
API testing knowledge and experience.
Healthcare claims, enrollments, and/or contracts data expertise.
Any Generative AI experience