ETL Tester

Summary

As an ETL Tester at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. This role is strictly involved in the development of the product and does not involve access to Protected Health Information (PHI) & Personally Identifiable Information (PII) or any secured/confidential client data. The work is limited to application development and does not include handling or processing of sensitive health information.

Your role in our mission

•    Understand and apply data analytics methodologies to support testing objectives.
•    Validate data ingestion processes and perform data-centric testing across systems.
•    Collaborate with SMEs, Business Analysts, and Data Analysts to identify key data elements and recommend improvements.
•    Manage and analyze large, complex datasets from multiple sources to identify gaps or issues in business controls.
•    Review and validate test cases, defect logs, and test execution results.
•    Partner with engineering and product teams to define test strategies and build automation frameworks.
•    Leverage Copilot skills for AI-assisted test case generation.
•    Execute smoke and regression testing to ensure system stability.
•    Work with test management and bug tracking tools like Azure DevOps (ADO), TFS, JIRA, or similar platforms.

What we're looking for

•    Develop and execute SQL scripts for database testing (12+ years of hands-on experience required).
•    Perform ETL testing and apply knowledge of data warehouse concepts (7–10 years preferred).
•    Hands-on experience with relational and OLAP databases.
•    Utilize API testing tools such as Swagger, Postman, and SoapUI.
•    Practical exposure to Python programming (especially relevant for future functional testing requirements).
•    Familiarity with Unix shell scripting.
•    Working knowledge or experience with Databricks.
•    Proficient in AWS cloud services (AWS is the primary cloud platform for this role; Microsoft Azure knowledge is a plus but not mandatory).
•    Experience in tools such as Power BI or Tableau (required only if dashboard testing is part of the scope).
•    Knowledge of AWS cloud data services (Lambda, S3, ECS, EKS, CloudWatch, CloudTrail, API Gateway) – considered a plus

What you should expect in this role

Work mode - Remote environment