Cloud Data Architect

We are seeking a highly skilled AWS Data Migration & Data Engineering Consultant to lead end-to-end data migration initiatives across on-prem, cloud, and multi-cloud environments into AWS.

This role focuses on defining and executing data migration strategies, including assessment, wave planning, migration execution, and post-migration stabilization, while ensuring data integrity, minimal downtime, and alignment with business SLAs.

The ideal candidate brings strong experience in cross-platform database migrations (Oracle, SQL Server, MySQL, or cloud-native systems) combined with deep expertise in AWS data engineering services and modern data pipeline development., * Lead end to end database migrations to AWS from diverse sources, including on-premises systems (e.g., Oracle, SQL Server, MySQL) and other cloud platforms (e.g., GCP, Azure).

• Lead end-to-end data migration strategy and execution, including assessment, dependency mapping, and wave planning
• Design and implement migration frameworks using AWS DMS, SCT, Glue, and Redshift
• Define and execute data validation, reconciliation, and cutover strategies ensuring zero/low data loss
• Enable CDC-based replication and minimal downtime migrations across heterogeneous systems
• Design and optimize ETL/data pipelines using AWS Glue, PySpark, or EMR
• Architect and implement scalable, secure, and highly available data platforms on AWS
• Drive schema conversion and modernization strategies (heterogeneous migrations where applicable)
• Optimize performance of source and target systems pre- and post-migration
• Manage and govern S3-based data lakes and metadata using Glue Data Catalog
• Collaborate with application, infrastructure, and analytics teams for seamless migration and stabilization
• Implement monitoring, rollback, and failure recovery mechanisms
• Ensure adherence to security, governance, and compliance standards

• 8+ years of experience in database migration and data engineering
• Proven experience in cross-platform data migrations (on-prem to cloud or cloud to cloud)
• Strong hands-on expertise with: AWS DMS (Database Migration Service), AWS SCT (Schema Conversion Tool), AWS Glue (ETL & data integration), Amazon Redshift (data warehousing)
• Experience designing and implementing data validation and reconciliation frameworks
• Strong experience in ETL/data pipeline development (Glue, PySpark, EMR, or equivalent)
• Deep proficiency in SQL and data modeling concepts
• Experience working with S3-based data lakes and Glue Data Catalog
• Strong understanding of CDC, transaction consistency, and migration cutover strategies
• Hands-on experience with performance tuning, schema design, and query optimization
• Proficiency in Python/PySpark and scripting (Shell/Python)
• Experience with Oracle, SQL Server, MySQL, PostgreSQL, or cloud-native databases

Nice to Have:

• Exposure to real-time replication tools (e.g., GoldenGate or equivalent)
• Database Administration (DBA) expertise, including backup & recovery strategies, HA/DR design, database patching and upgrades, lifecycle management, capacity planning, performance monitoring, and security hardening.
• Experience with Lake Formation and data governance frameworks
• Familiarity with Data Mesh and cross-account data sharing architectures
• Experience with CI/CD for data pipelines (CodePipeline, Jenkins, etc.)
• Knowledge of Infrastructure as Code (Terraform / CloudFormation)
• AWS Certifications (Solutions Architect / Data Engineer)
• Experience in mentoring teams and leading large-scale migration programs.

Quantiphi is an award-winning, AI-First digital engineering and consulting company focused on delivering high-impact Services and Solutions that help organizations solve what truly matters. We partner with enterprises to reimagine their businesses through intelligent, scalable, and transformative AI driving measurable outcomes at the very core of their operations. Since our founding in 2013, Quantiphi has tackled some of the world's most complex business challenges by combining deep industry expertise, disciplined cloud and data engineering practices, and cutting-edge applied AI research. Our work is rooted in delivering accelerated, quantifiable business value, not just technology for technology's sake. Headquartered in Boston, Quantiphi is a global organization with 4,000+ professionals serving clients across key industry verticals, including BFSI, Healthcare & Life Sciences, CPG, MFG, TME etc. As an Elite and Premier partner to leading cloud and AI platforms such as NVIDIA, Google Cloud, AWS, and Snowflake, we build and deliver enterprise-grade AI services and solutions that create real-world impact. We've been recognized with * 17x Google Cloud Partner of the Year awards in the last 8 years. * 3x AWS AI/ML award wins. * 3x NVIDIA Partner of the Year titles. * 2x Snowflake Partner of the Year awards. * We have also garnered top analyst recognitions from Gartner, ISG, and Everest Group. * We offer first-in-class industry solutions across Healthcare, Financial Services, Consumer Goods, Manufacturing, and more, powered by cutting-edge Generative AI and Agentic AI accelerators. * We have been certified as a Great Place to Work for the third year in a row- 2021, 2022, 2023. Be part of a trailblazing team that's shaping the future of AI, ML, and cloud innovation., What's in it for YOU at Quantiphi: * Make an impact at one of the world's fastest-growing AI-first digital engineering companies. * Upskill and discover your potential as you solve complex challenges in cutting-edge areas of technology alongside passionate, talented colleagues. * Work where innovation happens - work with disruptive innovators in a research-focused organization with 60+ patents filed across various disciplines. * Stay ahead of the curve-immerse yourself in breakthrough AI, ML, data, and cloud technologies and gain exposure working with Fortune 500 companies.