Quality Assurance Engineer - ETL/Datawarehouse Testing

Description :

- 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 to 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 :

1. PolicyCenter

2. BillingCenter

3. ClaimCenter

- Strong knowledge of STLC, defect management, and QA best practices

- Experience with API testing tools