Data Migration Lead
DIVYANSHI TIWARIUnited StatesSENIORPosted 1h ago
AWSPostgreSQLDatabricksSQL ServerAzure SQLPower BIAWSDMSAWSGlue
About the Role
We are looking for an experienced Data Migration Lead to drive a large-scale enterprise database modernization initiative involving migration of transactional and analytical workloads into AWS. This is a hands-on technical leadership role, approximately 50% hands-on technical execution and 50% leadership.
Key Responsibilities
• Lead end-to-end enterprise database migration and modernization initiatives
• Develop migration runbooks, playbooks, standards, and repeatable processes
• Plan and lead mock migrations, production cutovers, validation, and stabilization
• Provide technical direction and oversight to Data Engineers
• Review and validate migration designs and engineering approaches
• Handle data cleansing, transformation, reconciliation, and source-to-target validation
• Identify migration risks, architectural issues, and technical dependencies
• Participate in architecture discussions and recommend improvements
• Ensure reliable data movement between transactional databases and analytical platforms
Requirements
• Strong hands-on experience leading enterprise-scale database migrations
• Strong AWS and transactional database experience
• Experience migrating SQL Server / Azure SQL to PostgreSQL-based environments
• Strong SQL skills and database troubleshooting experience
• Hands-on experience with data cleansing, transformation, and validation
• Databricks experience, including data ingestion, cleansing, transformation, and Medallion Architecture
• Experience leading engineers while remaining technically hands-on
Additional Experience
• Source-to-target mapping and schema conversion
• Mock migrations, production cutover, and post-migration stabilization
• Databricks Medallion Architecture (Bronze, Silver, Gold)
• Power BI and downstream analytical reporting