Guidewire ClaimCenter Cloud Data Migration Engineer

Capgemini • New York, NY

1d • Onsite

About The Position

This position at Capgemini involves designing, developing, and maintaining AWS Glue jobs for data migration from legacy systems into Guidewire frameworks. The engineer will build scalable ETL/ELT pipelines using various AWS services and PySpark, implement complex data transformations, and execute data loads using Guidewire's CMT and DUT tools. Key responsibilities include ensuring data accuracy, performing root-cause analysis of migration failures, optimizing job performance, handling error remediation, and collaborating with data mapping and QA teams. The role also requires automating migration tasks, managing S3 data zones, ensuring data security, producing detailed documentation, and supporting critical cutover weekend executions to ensure successful migration completion across cloud environments.

Responsibilities

• Design, develop, and maintain AWS Glue jobs to extract, transform, and load data from legacy systems into Guidewire migration frameworks and target data structures.
• Build scalable ETL/ELT pipelines using PySpark, Glue Studio, Glue Workflows, Lambda, and Step Functions to support high‑volume migration batches.
• Implement complex data transformations, data cleansing rules, enrichment logic, and normalization required for CMT and DUT loads.
• Execute CMT (Conversion Migration Tool) and DUT (Data Upload Tool) loads across multiple environments.
• Ensure accuracy, consistency, and compliance with Guidewire migration requirements during data loads.
• Perform root‑cause analysis of migration failures, data quality issues, and system‑level errors.
• Apply fixes and rerun migration jobs as needed to resolve failures.
• Monitor AWS Glue job performance and optimize Spark configurations.
• Tune partitioning, parallelization, and throughput for large data sets.
• Handle end‑to‑end error remediation including exception handling and partial load cleanup.
• Implement restartable and recoverable migration patterns.
• Work closely with data mapping teams to interpret mapping specifications and apply transformation logic.
• Validate transformed data outputs against Guidewire data models.
• Collaborate with QA teams to support data validation, reconciliation, defect resolution, and mock migration cycles.
• Automate repetitive migration tasks using scripts, workflows, CI/CD pipelines, and parameterized Glue executions.
• Manage S3‑based staging, landing, and processed zones with correct file formats, partitioning, versioning, and lineage tracking.
• Ensure data security through IAM role configuration, encryption, audit logging, and compliance with enterprise cloud policies.
• Produce detailed runbooks, logs, documentation, and technical artifacts for batch execution and troubleshooting.
• Support cutover weekend execution by running loads, validating results, and resolving issues in near real time.
• Ensure successful migration completion across cloud environments.

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: Mid Level
• Education Level: No Education Listed
• Number of Employees: 5,001-10,000 employees