Guidewire Data architecture / Technical lead

Role: Guidewire Data architecture / Technical lead

Location: Jacksonville, FL - Onsite

Job Description:

Extract data from GWCP to Rawzone via CDA for KCC, PC, and BC.

Ensure efficient, reliable extraction minimizing downtime and data loss.

Design and implement new schemas in the Rawzone.

Accurately map extracted data to Rawzone schemas.

Integrate Rawzone schemas into the trusted zone or vault layer.

Ensure smooth data flow with maintained quality and security.

Design and implement schema mappings and transformations.

Optimize mappings for structured analytics and reporting.

Apply minimal changes to the refined zone to support new structures.

Monitor refined zone for consistency and accuracy.

Use EOR to populate PC, BC, and KCC data to Datahub.

Validate and monitor data integration for accuracy and completeness.

Update Datahub ODS and extraction layers as needed.

Load KSG EDW Loss data via Snowflake Rawzone or GWCP read replica.

Maintain EDW data integrity, performance, and implement improvements.