Guidewire QA – ETL & Data Testing

Bitbybit Solutions; Chennai District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Bitbybit Solutions in Chennai seeks a seasoned QA engineer to lead testing of Guidewire-based applications, perform ETL/data validations, and ensure data quality across modules.

You will design test cases, execute SQL validations, review requirements, and coordinate with Dev/BA teams. Experience with PolicyCenter, BillingCenter, ClaimCenter and automation exposure is favored.

Qualifications

• 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
• Guidewire certifications (nice to have)
• Automation exposure (Selenium, TestNG)
• ETL monitoring tools
• Agile/Scrum experience

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

Skills

QA experience

Guidewire testing

ETL/Data Testing

SQL

P&C insurance

PolicyCenter

BillingCenter

ClaimCenter

Guidewire certifications

Automation (Selenium)

TestNG

ETL monitoring tools

Agile/Scrum

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