Senior QA Engineer

Arthur J. Gallagher & Co. (AJG); Gurugram District; On-site; INR 1,200,000 - 2,400,000; Full time

Benefits offered by this job

Competitive compensation

Benefits package

Career development

Job summary

Gallagher Center of Excellence in India seeks a Senior QA Engineer with strong Python and PyTest experience. The role covers automated and manual testing across data, API, ETL, and reporting, using Azure DevOps/Jira for end-to-end traceability. Strong SQL skills and data validation are essential, with Power BI/Tableau testing as a plus.

You will design, execute, and maintain tests, support RCA, and contribute to quality metrics while collaborating with global teams to deliver reliable solutions.

Qualifications

• Strong Python programming knowledge with hands-on PyTest.
• Ability to design, execute, and maintain automation scripts for regression, API, and data validation testing.
• Strong SQL skills for validation, reconciliation, joins, aggregations, and backend testing.
• Hands-on experience with Azure DevOps for test cases, defects, sprint tracking, and traceability.
• Strong understanding of QA methodologies, SDLC, STLC, Agile/Scrum, and defect lifecycle management.
• Experience in data/ETL testing (Snowflake, Synapse/SSMS), database validation, API testing, or report validation is preferred.
• Report validation and dashboard QA experience is a plus.
• Excellent communication, collaboration, stakeholder management, and problem-solving skills.

Responsibilities

• Test Planning and Script Preparation for functional, integration, regression, data, and reporting requirements.
• Python PyTest Automation: design, develop, execute, and maintain automated test scripts with reusable utilities.
• SQL and Data Validation across databases, ETL/data pipelines, Snowflake/data warehouse, and reporting outputs.
• ADO/Jira or other test management for test cases, defects, sprint tracking, and traceability.
• Defect triage and RCA with development, product, business, and data teams to drive timely closure.
• Quality Metrics and Reporting: QA status, test execution, defect, and automation metrics; Power BI/Tableau testing knowledge is a plus.

Skills

Python PyTest

SQL

Azure DevOps

QA methodologies

Data/ETL testing

Power BI/Tableau testing

Communication

Tools

Azure DevOps

Job description

Introduction

Welcome to Gallagher in India — where expertise, technology, and purpose come together. Since 2006, Gallagher in India has supported global teams by delivering quality, service, and speed through deep expertise, smart technology, and specialized knowledge services. More than just an operations center, it’s a place where careers grow through collaboration, continuous learning, and purposeful work. We drive efficiency, compliance, and innovation so our teams can focus on serving clients. If you enjoy solving problems and working with purpose, Gallagher is the place where you can grow and feel a sense of belonging.

Overview

Gallagher Center of Excellence is seeking to hire a Senior QA Engineer with strong Python programming knowledge and hands-on experience in the PyTest automation framework. This role involves preparing test scripts and test data, building PyTest automation, executing manual and automated tests, performing SQL validation, documenting defects, and supporting RCA. The Senior QA Engineer will use Azure DevOps (ADO)/Jira or any tool for test case management, defect tracking, sprint visibility, and end-to-end traceability. The role will ensure quality across software, data, API, ETL, and reporting solutions; Front end validation (Power BI/Tableau) testing knowledge is an added advantage.

How you'll make an impact

• Test Planning and Script Preparation: Prepare test scenarios, test cases, scripts, and test data for functional, integration, regression, data, and reporting requirements.
• Python PyTest Automation: Design, develop, execute, and maintain automated test scripts using Python and PyTest, including reusable utilities, fixtures, assertions, and reporting.
• SQL and Data Validation: Perform SQL-based checks across databases, ETL/data pipelines, Snowflake/data warehouse layers, and reporting outputs.
• ADO/Jira or any another test management tool for Testing and Defect Management: Manage test cases, defects, tasks, and traceability including evidence, reproducible steps, and status updates.
• Defect Triage and RCA: Support defect triage and root cause analysis with development, product, business, and data teams to drive timely closure.
• Quality Metrics and Reporting: Prepare QA status, test execution, defect, and automation metrics. Power BI /Tableau testing/report validation is an added advantage.

About you

KNOWLEDGE, SKILLS AND ABILITY:

(List the MINIMUM knowledge, skills and ability required to perform the essential functions of the position):

• Strong Python programming knowledge with hands-on experience in PyTest framework.
• Ability to design, execute, and maintain automation scripts for regression, API, and data validation testing.
• Strong SQL skills for validation, reconciliation, joins, aggregations, and backend database testing.
• Hands-on experience with Azure DevOps (ADO) for test cases, defects, sprint tracking, and traceability.
• Strong understanding of QA methodologies, SDLC, STLC, Agile/Scrum, and defect lifecycle management.
• Experience in data/ETL testing(Snowflake,Synapse/SSMS), database validation, API testing, or report validation is preferred.
• Report validation, and dashboard QA experience are added advantages.
• Excellent communication, collaboration, stakeholder management, and problem-solving skills.

Compensation and benefits

At Gallagher, we believe supporting our colleagues goes far beyond the role itself.For more information, visit our Benefits page.

• Competitive compensation
• Comprehensive benefits programs designed to support your well-being
• Career development opportunities and ongoing learning
• A collaborative, people-first culture with accessible leadership
• The opportunity to do meaningful work with global reach and local impact

At Gallagher, we are dedicated to building an inclusive and authentic workplace. If your past experience doesn’t align perfectly, we encourage you to join our Talent Community to stay connected to additional career opportunities. At times, we will consider transferable skills from previous roles.

Gallagher is an affirmative action/equal opportunity employer (Minorities/Females/Veterans/Disabled)