Years of Experience: 4 to 6 Years

Any Hexaware Location

: ETL/Data Test Lead

Role Summary The ETL/Data Test Lead will lead end-to-end ETL, data migration, and data validation testing for a Guidewire implementation project. The role covers Guidewire PolicyCenter, BillingCenter, ClaimCenter, legacy systems, integrations, and downstream data platforms.

The candidate will own the data testing strategy, planning, execution, automation, defect management, and reporting while coordinating with business, development, data migration, and project teams.

Key Responsibilities

- Own and drive the ETL, data migration, reconciliation, and validation test strategy.
- Analyse business requirements, user stories, design documents, data models, and source-to-target mapping documents.
- Prepare test plans, effort estimates, schedules, test scenarios, test cases, and Requirements Traceability Matrices.
- Review SQL queries, stored procedures, reconciliation scripts, automation scripts, and test results.
- Validate policy, billing, claims, account, contact, producer, payment, financial, and reference data across Guidewire and connected systems.
- Execute and monitor ETL jobs, batch processes, data loads, dependencies, failures, and rejected records.

Required Skills and Experience

- 6 to 10 years of experience in ETL, database, data warehouse, or data migration testing.
- Advanced experience in writing and reviewing complex SQL queries.




- Experience with ETL tools such as Informatica, DataStage, Talend, Azure Data Factory, or AWS Glue.
- Experience with databases such as Oracle, SQL Server, PostgreSQL, or DB2.
- Knowledge of GenRocket or similar test data management tools.
- Experience in ETL test automation, model-based testing, test planning, effort estimation, and defect management.
- Strong understanding of Agile delivery and the complete Software Testing Life Cycle.
- Robust analytical, leadership, communication, and stakeholder-management skills.

Preferred Skills
- Experience in a Guidewire implementation, upgrade, or data migration project.
- Knowledge of Guidewire PolicyCenter, BillingCenter, and ClaimCenter data structures, integrations, batch jobs, and work queues.
- Understanding of property and casualty insurance processes, including new business, policy changes, renewals, cancellations, reinstatements, billing, payments, and claims.
- Exposure to Guidewire Cloud, Azure, AWS, Snowflake, Databricks, API testing, or scripting using Python, PowerShell, Unix Shell, or Java.
- Guidewire, ISTQB, cloud, or data-platform certification is desirable.

Education Bachelors degree in Computer Science, Information Technology, Engineering, or a related discipline.

Role Details

- Role: ETL/Data Test Lead
- Experience: 6 to 10 years
- Domain: Guidewire and Property & Casualty Insurance

Employment Type: Full-time

📌 Etl Tester (Chennai)
🏢 Hexaware Technologies
📍 Chennai