Guidewire QA - ETL/Data Testing

Job Description

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: 4?8 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