QA Data Test Lead

Owlsure

Location

Experience

Primary skills:

Role Summary:

Lead the data validation effort between the Guidewire Aurora database and the SQL Server database. Own test planning, validation framework creation, execution oversight, and coordination with onsite teams. Ensure data accuracy, completeness, and consistency across PolicyCenter, ClaimCenter, and BillingCenter modules.

Key Responsibilities

Planning & Coordination

• Lead the overall QA strategy for cross-database comparison for PC/CC/BC applications.
• Prepare detailed Test Plans, Test Scenarios, Entry/Exit Criteria, and Effort Estimates.
• Assign tasks to Junior QA ETL Testers and track completion.
• Coordinate with onsite development, data engineering, and functional QA teams.
• Conduct daily stand-ups, progress reporting, and defect triage sessions.

Technical Responsibilities

• Understand Guidewire data models for PolicyCenter, ClaimCenter, and BillingCenter.
• Analyze schemas in Aurora DB (PostgreSQL/MySQL flavor) and SQL Server DB and identify differences.
• Create automated or semi-automated data comparison scripts, including SQL queries, checksum logic, row counts, and column-level comparisons.
• Validate ETL/replication logic (if applicable), including:
• Record counts
• Primary and foreign key integrity
• Data type comparison
• Referential integrity
• Transformation rules (if any)
• Validate entity and column mappings for PC/CC/BC tables across both systems.
• Perform root-cause analysis of data mismatches and collaborate with development teams to resolve issues.

Quality Governance

• Enforce QA best practices and conduct code reviews for SQL and comparison scripts.
• Ensure documentation of all mismatches, data gaps, and reconciliation logs.
• Provide sign-off on data validation results for each Guidewire module.

Deliverables

• Test Plan with Entry and Exit Criteria
• Test Scenarios and Test Scripts
• SQL Comparison Scripts
• Daily and Weekly Status Reports
• Defect Logs and RCA Summary
• Final Data Reconciliation Report.

About ValueMomentum

ValueMomentum is a leading solutions provider for the global property & casualty insurance industry, supported by deep domain and technology capabilities. We offer a comprehensive suite of advisory, development, implementation, and maintenance services across the entire P&C insurance value chain. This includes Underwriting, Claims, Distribution, and more, empowering insurers to stay ahead with sustained growth, high performance, and enhanced stakeholder value. Trusted by over 75 insurers, ValueMomentum is one of the largest standalone insurance-focused solutions providers to the US insurance industry.

Our culture – Our fuel

At ValueMomentum, we believe in making employees win by nurturing them from within, collaborating and looking out for each other.

• People first - Empower employees to succeed.
• Nurture leaders - Nurture from within.
• Enjoy wins – Recognize and celebrate wins.
• Collaboration – Foster a culture of collaboration and people-centricity.
• Diversity – Committed to diversity, equity, and inclusion.
• Fun – Create a fun and engaging work environment.

Warm welcome – Provide a personalized onboarding experience.

Company Benefits

Compensation - Competitive compensation package comparable to the best in the industry.

Career Growth - Career development, comprehensive training & certification programs, and fast track growth for high potential associates.

Benefits: Comprehensive health benefits and life insurance.