Description

You will validate ETL data flows, ensuring accuracy from source to target across Property & Casualty insurance domains.

This role is on-site.

Responsibilities

• Validate source-to-target data mappings, aggregations, and business transformation rules against functional requirements.
• Perform end-to-end data flow validation and reconciliation between source systems and target databases.
• Create and maintain ETL test strategies, scenarios, and cases for full, incremental, and delta loads.
• Execute smoke testing, System Integration Testing (SIT), and support UAT and regression testing.
• Identify defects with root cause analysis and collaborate with developers to resolve issues.

Required Skills

• 10+ years of experience in ETL testing and data validation.
• Advanced SQL proficiency, including complex queries, joins, and aggregates.
• Strong expertise in Agile and Scrum methodologies.
• Deep understanding of SDLC and STLC, specifically for data-centric projects.
• Domain awareness of Property & Casualty Insurance (Auto, Home, Umbrella LOBs).
• Experience using Rally for project tracking.
• Ability to collaborate with Business SMEs to preserve data meaning.

Preferred Skills

• Knowledge of Snowflake architecture.
• Experience with Guidewire Policy Center (GWPC) screen validations.

Key Skills

Education

Any Graduate