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.

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 (data engineers, migration developers, functional QA, BAs, architects, and customer SMEs) to clarify requirements, analyse issues, and ensure data quality and timely delivery.

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

• Proactively identify data quality risks or gaps in test coverage and escalate them with clear recommendations.

What you’ll bring

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

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

• Hands-on experience in at least one of the following:

  • Data migration to core policy/claims/billing or other transactional 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/non-functional tests across multiple dry runs.

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

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

• Good communication skills and ability to manage your 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.