Description

You will design and manage data extraction and integration workflows between Guidewire Cloud Platform and enterprise data environments.

Responsibilities

• Extract data from Guidewire Cloud Platform (GWCP) to the Rawzone using the Change Data Capture (CDA) 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.
• Populate PolicyCenter, BillingCenter, and Kemper Claims Center data to Datahub using the Extract-Only Region (EOR).
• Load KSG Enterprise Data Warehouse (EDW) Loss data using Snowflake Rawzone GWCP schemas or GWCP read replicas.
• Monitor data integration processes, performing validation and reconciliation to ensure accuracy and integrity.
• Implement necessary changes to the Datahub Operational Data Store (ODS) and extraction layers.

Required Skills

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

Key Skills

Education

Any Gradute