Senior Data Migration Engineer – AWS Cloud Migration

**FULLY REMOTE**

ScolerTec is seeking multiple Senior Data Migration Engineers – AWS Cloud Migration to plan, design, and execute large-scale legacy-to-cloud data migrations in modern AWS-based environments.

This is a hands-on engineering role focused on cloud migration architecture, migration automation, ETL/ELT, source-to-target mapping, data validation and reconciliation, CDC/incremental migration, cutover execution, rollback planning, and post-migration stabilization.

The ideal candidate has strong experience migrating enterprise databases and data platforms into AWS using technologies such as AWS DMS, AWS SCT, S3, RDS/Aurora, Redshift, Glue, Python, SQL, Terraform, and modern cloud data platforms .

Key Responsibilities

• Plan and execute enterprise data migration, conversion, transformation, and archival activities.
• Design migration strategies, migration waves, schedules, dependencies, and execution procedures.
• Build and maintain migration scripts, SQL, and ETL/ELT pipelines for legacy-to-cloud data transfers.
• Perform source data profiling, cleansing, transformation, and source-to-target mapping.
• Implement full-load and incremental/CDC migration approaches where appropriate.
• Perform automated reconciliation, completeness checks, validation, and post-load QA.
• Support migration testing, mock migrations, rehearsals, cutover preparation, production cutover, rollback, and stabilization.
• Troubleshoot migration failures, discrepancies, data-quality issues, and performance bottlenecks.
• Optimize migration jobs for high-volume datasets, throughput, scalability, and minimal downtime.
• Develop and maintain migration runbooks, mapping documents, issue logs, execution reports, and operational procedures.
• Support migration and integration across Oracle, SQL Server, PostgreSQL, and other enterprise data platforms.
• Work with AWS services and cloud-native data platforms such as RDS/Aurora, Redshift, S3, Glue, Databricks, or comparable technologies.
• Automate provisioning, migration workflows, data loading, and monitoring using Terraform, Python, SQL, dbt, or similar tools.
• Integrate migration solutions with CI/CD and enterprise DevSecOps processes.
• Support IAM/RBAC, security, privacy, retention, classification, and governance requirements.
• Collaborate with DBAs, architects, data engineers, platform engineers, governance teams, QA, and business stakeholders.
• Support disaster recovery, failover, cloud performance, and post-migration operational readiness.

Qualifications

• 5+ years of specialized experience in enterprise data migration, ETL/ELT, data engineering, or cloud modernization.
• Strong hands-on experience with legacy-to-AWS data migration .
• Hands-on experience with AWS DMS, AWS SCT, or comparable cloud migration technologies .
• Experience migrating enterprise databases such as Oracle, SQL Server, DB2, or PostgreSQL to AWS cloud platforms.
• Experience with full-load and CDC/incremental migration patterns.
• Strong experience with source-to-target mapping, data profiling, validation, reconciliation, and completeness testing.
• Experience participating in mock migrations, cutover planning/execution, rollback planning, and post-migration stabilization.
• Strong Python and SQL skills.
• Strong ETL/ELT and data-transformation experience.
• Experience with AWS services such as S3, RDS/Aurora, Redshift, Glue, Lambda, or Step Functions.
• Experience with cloud data platforms such as Databricks, Snowflake, or Redshift preferred.
• Experience with Terraform or other Infrastructure as Code tools.
• Experience with CI/CD, Git, DevSecOps, or enterprise release pipelines.
• Strong SQL performance tuning, indexing, partitioning, and query optimization skills.
• Experience supporting large-scale or high-volume migrations.
• Federal, public-sector, regulated-industry, or security-sensitive environment experience preferred.

Preferred Certifications

• AWS Certified Data Engineer
• AWS Certified Solutions Architect – Professional
• AWS Certified Data Analytics – Specialty
• Databricks Certified Data Engineer Professional
• Snowflake SnowPro
• Certified Data Management Professional (CDMP)