What are the responsibilities and job description for the Senior Data Migration Engineer - Guidewire ClaimCenter Cloud position at Lorven Technologies, Inc.?
Hi ,
Our client is looking for long term project and below is the detailed requirement.
Role: Senior Data Migration Engineer – Guidewire ClaimCenter Cloud (AWS)
Locations: Cleveland, OH (Hybrid)
Duration: Contract
Experience: 12 Years
Job Overview:
You will be responsible for designing, building, and executing end-to-end data migration pipelines from legacy systems into Guidewire ClaimCenter Cloud, ensuring accuracy, performance, and compliance across large-scale claims datasets.
This role involves direct ownership of migration execution, reconciliation, cutover support, and production readiness activities in a high-volume insurance environment.
Mandatory Skills:
- 12 years of experience.
- Hands-on experience with Guidewire ClaimCenter Cloud (GWCC/GWCP)
- At least one full end-to-end ClaimCenter Cloud migration project
- Strong experience in AWS Glue, PySpark, Step Functions, Lambda
- Advanced SQL skills for data transformation and reconciliation
- Experience with large-scale data migration and ETL pipelines
- Strong understanding of insurance claims data structures
- Experience with data validation, reconciliation, and migration testing
- Exposure to CMT and DUT tools
Preferred Qualifications:
- Guidewire financial model understanding
- Public ID migration strategies
- Experience with GWCP tenant environments
- Reconciliation dashboards / reporting automation
- Large-scale claims migration (millions of records)
- Agile / SAFe delivery environments
- Azure DevOps (ADO) CI/CD pipelines
Key Responsibilities:
- Design and build AWS Glue-based ETL/ELT pipelines for large-scale data migration into Guidewire ClaimCenter Cloud
- Develop scalable data workflows using PySpark, Glue Studio, Lambda, and Step Functions
- Execute CMT (Conversion Migration Tool) and DUT (Data Upload Tool) processes across environments
- Perform complex data transformations, cleansing, enrichment, and normalization
- Support migration of historical and transactional claims data
- Ensure Public ID preservation and Guidewire data model alignment
- Perform data profiling, validation, and reconciliation between source and target systems
- Troubleshoot and resolve migration failures, data issues, and system-level errors
- Optimize Spark jobs for performance (partitioning, parallel processing, throughput tuning)
- Support cutover weekend execution, including real-time issue resolution
- Automate migration workflows using scripts and CI/CD pipelines (Azure DevOps)
- Maintain S3 data zones (landing, staging, processed) with proper governance and lineage
- Produce technical documentation, runbooks, and migration execution guides