Guidewire Data Migration

Capgemini • New York, NY

1d • $90,000 - $135,000

About The Position

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired by a collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizations unlock the value of technology and build a more sustainable, more inclusive world.

Requirements

• 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

Nice To Haves

• Recommended use of other tools the team has found useful in previous engagements

Responsibilities

• Designs develops and maintains AWS Glue jobs to extract transform and load data from legacy systems into Guidewire migration frameworks and target data structures
• Builds scalable ETL/ELT pipelines using PySpark Glue Studio Glue Workflows Lambda and Step Functions to support high volume migration batches Implements complex data transformations cleansing rules enrichment logic and normalization required for CMTDUT loads
• Executes CMT Conversion Migration Tool and DUT Data Upload Tool loads across multiple environments ensuring accuracy 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
• 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

Benefits

• 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., 401(k) in the U.S., RRSP in Canada)
• Life and disability insurance
• Employee assistance programs
• Other benefits as provided by local policy and eligibility

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed
• Number of Employees: 5,001-10,000 employees