Data Migration Development Lead (AWS)

Tech3pillars Technologies; Virginia (IL); On-site; USD 120,000 - 180,000; Full time

Job summary

Tech3pillars Technologies in the United States is seeking an experienced Data Migration Development Lead to drive the design, development, and delivery of large-scale AWS data migrations. This role blends hands-on technical leadership with migration architecture, data engineering, quality assurance, and production cutover execution.

You will lead end-to-end migration design, build scalable ETL/ELT pipelines, implement data quality controls, and mentor developers while collaborating with

Qualifications

• 8+ years of experience in data engineering, ETL/ELT, or data migration.
• 3+ years of experience leading technical teams or migration workstreams.
• Strong hands-on expertise with AWS, Python, SQL, and PySpark.

Responsibilities

• Lead end-to-end data migration design, development, and implementation.
• Build scalable ETL/ELT and data migration frameworks using AWS services.
• Design data extraction, transformation, cleansing, validation, loading, and reconciliation processes.
• Develop migration runbooks, restart/recovery procedures, and operational controls.
• Establish CI/CD pipelines and Infrastructure as Code using Terraform, CloudFormation, or AWS CDK.
• Lead code reviews and technical design reviews.
• Mentor migration developers and provide technical guidance.
• Collaborate with architects, business stakeholders, and application teams to ensure successful migration outcomes.

Skills

AWS Cloud

Python

SQL

PySpark

Data Migration

AWS Glue

S3

Lambda

Step Functions

DMS

Data Quality

Data Modeling

CI/CD

Infrastructure as Code

Tools

Terraform

CloudFormation

AWS CDK

Job description

Data Migration Development Lead (AWS)

Location: St. Louis, MO
Experience: 8+ Years
Job Type: Long-Term Contract

Job Summary

We are seeking an experienced Data Migration Development Lead to drive the design, development, and delivery of large-scale data migration solutions using AWS. This role combines hands-on technical leadership with migration architecture, data engineering, quality assurance, and production cutover execution.

Key Responsibilities

• Lead end-to-end data migration design, development, and implementation.
• Build scalable ETL/ELT and data migration frameworks using AWS services.
• Design data extraction, transformation, cleansing, validation, loading, and reconciliation processes.
• Develop high-volume migration pipelines using AWS Glue, S3, Lambda, Step Functions, DMS, Redshift, and RDS/Aurora.
• Implement automated data quality, audit, reconciliation, and monitoring controls.
• Support multiple migration cycles, including testing, mock conversions, and production cutovers.
• Develop migration runbooks, restart/recovery procedures, and operational controls.
• Establish CI/CD pipelines and Infrastructure as Code using Terraform, CloudFormation, or AWS CDK.
• Lead code reviews and technical design reviews.
• Mentor migration developers and provide technical guidance.
• Collaborate with architects, business stakeholders, and application teams to ensure successful migration outcomes.

Must-Have Skills

• AWS Cloud
• Python
• SQL
• PySpark
• Data Migration / ETL / ELT
• AWS Glue, S3, Lambda, Step Functions, DMS
• Data Quality & Reconciliation
• Relational Databases & Data Modeling
• CI/CD and Infrastructure as Code

Required Qualifications

• 8+ years of experience in data engineering, ETL/ELT, or data migration.
• 3+ years of experience leading technical teams or migration workstreams.
• Strong hands-on expertise with AWS, Python, SQL, and PySpark.
• Experience with large-scale production data migrations.
• Strong knowledge of data quality frameworks, reconciliation, and validation.
• Strong understanding of relational databases, data modeling, and performance optimization.
• Experience with Agile delivery methodologies.
• Excellent troubleshooting, analytical, communication, and leadership skills.