Guidewire Data Migration
Role details
Job location
Tech stack
Job description
consistency and compliance with Guidewire migration. + requirements Performs root cause analysis of migration failures data quality issues and systemlevel errors applying fixes and rerunning jobs as needed + Monitors Glue job performance optimizes Spark configurations tunes partitioning and parallelization and improves throughput for large data sets + Handles end-to-end error remediation including exception handling partial load cleanup and restart able recoverable migration patterns + Works closely with data mapping teams to interpret mapping specs apply transformation logic and validate outputs against Guidewire data models + Collaborates with QA teams to support data validation reconciliation defect resolution and mock migration cycles + Automates repetitive migration tasks using scripts workflows CICD pipelines and parameterized + Glue executions Manages S3based staging landing and processed zones ensuring correct file formats partitioning versioning and lineage tracking +
Requirements
Ensures data security IAM role configuration encryption audit logging and compliance with enterprise cloud policies + Produces detailed runbooks logs documentation and technical artifacts for batch execution troubleshooting and future migration runs + Supports cutover weekend execution by running loads validating results resolving issues in near real-time and ensuring successful migration completion Skill Required- + Guidewire Claim Center Cloud Experience At least one full CC Cloud migration not on Prem only Knowledge of Claim Center financial model + Handling historic data transactional data Public ID preservation strategies + Ability to work in discovery heavy tasks + Data migration ETL Strong SQL complex extract process experience PySpark Glue ETL jobs + Data profiling and validation Cloud data migration AWS Glue S3 Step Functions RDS Aurora Postgres Experience migrating AWS cloud Leading Migration testing Reconciliation Business validation support + Knowledge of working with internal and 3rd party integrations Process Tools Agile experience in a SAFe delivery framework + Structured code reviews Experience using Azure ADO Use of AI tools to increase speed of migration work + Recommended use of other tools the team has found useful in previous engagements The base compensation range for this role in the posted location is: 90000- 135000 Capgemini provides compensation range information in accordance with applicable national, state, provincial, and local pay transparency laws. The base compensation range listed for this position reflects the minimum and maximum target compensation Capgemini, in good faith, believes it may pay for the role at the time of this posting. This range may be subject to change as permitted by law. The actual compensation offered to any candidate may fall outside of the posted range and will be determined based on multiple factors legally permitted in the applicable jurisdiction. These may include, but are not limited
Benefits & conditions
to: Geographic location, Education and qualifications, Certifications and licenses, Relevant experience and skills, Seniority and performance, Market and business consideration, Internal pay equity. It is not typical for candidates to be hired at or near the top of the posted compensation range. In addition to base salary, this role may be eligible for additional compensation such as variable incentives, bonuses, or commissions, depending on the position and applicable laws. Capgemini offers a comprehensive, non-negotiable benefits package to all regular, full-time employees. In the U.S. and Canada, available benefits are determined by local policy and eligibility and may include: + Paid time off based on employee grade (A-F), defined by policy: Vacation: 12-25 days, depending on grade, Company paid holidays, Personal Days, Sick Leave + Medical, dental, and vision coverage (or provincial healthcare coordination in Canada) + Retirement savings plans (e.g.