Senior Data Migration Engineer

Requirement/Must Have:

• Strong experience with AWS Glue, PySpark, and ETL/ELT pipeline development.
• Experience with Guidewire ClaimCenter Cloud and at least one full cloud migration implementation.
• Strong SQL skills with complex data extraction and transformation experience.
• Experience with AWS services, including S3, Lambda, Step Functions, RDS, and Aurora PostgreSQL.
• Knowledge of data migration tools such as CMT (Conversion Migration Tool) and DUT (Data Upload Tool).
• Experience with data profiling, validation, and reconciliation processes.
• Strong understanding of data transformation, cleansing, and normalization techniques.
• Experience handling large-scale data migration and high-volume datasets.

Experience:

• Hands-on experience in cloud data migration projects.
• Experience in leading migration testing and supporting business validation.
• Experience working in Agile/SAFe environments.

Responsibilities:

• Design, develop, and maintain AWS Glue jobs for data extraction, transformation, and loading.
• Build scalable ETL/ELT pipelines using PySpark, Glue Studio, Lambda, and Step Functions.
• Implement complex data transformation, cleansing, and enrichment logic.
• Execute migration tools (CMT and DUT), ensuring data accuracy and compliance.
• Perform root cause analysis for migration failures and data quality issues.
• Monitor and optimize Glue job performance and Spark configurations.
• Handle error remediation, restartable processes, and recovery mechanisms.
• Collaborate with data mapping teams to implement transformation logic.
• Support QA teams with validation, reconciliation, and defect resolution.
• Automate migration processes using scripts, workflows, and CI/CD pipelines.
• Manage S3-based data staging, partitioning, and data lifecycle.
• Ensure data security, IAM configurations, encryption, and audit compliance.
• Prepare documentation, runbooks, and technical artifacts.
• Support cutover activities and ensure successful migration execution.

Should Have:

• Experience with Guidewire Cloud Platform (GWCP).
• Experience building reconciliation dashboards and automation.
• Exposure to large-scale claims data migration.
• Experience with Azure DevOps (ADO) and structured code reviews.
• Familiarity with AI tools to improve migration efficiency.

Skills:

• AWS Glue, PySpark, ETL/ELT pipelines.
• SQL and data transformation.
• Cloud data migration and architecture.
• Performance tuning and optimization.
• Data validation and reconciliation.
• Agile/SAFe methodologies.

Qualification and Education:

• Bachelor s degree in Computer Science, Information Technology, or related field preferred.