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. Here are the details on this position. 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

The ETL Test Engineer ensures the quality and reliability of data-driven products, with a primary emphasis on ETL testing and data analytics. The role involves developing robust test strategies and plans covering functional, performance, and data integrity aspects. Responsibilities include validating data transformations and outputs for accuracy and consistency, building and maintaining test scripts for ETL processes, and analysing test results to identify database impacts, bugs, and usability issues. The position is focused on product testing. 

Key responsibilities include:

• Hands-on experience with relational and OLAP databases.
• Utilise API testing tools such as Swagger, Postman, and SoapUI understanding of API automation frameworks.
• Practical exposure to Python programming.
• 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 analyse 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

•     Bachelor’s /Master degree in Computer Science, Information Systems, or a related field (preferred).
•     Prior experience in the US Healthcare domain is a strong advantage.
•     Strong grasp of Agile methodologies and practices, with solid understanding of SDLC and STLC.
•     Ability to work independently and mentor junior team members
•     Excellent communication skills to effectively engage with customers, support teams, and management.
•     Strong analytical and problem-solving abilities.
•     Well-organized with the ability to prioritize tasks and manage time efficiently.
•     Capable of handling multiple assignments simultaneously and adapting quickly to changing priorities.
•     Hands-on experience with relational and OLAP databases.
•     Utilize API testing tools such as Swagger, Postman, and SoapUI understanding of API automation frameworks.
•     Practical exposure to Python programming
•     Familiarity with Unix shell scripting.
•     Working knowledge or experience with Databricks.
•      Skilled in  AWS cloud services (AWS is the primary cloud platform for this role; Microsoft Azure knowledge is a plus but not mandatory).

What you should expect in this role

• Work Environment: Remote