Guidewire QA – ETL & Data Testing

Bitbybit Solutions; Chennai District; On-site; INR 6,00,000 - 10,00,000; Full time

Job summary

A tech solutions provider is seeking a QA Tester to perform functional and regression testing for Guidewire applications. The ideal candidate will have experience validating ETL workflows and executing SQL-based validations. Responsibilities include creating detailed test cases and collaborating with development teams. Applicants should have 4-8 years of QA experience, with strong skills in Guidewire testing and ETL/Data Testing. Familiarity with P&C insurance is preferred.

Qualifications

• 4-8 years of QA experience.
• 2+ years Guidewire testing experience.
• Hands-on ETL/Data Testing (SSIS, Informatica, DataStage, etc.).

Responsibilities

• Perform functional, integration, regression & E2E testing for Guidewire applications.
• Validate ETL workflows, source-to-target mappings, and data transformations.
• Execute SQL-based backend validations, data quality checks & reconciliation.

Skills

QA experience

Guidewire testing experience

Hands-on ETL/Data Testing

Strong SQL

Good understanding of P&C insurance

Experience with PolicyCenter, BillingCenter, ClaimCenter

Guidewire certifications

Automation exposure

ETL monitoring tools

Agile/Scrum experience

Job description

Key Responsibilities

• Perform functional, integration, regression & E2E testing for Guidewire applications
• Validate ETL workflows, source-to-target mappings, and data transformations
• Execute SQL-based backend validations, data quality checks & reconciliation
• Test configurations, business rules, product model & rating logic
• API testing using Postman/SoapUI
• Create detailed test cases, scenarios, and scripts
• Review requirements for full test coverage
• Log & track defects using JIRA
• Collaborate with Dev, BA, and business teams
• Support test planning, estimation & QA reporting

Required Skills

• 4-8 years QA experience
• 2+ years Guidewire testing experience
• Hands-on ETL/Data Testing (SSIS, Informatica, DataStage, etc.)
• Strong SQL
• Good understanding of P&C insurance
• Experience with PolicyCenter, BillingCenter, ClaimCenter
• Good to Have
• Guidewire certifications
• Automation exposure (Selenium, TestNG)
• ETL monitoring tools
• Agile/Scrum experience