Overview
Remote
Full Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 6-12 Month(s)
Skills
Guidewire
ClaimCenter
PolicyCenter
Job Details
Role: Guidewire QA Lead
Location: USA/Canada (Remote)
Duration: 6+Months can be extendable
No of position: 1
Domain/Industry: Insurance
Year of Experience: 10+
Type: C2C/FTE
Role Summary:
Responsible for leading the data validation effort between Guidewire Aurora DB and SQL Server DB. Owns test planning, validation framework creation, execution oversight, and coordination with onsite teams. Ensures data accuracy, completeness, and consistency across PolicyCenter, ClaimCenter, and BillingCenter modules.
Key Responsibilities
Planning & Coordination
Lead overall QA strategy for cross-database comparison for PC/CC/BC applications.
Prepare detailed Test Plan, Test Scenarios, Entry/Exit Criteria, and Effort Estimates.
Assign tasks to Junior QA ETL Tester and monitor completion.
Coordinate with onsite dev, data engineering, and functional QA teams.
Conduct daily stand-ups, progress reporting, and defect triaging.
Technical Responsibilities
Understand Guidewire data models for PolicyCenter, ClaimCenter, BillingCenter.
Analyze schemas in Aurora DB (PostgreSQL/MySQL flavor) and SQL Server DB and identify differences.
Create automated or semi-automated data comparison scripts (SQL queries, checksum logic, row counts, column-level diff).
Validate ETL/replication logic (if applicable):
- Record counts
- Primary/foreign key integrity
- Data type comparison
- Referential integrity
- Transformation rules (if any)
Validate entity and column mapping for PC/CC/BC tables across both systems.
Root-cause mismatches and work with dev teams to resolve issues.
Quality Governance
Enforce QA best practices and code review for SQL/scripts used in comparison.
Ensure documentation of all mismatches, data gaps, and reconciliation logs.
Sign-off on data validation results for each Guidewire module.
Deliverables
Test Plan + Entry/Exit Criteria
Test Scenarios & Test Scripts
SQL Comparison Scripts
Daily/Weekly Status Reports
Defect Logs & RCA Summary
Final Data Reconciliation Report
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.