QA Engineer - ETL testing

1 Month ago • 5-8 Years • Testing

Job Summary

Job Description

The QA Engineer - ETL testing role at Zelis involves ensuring data accuracy and integrity within the data warehouse. Responsibilities include developing test plans for ETL processes, validating data, designing automated test scripts, and performing regression and performance testing. The role requires collaboration with data engineers and analysts, creating documentation, and utilizing knowledge of data warehouse concepts. The QA Engineer will write and execute queries to validate data, troubleshoot issues, and ensure high-quality deliverables. The job requires strong technical skills in ETL tools like Azure Data Factory and DBT, cloud platforms like Snowflake, API testing, SQL, automation with tools like Selenium WebDriver and pytest, and understanding of Agile/Scrum principles.
Must have:
  • Experience with ETL tools and frameworks, Azure Data Factory, and DBT.
  • Proficiency in SQL and experience with data warehousing concepts.
  • Experience with cloud data platforms, preferably Snowflake.
  • Knowledge of software testing best practices and methodologies.
  • Excellent analytical and problem-solving skills.
  • Bachelor's degree in Computer Science or related field.
Good to have:
  • Familiarity with healthcare domain concepts and regulations is a plus.

Job Details

About Us 

Zelis is modernizing the healthcare financial experience in the United States (U.S.) by providing a connected platform that bridges the gaps and aligns interests across payers, providers, and healthcare consumers. This platform serves more than 750 payers, including the top 5 health plans, BCBS insurers, regional health plans, TPAs and self-insured employers, and millions of healthcare providers and consumers in the U.S. Zelis sees across the system to identify, optimize, and solve problems holistically with technology built by healthcare experts—driving real, measurable results for clients.  

Why We Do What We Do 

In the U.S., consumers, payers, and providers face significant challenges throughout the healthcare financial journey. Zelis helps streamline the process by offering solutions that improve transparency, efficiency, and communication among all parties involved. By addressing the obstacles that patients face in accessing care, navigating the intricacies of insurance claims, and the logistical challenges healthcare providers encounter with processing payments, Zelis aims to create a more seamless and effective healthcare financial system.

Zelis India plays a crucial role in this mission by supporting various initiatives that enhance the healthcare financial experience. The local team contributes to the development and implementation of innovative solutions, ensuring that technology and processes are optimized for efficiency and effectiveness. Beyond operational expertise, Zelis India cultivates a collaborative work culture, leadership development, and global exposure, creating a dynamic environment for professional growth. With hybrid work flexibility, comprehensive healthcare benefits, financial wellness programs, and cultural celebrations, we foster a holistic workplace experience. Additionally, the team plays a vital role in maintaining high standards of service delivery and contributes to Zelis’ award-winning culture. 

Position Overview

Job Title: QA / ETL Tester

Responsibilities:

ETL Testing: Develop and implement comprehensive test plans and strategies for ETL processes, ensuring data accuracy, consistency, and completeness in the data warehouse.

Data Validation: Validate data at various stages of the ETL process, including data extraction, transformation, and loading, to ensure the integrity of the data warehouse.

Test Automation: Design, develop, and maintain automated test scripts and frameworks to streamline testing processes and enhance efficiency.

Regression Testing: Conduct thorough regression testing to identify and mitigate any potential issues or bugs introduced during the development process.

Performance Testing: Perform performance testing to assess the responsiveness, scalability, and stability of ETL processes and data pipelines, collaborating with the development team to optimize performance.

Collaboration: Work closely with data engineers, data analysts, and other stakeholders to understand project requirements, identify potential risks, and provide QA insights throughout the development lifecycle.

Documentation: Create detailed test cases, test reports, and documentation to facilitate effective communication and knowledge sharing within the team.
Data Warehouse Concepts: Apply knowledge of dimensional modeling and data warehouse concepts, such as star schemas, snowflakes, dimensions, and facts, in the testing process.

Sign-offs: Ensure all sign-offs on deliverables (overall test strategy, test plan, test cases) and that testing meets governance requirements.

Quality Assurance: Ensure the quality of work and the work of the entire development team.

Data Analysis: Write and execute queries to validate data and troubleshoot erroneous results, logging defects, and working with the development team to resolve software-related defects.


Technical Skills:

ETL Tools: Experience with ETL tools and frameworks, preferably with Azure Data Factory and DBT.
Cloud Platforms: Proficiency in using Snowflake for data warehousing.
API Testing: Experience with API testing tools such as Postman, SoapUI, or similar.
SQL and Scripting: Proficiency in SQL and scripting for data validation and test case data comparison.
Automation: Experience in test automation using tools like Selenium WebDriver, pytest, or similar.
Agile/Scrum: Understanding of Agile/Scrum development principles.
Data Integration: Knowledge of data integration techniques and best practices.


Requirements:

Bachelor's degree in Computer Science, Engineering, or a related field.
5-8 years of experience in quality assurance, with a focus on ETL and data warehousing.
Strong proficiency in SQL and experience with data warehousing concepts.
Experience with cloud data platforms, preferably Snowflake.
Familiarity with ETL tools like Azure Data Factory and DBT.
Knowledge of software testing best practices, methodologies, and tools.
Excellent analytical and problem-solving skills, with the ability to troubleshoot complex issues and provide effective solutions.
Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams and stakeholders.
Experience or familiarity with healthcare domain concepts and regulations is a plus.

Similar Jobs

PwC - Associate - Mumbai Shivaji Park - Technology Consulting

PwC

Mumbai, Maharashtra, India (On-Site)
9 Months ago
Side - LQA Game Tester (European Spanish)

Side

Braga, Braga, Portugal (Remote)
1 Month ago
bytedance - Senior Software Engineer - Development Infrastructure Team

bytedance

Mountain View, California, United States (On-Site)
8 Months ago
HYCU - Business Systems Operations Manager (Sales Operations)

HYCU

Bengaluru, Karnataka, India (Hybrid)
1 Week ago
Scopely - Head of Workplace & Facilities, EMEA

Scopely

Spain (On-Site)
8 Months ago
luxsoft - Performance Test Engineer

luxsoft

Pune, Maharashtra, India (On-Site)
1 Month ago
PwC - Senior Associate, Cyber Automation Engineer/Security Testing

PwC

Mumbai, Maharashtra, India (On-Site)
2 Weeks ago
Aristocrat - Sr Engineer I/II - Manual Testing

Aristocrat

Noida, Uttar Pradesh, India (Hybrid)
2 Weeks ago
GlobalStep - Senior Games Tester (Flight Sim Specialization)

GlobalStep

Dallas, Texas, United States (On-Site)
3 Months ago
Just wont die - Technical Quality Assurance Tester

Just wont die

Cambridge, England, United Kingdom (Hybrid)
1 Month ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Likewize - IT Tester

Likewize

Bristol, England, United Kingdom (On-Site)
3 Weeks ago
Palo Alto Networks - Sr Principal FinOps/DevOps Engineer (Cortex)

Palo Alto Networks

Santa Clara, California, United States (On-Site)
1 Month ago
Bebopbee - Game Producer

Bebopbee

Palo Alto, California, United States (Remote)
1 Month ago
Volley that - Staff Infrastructure Engineer

Volley that

San Francisco, California, United States (Hybrid)
1 Month ago
Rippling - Senior Support Specialist (German & English Support)

Rippling

London, England, United Kingdom (Hybrid)
1 Month ago
JDA - Sr. Industry Strategies Direction LSP

JDA

Bracknell, England, United Kingdom (On-Site)
3 Weeks ago
Enphase Energy - Senior Manager/Director Technical Support Engineering

Enphase Energy

Bengaluru, Karnataka, India (On-Site)
1 Week ago
HCL Tech - Sr. project manager with scrum master

HCL Tech

Jersey City, New Jersey, United States (On-Site)
1 Month ago
Tide - Customer Support Specialist with German (Subscription plans)

Tide

Sofia, Sofia City Province, Bulgaria (Hybrid)
2 Months ago
The Walt Disney Company - Executive Producer, Digital

The Walt Disney Company

Durham, North Carolina, United States (On-Site)
2 Months ago

Get notifed when new similar jobs are uploaded

Jobs in Hyderabad, Telangana, India

PhonePe - Social Media Manager

PhonePe

Bengaluru, Karnataka, India (On-Site)
2 Weeks ago
Capgemini - Associate Record to Analyze Process Expert

Capgemini

Noida, Uttar Pradesh, India (On-Site)
3 Weeks ago
Trellix - Senior Product Manager II - Security Platform

Trellix

Bengaluru, Karnataka, India (On-Site)
1 Month ago
Ramboll3 - SME

Ramboll3

Gurugram, Haryana, India (On-Site)
2 Weeks ago
NxtWave - Sr. XR Developer

NxtWave

Hyderabad, Telangana, India (On-Site)
8 Months ago
level ai - Senior QA Engineer

level ai

Noida, Uttar Pradesh, India (Hybrid)
11 Months ago
Assystems - Senior Bulk Material Handling Expert

Assystems

Chennai, Tamil Nadu, India (On-Site)
8 Months ago
PwC - IN-Senior Associate_Azure Data Enginer_Advisory Corporate_Advisory_Gurgaon

PwC

Gurugram, Haryana, India (On-Site)
9 Months ago
Google - Site Reliability Manager, Platforms and Devices, SRE

Google

Bengaluru, Karnataka, India (On-Site)
2 Months ago
Accenture - Measurement & Report Analyst

Accenture

Mumbai, Maharashtra, India (On-Site)
1 Month ago

Get notifed when new similar jobs are uploaded

Testing Jobs

Barracuda - Software Development Engineer in Test

Barracuda

Koramangala, Karnataka, India (Hybrid)
6 Months ago
endava - Senior Automation Tester

endava

Cluj-Napoca, Cluj County, Romania (Hybrid)
1 Month ago
Rocket - Software Engineer in Test III - ZOWE project

Rocket

Pune, Maharashtra, India (On-Site)
3 Weeks ago
Collaborative Robotics - Sr Software Engineer, Test

Collaborative Robotics

Santa Clara, California, United States (On-Site)
1 Month ago
ARHS - Junior - Mid Automation Test Engineer

ARHS

Athens, Greece (Remote)
1 Month ago
endava - Senior Test Automation Engineer

endava

Brisbane, Queensland, Australia (On-Site)
2 Weeks ago
Playstation - Senior Software Development Engineer in Test

Playstation

Dublin, County Dublin, Ireland (On-Site)
1 Month ago
Larian Studios - Technical QA Tester Internship

Larian Studios

Quebec, Canada (On-Site)
2 Months ago
Tencent - Compliance Testing Senior Manager

Tencent

Hong Kong (On-Site)
6 Months ago
Capgemini - Test Automation Engineer

Capgemini

Mumbai, Maharashtra, India (On-Site)
3 Weeks ago

Get notifed when new similar jobs are uploaded

About The Company

Zelis is modernizing the healthcare financial experience by providing a connected platform that bridges the gaps and aligns interests across payers, providers, and healthcare consumers. This platform serves more than 750 payers, including the top 5 national health plans, BCBS insurers, regional health plans, TPAs and self-insured employers, and millions of healthcare providers and consumers. Zelis sees across the system to identify, optimize, and solve problems holistically with technology built by healthcare experts – driving real, measurable results for clients.

Hyderabad, Telangana, India (Hybrid)

St. Louis, Missouri, United States (Hybrid)

St. Petersburg, Florida, United States (Hybrid)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (Hybrid)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

Hyderabad, Telangana, India (On-Site)

View All Jobs

Get notified when new jobs are added by Zelis

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug