Summary
Professional Services at Guidewire partners with P&C; insurers worldwide to design, implement, and optimize mission-critical solutions on the Guidewire platform, with a strong focus on cloud and AI-enabled delivery. As part of this team, you’ll join a diverse, cooperative group that is redefining how services are executed to reduce implementation effort and time while accelerating customer value realization. We work in empowered, global teams that value curiosity, transparency, and continuous improvement.
Job Description
Role Overview
As a QA Engineer (Data Testing / ETL) in our Global Delivery team, you will be responsible for validating data quality, completeness, and transformations across end-to-end data pipelines and migrations into Guidewire InsuranceSuite and downstream systems. You will focus on SQL-driven backend validation, reconciliation, and non-functional checks, and are expected to execute day-to-day testing activities independently with minimal guidance while collaborating closely with data engineers, migration teams, and functional QA.
What you’ll do




Perform end-to-end ETL testing, including source-to-target data validation, reconciliation, and transformation checks across multiple stages of the pipeline.
Write and execute complex SQL queries for backend data validation.
Create detailed test plans, test scenarios, and test cases/scripts based on mapping documents, user stories, and business requirements.
Design and run reconciliation checks between legacy, staging, target databases, and reporting layers, ensuring no unexpected gaps or duplicates.
Validate data correctness in target applications to ensure migrated/loaded data supports key business scenarios.
Log, track, and manage defects to closure using tools such as Jira, including clear steps, SQL evidence, and impact analysis.
Provide regular test execution and status updates to leads and stakeholders, highlighting progress, defects, and risks.
Collaborate with cross-functional teams (da

📌 Consultant- Data lake (Bengaluru)
🏢 Guidewire Software
📍 Bengaluru