Description

Design and manage data extraction and integration workflows between Guidewire Cloud Platform and enterprise data environments.

This role is on-site.

Responsibilities

• Extract data from Guidewire Cloud Platform to the Rawzone using the Change Data Capture path for KCC, PC, and BC.
• Design and implement new schemas in the Rawzone and integrate them into the Trusted Zone/Vault layer.
• Develop schema mappings and transformations to convert raw data into structured formats for analysis.
• Load KSG Enterprise Data Warehouse Loss data using Snowflake Rawzone GWCP schemas or read replicas.
• Monitor data integration processes, performing validation and reconciliation to ensure accuracy and integrity.

Required Skills

• 12+ years of experience in data architecture or engineering.
• Hands-on experience with Guidewire Cloud Platform (GWCP).
• Proficiency with PolicyCenter, BillingCenter, and Kemper Claims Center.
• Experience managing Datahub ODS and extraction layers.
• Deep understanding of Enterprise Data Warehouse environments.
• Expertise in Change Data Capture and data extraction optimization.
• Experience with Snowflake Rawzone and schema design.

Key Skills

Education

Any Gradute