Job Description
Are you a Data Engineer with deep Teradata expertise? Have you designed, tuned and run large enterprise data warehouses, and are you ready to lead their move to the cloud with Open Table Lakehouse architecture ?
Do you like solving complex, high-scale (billions+ records) data challenges? Do you enjoy leading teams through high-impact migration and modernisation programs that turn legacy warehouses into modern cloud data platforms? Would you like a career path that lets you grow with the rapid adoption of cloud computing?
AWS Professional Services is hiring a highly technical Data Engineer specialising in Teradata to work with our customers and partners on modernising their enterprise data warehouses on AWS. You’ll bring the deep platform knowledge needed to understand complex Teradata estates and design the move to AWS: assessing existing workloads, converting schemas, BTEQ and ETL code, validating data, and tuning performance on the target platform. Our consultants develop and deliver proof-of-concept projects and technical workshops, and support large, complex migration programs that drive data-driven decisions and the outcomes our customers want.
Key job responsibilities
• Expertise: Act as the trusted Teradata expert for customers and partners. Work with pre-sales and delivery teams to help them learn and use services such as Amazon Redshift, Amazon S3, AWS Glue, Amazon EMR, Amazon Athena, AWS Lake Formation, Amazon SageMaker Unified Studio (DataZone, lake formation), Amazon QuickSight and Amazon Bedrock as targets for Teradata workloads.
• Assessment & Design: Assess existing Teradata environments, including data models, workloads, BTEQ/TPT scripts, ETL pipelines, downstream consumers and SLAs. Design target-state architectures and migration strategies (re-platform, re-factor or hybrid).
• Solutions: Deliver technical engagements with partners and customers. This includes joining pre-sales visits, understanding customer requirements, building migration estimates and consulting proposals, and creating packaged Teradata migration offerings.
• Delivery: Lead hands-on migration and modernisation work, including schema and code conversion, historical and incremental data migration, reconciliation and data validation, performance tuning, and cutover planning. This work often spans on-premises and cloud environments.
• Insights: Work with AWS engineering and service teams to pass on customer needs and feedback as input to product roadmaps and migration tooling. Share real-world implementation challenges and recommend new capabilities that would make Teradata migrations simpler and faster.
• Push the envelope: Use GenAI and automation to rethink how legacy data warehouses are migrated, from automated code conversion and test generation to intelligent data validation, so customers modernise faster and at lower risk.
A day in the life
AWS Professional Services includes experts from across AWS who help our customers design, build, operate, and secure their cloud environments. Customers innovate with AWS Professional Services, upskill with AWS Training and Certification, optimize with AWS Support and Managed Services, and meet objectives with AWS Security Assurance Services. Our expertise and emerging technologies include AWS Partners, AWS Sovereign Cloud, AWS International Product, and the Generative AI Innovation Center. You’ll join a diverse team of technical experts in dozens of countries who help customers achieve more with the AWS cloud.
About the team
Diverse Experiences
AWS values diverse experiences. Even if you do not meet all of the preferred qualifications and skills listed in the job description, we encourage candidates to apply. If your career is just starting, hasn’t followed a traditional path, or includes alternative experiences, don’t let it stop you from applying.
Why AWS?
Amazon Web Services (AWS) is the world’s most comprehensive and broadly adopted cloud platform. We pioneered cloud computing and never stopped innovating — that’s why customers from the most successful startups to Global 500 companies trust our robust suite of products and services to power their businesses.
Inclusive Team Culture
AWS values curiosity and connection. Our employee-led and company-sponsored affinity groups promote inclusion and empower our people to take pride in what makes us unique. Our inclusion events foster stronger, more collaborative teams. Our continual innovation is fueled by the bold ideas, fresh perspectives, and passionate voices our teams bring to everything we do.
Mentorship & Career Growth
We’re continuously raising our performance bar as we strive to become Earth’s Best Employer. That’s why you’ll find endless knowledge-sharing, mentorship and other career-advancing resources here to help you develop into a better-rounded professional.
Work/Life Balance
We value work-life harmony. Achieving success at work should never come at the expense of sacrifices at home, which is why we strive for flexibility as part of our working culture. When we feel supported in the workplace and at home, there’s nothing we can’t achieve.
Basic Qualifications:
- 5+ years of technical specialist, design and architecture experience
- 5+ years of hands-on Teradata experience, including Teradata SQL, BTEQ, stored procedures and macros, and the Teradata load and unload utilities (TPT, FastLoad, MultiLoad, TPT, FastExport, WRITE_NOS, QueryGrid)
- 5+ years of experience designing and deploying ETL/ELT pipelines on enterprise data warehouse platforms (e.g. Informatica, DataStage, Ab Initio, dbt, PySpark) with good understanding about Open Table formats (Iceberg)
- Experience tuning Teradata performance, including primary index and partitioning (PPI) design, statistics collection, reading EXPLAIN plans, and fixing skew and spool issues
- Experience migrating from Teradata to a lake house on AWS (PySpark, S3/HDFS, Data modelling, AWS managed Airflow, Observability, Chargeback, PII handling) with designing historical data offload from Teradata, Migration strategy, Data Parity Testing strategy at Big Data scale, Wave Planning and cut over strategy
Preferred Qualifications:
- Experience migrating Teradata workloads/data to AWS (e.g. Amazon Redshift, Amazon S3 / Apache Iceberg lakehouse, AWS Glue, Amazon EMR, Amazon Athena), including converting schemas, BTEQ scripts and ETL code.
- Experience in translating business requirements to Architecture (High- and Low-level Design). Understanding Security needs of the solution across different persona and translating to security design (RBAC)
- Experience with migration tooling such as AWS Schema Conversion Tool (SCT / any Agentic solution) and its data extraction agents, or comparable code-conversion and data-validation frameworks
- Experience with Teradata workload management and administration (TASM/TIWM, Viewpoint), capacity planning, and Teradata Vantage Cloud
- Familiarity with industry logical data models (e.g. Teradata FSLDM) and dimensional or Data Vault modelling
- AWS experience, with proficiency in a wide range of AWS services (e.g. EC2, S3, RDS, Lambda, IAM, VPC, CloudFormation, Amazon EMR, AWS Glue, Amazon Redshift, Amazon S3 Tables). Experience using GenAI-assisted tools (e.g. Amazon Bedrock, Amazon Q Developer) to speed up legacy code conversion from Teradata to PySpark, testing or documentation
Acknowledgement of country:
In the spirit of reconciliation Amazon acknowledges the Traditional Custodians of country throughout Australia and their connections to land, sea and community. We pay our respect to their elders past and present and extend that respect to all Aboriginal and Torres Strait Islander peoples today.
IDE statement:
Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.
Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.
More Information
Application Details
- Organization DetailsAmazon Web Services Australia Pty Ltd


Recommended Comments
There are no comments to display.
Join the conversation
You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.