Guidewire QA - ETL/Data Testing

Position: Guidewire QA ETL & Data Testing
Location: Chennai
Work Mode: Onsite/Hybrid/Remote
Shift Timing: 3.00AM - 12.00PM PST (US Pacific Time)
Engagement Type: Full Time

About the role:
We are looking for an experienced Guidewire QA Engineer with strong expertise in ETL & Data Testing. The ideal candidate will work across Guidewire modules (PolicyCenter, BillingCenter, ClaimCenter) and ensure data accuracy, workflow validation, and end-to-end quality across insurance systems.

Key Responsibilities:

• Perform functional, integration, regression, and E2E testing for Guidewire applications
  
• Validate ETL workflows, source-to-target mappings, and complex data transformations
  
• Execute data testing, including data quality checks, reconciliation, and SQL queries
  
• Test Guidewire configurations, business rules, product model, and rating logic
  
• Develop and execute detailed test cases, test scenarios, and test scripts
  
• Perform API testing using Postman/SoapUI
  
• Review business/technical requirements and ensure complete coverage
  
• Log, report, and track defects to closure using tools like JIRA
  
• Collaborate with developers, BAs, and business teams to understand insurance workflows
  
• Support test planning, effort estimation, and daily QA reporting
  
  

Required Skills:

• 48 years of QA experience, with minimum 2+ years in Guidewire testing
  
• Hands-on experience in ETL / Data Testing (SSIS, Informatica, DataStage, or equivalent)
  
• Strong SQL skills for backend validation
  
• Good understanding of P&C Insurance domain policy, billing, claims
  
• Experience testing Guidewire modules:
  
• PolicyCenter
  
• BillingCenter
  
• ClaimCenter
  
• Strong knowledge of STLC, defect management, and QA best practices
  
• Experience with API testing tools
  
  

Good to Have:

• Guidewire Certification (QA, Policy, Billing, Claims)
  
• Exposure to automation tools (Selenium, TestNG)
  
• Hands-on with data validation tools or ETL monitoring tools
  
• Experience working in Agile/Scrum environments
  
  

Qualifications:

• Bachelor's degree in Computer Science, Engineering, or related field