Teradata Migration Solution Architect [Teradata, Migration, Architecture, ETL, Data, AWS]

We are looking for Teradata Migration Solution Architect at Northampton, UK - 2-3 days per week Onsite

Job Description:

Our client is seeking an experienced Teradata Migration Solution Architect to lead large-scale migration and modernization of Teradata data warehouse platforms to AWS-based cloud data ecosystems. The role will define target-state architectures, migration strategies, governance frameworks, and oversee end-to-end delivery across critical banking domains including Payments, Retail Banking, Cards, Risk, and Financial Crime.

Key Responsibilities

• Define Teradata migration strategy, target data architecture, and modernization roadmap.
• Assess Teradata workloads, schemas, ETL processes, stored procedures, and dependencies.
• Design migration solutions to AWS services such as Redshift, S3, Glue, EMR, Aurora, and Lakehouse platforms.
• Lead migration planning, wave management, cutover, rollback, and data validation activities.
• Architect data integration, CDC, replication, and near-zero downtime migration approaches.
• Establish data governance, security, lineage, encryption, and regulatory compliance controls.
• Drive automation through Terraform, CI/CD, DataOps, and DevSecOps practices.
• Produce architecture artifacts (HLD/LLD) and present solutions to governance and architecture boards.
• Partner with business, engineering, security, and program teams to ensure successful migration delivery.

Required Skills & Experience

• 12+ years in Data Architecture/Data Engineering with 8+ years of Teradata and cloud migration experience.
• Strong expertise in:
• Teradata Vantage, BTEQ, TPT, FastLoad, MultiLoad
• AWS Redshift, S3, Glue, EMR, Aurora, DMS
• Data Warehousing, Data Lakes, Lakehouse Architectures
• ETL/ELT Modernization and SQL Migration
• Terraform, GitHub/GitLab, CI/CD, DevSecOps
• Experience delivering large-scale Teradata migration programs involving multi-terabyte or petabyte-scale datasets.
• Strong understanding of banking domains including Payments, Cards, Risk, KYC/AML, and Regulatory Reporting.
• Excellent stakeholder management, leadership, and communication skills.

Preferred Certifications

• AWS Certified Solutions Architect Professional
• AWS Data Analytics Specialty
• Teradata Vantage Certification
• TOGAF Certification

Ideal Candidate: A senior data architect with proven expertise in Teradata-to-AWS migrations, data platform modernization, and delivery of enterprise-scale transformation programs within regulated financial services environments.