Consultant- Data lake / ETL testing

Job Summary

Professional Services at Guidewire partners with PC 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.

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

Requirements

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

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.