:Data Architect

Extract Data from GWCP to Rawzone through the CDA Path for KCC, PC, and BC
· Extract data from Guidewire Cloud Platform (GWCP) to the Rawzone using the Change Data Capture (CDA) path for key components such as KCC (Claims Center), PC (PolicyCenter), and BC (BillingCenter).
· Ensure the extraction process is efficient and reliable, minimizing downtime and data loss.

Ensure Data is Sourced to New Schemas in Rawzone
· Design and implement new schemas in the Rawzone to accommodate the extracted data.
· Ensure that the data is accurately mapped to the new schemas, maintaining data integrity and consistency.

Integrate New Rawzone Schemas into the Trusted Zone/Vault Layer
· Integrate the new Rawzone schemas into the trusted zone or vault layer.
· Ensure that the data flows seamlessly from the Rawzone to the trusted zone, maintaining data quality and security.

Design and Implement Schema Mappings and Transformations
· Design schema mappings and transformations to convert raw data into a structured format suitable for analysis and reporting.
· Implement these mappings and transformations, ensuring they are optimized for performance and accuracy.

Implement Minimal Changes to the Refined Zone
· Make minimal changes to the refined zone to accommodate the new data structures.
· Ensure that the refined zone remains consistent and accurate, reflecting the latest data updates.

Ensure Data Consistency and Accuracy in the Refined Zone
· Monitor the refined zone to ensure data consistency and accuracy.
· Implement data validation and reconciliation processes to identify and resolve any discrepancies.

Leverage EOR to Populate PC, BC, and KCC Data to Datahub
· Use the Extract-Only Region (EOR) to populate PolicyCenter (PC), BillingCenter (BC), and Claims Center (KCC) data to Datahub.
· Ensure that the data is accurately and efficiently transferred to Datahub.

Monitor and Validate Data Integration Processes
· Continuously monitor data integration processes to ensure they are running smoothly.
· Validate the data integration to ensure that the data is accurate and complete.

Implement Any Required Changes to Datahub ODS and Extraction Layers
· Identify and implement any necessary changes to the Datahub Operational Data Store (ODS) and extraction layers.
· Ensure that these changes are optimized for performance and do not disrupt existing processes.

Ensure Data Extraction Processes are Optimized and Efficient
· Optimize data extraction processes to ensure they are efficient and scalable.
· Implement best practices for data extraction to minimize resource usage and maximize performance.

Load KSG EDW Loss Leveraging Either Snowflake Rawzone GWCP New Schemas or GWCP Read Replica
· Load KSG Enterprise Data Warehouse (EDW) Loss data using either the Snowflake Rawzone GWCP new schemas or the GWCP read replica.
· Ensure that the data loading process is accurate and efficient.

Validate and Reconcile Data Loading Processes
· Validate the data loading processes to ensure that the data is accurate and complete.
· Reconcile any discrepancies in the data to maintain data integrity.

Implement Any Required Changes to EDW
· Identify and implement any necessary changes to the Enterprise Data Warehouse (EDW).
· Ensure that these changes are optimized for performance and do not disrupt existing processes.

Ensure Data Integrity and Performance in the EDW Environment
· Monitor the EDW environment to ensure data integrity and performance.
· Implement best practices for data management and optimization to maintain a high-performing EDW environment.”