About the role
The Senior QA Engineer will design and maintain automated test scripts using Python and PyTest while performing SQL-based data validation across ETL and reporting layers. They are responsible for managing test cases, tracking defects in Azure DevOps or Jira, and collaborating with cross-functional teams to perform root cause analysis.
What they look for
Requirements
Candidates must possess strong Python programming skills and hands-on experience with the PyTest framework. Proficiency in SQL, QA methodologies, and experience with test management tools like Azure DevOps or Jira are essential for this role.
Benefits
Full 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
ESSENTIAL RESPONSIBILITIES:
Importance
Major Action and Support Actions
1.
Test Planning and Script Preparation: Prepare test scenarios, test cases, scripts, and test data for functional, integration, regression, data, and reporting requirements.
2.
Python PyTest Automation: Design, develop, execute, and maintain automated test scripts using Python and PyTest, including reusable utilities, fixtures, assertions, and reporting.
3.
SQL and Data Validation: Perform SQL-based checks across databases, ETL/data pipelines, Snowflake/data warehouse layers, and reporting outputs.
4.
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.
5.
Defect Triage and RCA: Support defect triage and root cause analysis with development, product, business, and data teams to drive timely closure.
6.
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)
Similar roles
-
Automation QA Engineer MA
Simera Casablanca, Casablanca-Settat, Morocco
-
Automation QA Engineer MX
Simera Aguascalientes City, Aguascalientes, Mexico
-
QA Chemist - Grayling, MI
Bakelite Grayling, Michigan, United States
-
QA Chemist - Taylorsville, MS
Bakelite Taylorsville, Mississippi, United States
-
Senior Software QA - 2 Openings
Viasat, Inc. Batam, Riau Islands, Indonesia
-
Associate QA Analyst - Endur
Shell Bengaluru, Karnataka, India