Senior Consultant - Data lake/ ETL Testing

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, collaborative 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.

The Senior QA Engineer – Data Testing / ETL is responsible for validating data quality, completeness, and transformations across end-to-end data pipelines and migrations into Guidewire InsuranceSuite and downstream systems. This role focuses on SQL driven backend validation, reconciliation, and non-functional checks, working closely with data engineers, migration teams, and functional QA to ensure defect-free, production-ready data.

Job Description

Key Responsibilities

• 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.

• 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 daily/regular test execution and status reports to stakeholders, highlighting progress, defect trends, and risks.

• Collaborate effectively with cross-functional teams (data engineers, migration developers, functional QA, BAs, architects, and customer SMEs) to ensure data quality and timely delivery.

• Contribute to and maintain reusable SQL libraries, reconciliation templates, and best-practice checklists for data testing across projects.

• Mentor junior QAs new to data testing on SQL, reconciliation techniques, and Guidewire data migration concepts; contribute to reusable data-QA accelerators for PS.

Required Experience

• 6–8 years of overall QA / testing experience, with at least 3–4 years focused on data testing or data migration in enterprise systems.

• Strong SQL skills (joins, aggregations, reconciliation queries) and experience validating large datasets across multiple databases or stages.

• Hands-on experience in at least one of:

  • Data migration to core policy/claims/billing systems, or

  • ETL/ELT and data warehousing / data lake testing.

• Familiarity with Guidewire InsuranceSuite data models and migration tooling.

• Proven experience designing data test strategies, authoring detailed test cases, and executing reconciliation/NFR tests across multiple dry runs.

• Strong defect investigation skills: able to isolate issues using SQL, mapping documents, and logs, and articulate root causes and business impact.

• Comfortable working in Agile/Scrum delivery with distributed teams (data engineers, migration developers, functional QA, architects, customer SMEs).

• Good communication skills and ability to manage own workload, priorities, and timelines.

Nice to Have

• Experience on Guidewire based data migration projects (InsuranceSuite cloud or on-prem) or similar core system transformations.

• Exposure to cloud data platforms (e.g., AWS, Azure, Fabric/OneLake, Snowflake) and associated ETL/ELT tools.

• Experience with analytics and BI tools such as Power BI or Fabric and with Guidewire data tooling such as Data Studio and Explore, for validating downstream datasets, reports and KPIs.

About Guidewire

Guidewire is the platform P&C insurers trust to engage, innovate, and grow efficiently. We combine digital, core, analytics, and AI to deliver our platform as a cloud service. More than 540+ insurers in 40 countries, from new ventures to the largest and most complex in the world, run on Guidewire.

As a partner to our customers, we continually evolve to enable their success. We are proud of our unparalleled implementation track record with 1600+ successful projects, supported by the largest R&D team and partner ecosystem in the industry. Our Marketplace provides hundreds of applications that accelerate integration, localization, and innovation.

For more information, please visit www.guidewire.com and follow us on Twitter: @Guidewire_PandC.

Guidewire Software, Inc. is proud to be an equal opportunity and affirmative action employer. We are committed to an inclusive workplace, and believe that a diversity of perspectives, abilities, and cultures is a key to our success. Qualified applicants will receive consideration without regard to race, color, ancestry, religion, sex, national origin, citizenship, marital status, age, sexual orientation, gender identity, gender expression, veteran status, or disability. All offers are contingent upon passing a criminal history and other background checks where it's applicable to the position.