Guidewire QA Lead

Guidewire QA Lead

Posted 2 days ago by Aroha Technologies

Apply
Negotiable
Undetermined
Remote
Remote
Apply
Agile Methodology Amazon Aurora Automation Bank Reconciliations Business Process Cloud Computing Cloud Technology Database Testing Data Comparison Data Consistency Data Engineering Datamodel Data Modeling Data Validation External Auditing Extract Transform Load (ETL) File Servers Foreign Keys General Insurance Guidewire Data Microsoft SQL Servers Reconciliation Referential Integrity Root Cause Analysis Scripting Software Testing Automation Framework SQL (Programming Language) Stakeholder Management Verification And Validation

Summary: The Guidewire QA Lead role involves leading data validation and quality assurance efforts across Guidewire platforms, specifically focusing on ensuring data consistency and accuracy between Guidewire Aurora databases and SQL Server databases. The position requires extensive QA leadership experience and deep knowledge of Guidewire data, along with hands-on expertise in database validation within enterprise insurance environments. The ideal candidate will coordinate with various teams and oversee junior testers while developing and executing comprehensive testing strategies. This is a contract position based in the USA or Canada, with a potential for extension.

Key Responsibilities:

  • Define and lead the overall QA and data validation strategy for cross-database comparisons supporting Guidewire applications.
  • Develop and maintain test plans, test scenarios, entry/exit criteria, and effort estimates.
  • Assign and oversee work for junior QA or ETL testers, ensuring timely and accurate execution.
  • Coordinate closely with development, data engineering, and functional QA teams.
  • Lead daily stand-ups, status reporting, defect reviews, and triage sessions.
  • Develop a strong understanding of Guidewire data models across PolicyCenter, ClaimCenter, and BillingCenter.
  • Analyze and compare schemas between Aurora databases (PostgreSQL/MySQL) and SQL Server environments.
  • Design and execute automated or semi-automated data comparison approaches, including SQL-based queries, row and record counts, checksum and column-level comparisons.
  • Validate ETL or replication processes, including record completeness and accuracy, primary and foreign key integrity, data type alignment and transformations, and referential integrity across systems.
  • Perform root cause analysis on data discrepancies and collaborate with technical teams to resolve issues.
  • Validate entity and column mappings across Guidewire modules and downstream systems.
  • Enforce QA best practices for data testing and script validation.
  • Ensure proper documentation of data mismatches, reconciliation results, and audit logs.
  • Review and approve data validation results and provide final QA sign-off for each Guidewire module.
  • Maintain clear communication with stakeholders regarding risks, defects, and resolution status.

Key Skills:

  • 10+ years of experience in Quality Assurance, with at least 3-5 years in a QA Lead role.
  • Strong hands-on experience testing Guidewire applications, including BillingCenter, PolicyCenter, and/or ClaimCenter.
  • Proven expertise in database testing and data validation using SQL.
  • Experience validating data across cloud-based and on-premise databases.
  • Strong understanding of insurance data and P&C business processes.
  • Experience working in Agile delivery environments.
  • Excellent communication, leadership, and documentation skills.
  • Experience with Guidewire cloud (Aurora) migrations or data replication projects is preferred.
  • Prior exposure to ETL validation and data reconciliation initiatives is preferred.
  • Familiarity with automation frameworks or scripting for data validation is preferred.
  • Guidewire certification(s) are a plus.

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: Insurance

Detailed Description From Employer:

Guidewire QA Lead

Location: USA / Canada (Remote)
Duration: 6+ Months (Contract, with potential extension)
Positions: 1
Experience Level: 10+ Years
Employment Type: Contract (C2C) or Full-Time
Industry: Insurance

Role Overview

We are seeking an experienced Guidewire QA Lead to lead end-to-end data validation and quality assurance efforts across Guidewire platforms. This role will be responsible for validating data consistency and accuracy between Guidewire Aurora databases and SQL Server databases across PolicyCenter, ClaimCenter, and BillingCenter modules.

The ideal candidate brings strong QA leadership experience, deep Guidewire data knowledge, and hands-on expertise with database validation and testing frameworks in enterprise insurance environments.

Key Responsibilities QA Strategy, Planning & Coordination

  • Define and lead the overall QA and data validation strategy for cross-database comparisons supporting Guidewire applications.

  • Develop and maintain test plans, test scenarios, entry/exit criteria, and effort estimates.

  • Assign and oversee work for junior QA or ETL testers, ensuring timely and accurate execution.

  • Coordinate closely with development, data engineering, and functional QA teams.

  • Lead daily stand-ups, status reporting, defect reviews, and triage sessions.

Technical & Data Validation Responsibilities

  • Develop a strong understanding of Guidewire data models across PolicyCenter, ClaimCenter, and BillingCenter.

  • Analyze and compare schemas between Aurora databases (PostgreSQL/MySQL) and SQL Server environments.

  • Design and execute automated or semi-automated data comparison approaches, including:

    • SQL-based queries

    • Row and record counts

    • Checksum and column-level comparisons

  • Validate ETL or replication processes, including:

    • Record completeness and accuracy

    • Primary and foreign key integrity

    • Data type alignment and transformations

    • Referential integrity across systems

  • Perform root cause analysis on data discrepancies and collaborate with technical teams to resolve issues.

  • Validate entity and column mappings across Guidewire modules and downstream systems.

Quality Governance & Reporting

  • Enforce QA best practices for data testing and script validation.

  • Ensure proper documentation of data mismatches, reconciliation results, and audit logs.

  • Review and approve data validation results and provide final QA sign-off for each Guidewire module.

  • Maintain clear communication with stakeholders regarding risks, defects, and resolution status.

Key Deliverables

  • Comprehensive Test Plans with Entry/Exit Criteria

  • Detailed Test Scenarios and Test Scripts

  • SQL-based Data Comparison and Validation Scripts

  • Daily and weekly status reports

  • Defect logs and root cause analysis (RCA) summaries

  • Final Data Reconciliation and Validation Report

Required Qualifications

  • 10+ years of experience in Quality Assurance, with at least 3-5 years in a QA Lead role.

  • Strong hands-on experience testing Guidewire applications, including BillingCenter, PolicyCenter, and/or ClaimCenter.

  • Proven expertise in database testing and data validation using SQL.

  • Experience validating data across cloud-based and on-premise databases.

  • Strong understanding of insurance data and P&C business processes.

  • Experience working in Agile delivery environments.

  • Excellent communication, leadership, and documentation skills.

Preferred Qualifications

  • Experience with Guidewire cloud (Aurora) migrations or data replication projects.

  • Prior exposure to ETL validation and data reconciliation initiatives.

  • Familiarity with automation frameworks or scripting for data validation.

  • Guidewire certification(s) are a plus.

Apply
Similar Jobs
Loading data...