We are looking for a Senior Data Migration Engineer for our client in Cleveland, OH
Job Title: Senior Data Migration Engineer
Job Location: Cleveland, OH
Job Type: Contract
Job Overview:
Pay Range: $70hr - $75hr
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.