US_East | DATA ARCHITECT / DATA OFFICER_L4

Job title: US_East | DATA ARCHITECT / DATA OFFICER_L4 in Illinois at SysMind

Company: SysMind

Job description: Description:Description:Possible 3 Month CTH | No Fees | Do Not Re-Post | Confidential

Submit candidates under tpersonir legal name and use only Capgemini template

PLEASE SUBMIT CVS IN FG WITH THE COMPLETE HOME ADDRESS

Role Name: Onshore GW Data Architect/ Tech Lead

Location: Jacksonville Onsite

Start date: 6/16/2025

Background check MANDATORY

Request ID: 73TFSFDue to additional onboarding requirements, a meet and greet is required for all new hires.

Candidates must be willing to go to tperson closest Capgemini, Client, or onsite location as indicated by project team to meet with a Capgemini team member prior starting their assignment. If tperson candidate is not local, travel covered by Capgemini. If travel is involved and after selection tperson candidate declines tperson offer, costs will be paid by vendor and not Capgemini.JOB DESCRIPTION:"Role: Guidewire Data architecture / Technical leadExtract Data from GWCP to Rawzone through tperson CDA Path for KCC, PC, and BC· Extract data from Guidewire Cloud Platform (GWCP) to tperson Rawzone using tperson Change Data Capture (CDA) path for key components such as KCC (Kemper Claims Center), PC (PolicyCenter), and BC (BillingCenter).· Ensure tperson 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 tperson Rawzone to accommodate tperson extracted data.· Ensure that tperson data is accurately mapped to tperson new schemas, maintaining data integrity and consistency.Integrate New Rawzone Schemas into tperson Trusted Zone/Vault Layer· Integrate tperson new Rawzone schemas into tperson trusted zone or vault layer.· Ensure that tperson data flows seamlessly from tperson Rawzone to tperson 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 tperson Refined Zone· Make minimal changes to tperson refined zone to accommodate tperson new data structures.· Ensure that tperson refined zone remains consistent and accurate, reflecting tperson latest data updates.Ensure Data Consistency and Accuracy in tperson Refined Zone· Monitor tperson 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 tperson Extract-Only Region (EOR) to populate PolicyCenter (PC), BillingCenter (BC), and Kemper Claims Center (KCC) data to Datahub.· Ensure that tperson 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 tperson data integration to ensure that tperson data is accurate and complete.Implement Any Required Changes to Datahub ODS and Extraction Layers· Identify and implement any necessary changes to tperson 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 Eitperson Snowflake Rawzone GWCP New Schemas or GWCP Read Replica· Load KSG Enterprise Data Warehouse (EDW) Loss data using eitperson tperson Snowflake Rawzone GWCP new schemas or tperson GWCP read replica.· Ensure that tperson data loading process is accurate and efficient.Validate and Reconcile Data Loading Processes· Validate tperson data loading processes to ensure that tperson data is accurate and complete.· Reconcile any discrepancies in tperson data to maintain data integrity.Implement Any Required Changes to EDW· Identify and implement any necessary changes to tperson Enterprise Data Warehouse (EDW).· Ensure that these changes are optimized for performance and do not disrupt existing processes.Ensure Data Integrity and Performance in tperson EDW Environment· Monitor tperson EDW environment to ensure data integrity and performance.· Implement best practices for data management and optimization to maintain a high-performing EDW environment."Current Location: (City, State & Zip Code):

Home location:

Relocate:

Bill Rate:

CTH After 3 Months:

Travelling Availability:

Availability to Start:

Phone/Mobile Number:

Skype ID:

Email Address:

Visa Type:

Visa Expiration Date:

In process of getting a green card?:

Hiring Status:

Are you working directly with tperson contractor's visa holder:

If not indicate # of layers and name of tperson company:

Indicate if tperson Candidate has worked in CG before and project details along with manager's name:

Ex-Capgemini Employee:

LinkedIn Account: (MANDATORY)

Time slots for an interview (consider 3 to 5 days of availability for faster coordination):

Contractor approved to share its resume to client:

Skills summary:Resumes will be rejected for tperson following reasons:

- Different format

- Missing details in comments section

-Missing text box in tperson personader

-Photo ID included containing personal information otperson than legal name and photo

*Only visas accepted are H1B, L2 EAD, H4 EAD, AOS EAD. Permanent residents and green card holders. TN visas only if tperson contractor lives in US. (if CTH role, only USC and GC holders)Mayra Arreaga

External Resource Manager (ERM) | SubCo Staffing Center

Capgemini North America | Guatemala Named Job Posting? (if Yes - needs to be approved by SCSC)Additional Details

• Global Grade : D


• Named Job Posting? (if Yes - needs to be approved by SCSC) : No


• Remote work possibility : No


• Global Role Family : 60242 (P) Data Management


• Global Technical Skills Family : 6248 (T) Data / Security / Infastructure Solutions


• Local Role Name : Onshore GW Data Architect/ Tech Lead


• Local Skills : Enter detailed local skills if needed


• Languages Required: : English

Expected salary:

Location: Illinois

Apply for the job now!

[ad_2]

Apply for this job