Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Lead the migration of Teradata data to Google Cloud Platform, optimising SQL queries.
- Company: Join a dynamic team in the commercial banking sector focused on cloud transformation.
- Benefits: Enjoy hybrid work flexibility and competitive pay of £475 per day.
- Why this job: Be part of a high-impact project that modernises data solutions and enhances your skills.
- Qualifications: Extensive Teradata experience and strong SQL optimisation skills are essential.
- Other info: This is a 6-month contract role with opportunities for professional growth.
The predicted salary is between 60000 - 84000 £ per year.
Location: London, UK (Hybrid – 2 days/week onsite)
Contract Type: 6-month contract (Inside IR35)
Rate: £475 per day
Join a high-impact transformation project in the commercial banking sector, leading the migration of a legacy Teradata data warehouse to Google Cloud Platform (GCP). This role is ideal for a data engineering expert with deep Teradata experience and a passion for cloud modernization.
Key Responsibilities:
- Lead the end-to-end migration of enterprise data solutions from Teradata to GCP.
- Design and implement scalable solutions leveraging Teradata utilities such as BTEQ, FastLoad, MultiLoad, and TPT.
- Collaborate with cross-functional teams to define and execute migration strategies.
- Optimize Teradata SQL queries for performance improvements.
- Ensure data integrity and consistency throughout the migration process.
Required Skills & Experience:
- Extensive hands-on experience with Teradata utilities (BTEQ, FastLoad, MultiLoad, TPT).
- Proficiency in Teradata architecture, including star and snowflake schemas.
- Strong skills in SQL optimization and data modelling.
- Experience with Teradata performance tuning, workload management (TASM), and partitioning strategies.
- Familiarity with Teradata tools such as Viewpoint, Query Grid, TD Stats, and TDWM.
- Proven experience in migrating Teradata workloads to GCP.
- Solid understanding of data warehouse concepts and ETL processes.
Preferred Qualifications:
- Experience with Google BigQuery and related GCP services.
- Knowledge of data security, governance, and compliance within cloud environments.
- Strong analytical and problem-solving skills.
- Excellent communication and collaboration abilities.
Teradata ETL Engineer employer: Queen Square Recruitment
Contact Detail:
Queen Square Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Teradata ETL Engineer
✨Tip Number 1
Familiarise yourself with the specific Teradata utilities mentioned in the job description, such as BTEQ, FastLoad, MultiLoad, and TPT. Being able to discuss your hands-on experience with these tools during interviews will demonstrate your expertise and readiness for the role.
✨Tip Number 2
Brush up on your knowledge of Google Cloud Platform (GCP) and its services, especially BigQuery. Understanding how to leverage GCP for data migration will set you apart from other candidates and show your commitment to cloud modernization.
✨Tip Number 3
Prepare to discuss your experience with SQL optimisation and performance tuning in detail. Be ready to provide examples of how you've improved query performance in past projects, as this is a key responsibility in the role.
✨Tip Number 4
Network with professionals in the data engineering field, particularly those who have experience with Teradata and GCP. Engaging with industry peers can provide valuable insights and potentially lead to referrals that could help you land the job.
We think you need these skills to ace Teradata ETL Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights your extensive hands-on experience with Teradata utilities and your proficiency in SQL optimisation. Use specific examples from your past roles that demonstrate your skills in data migration and cloud technologies.
Craft a Compelling Cover Letter: In your cover letter, express your passion for cloud modernisation and detail your experience with GCP migrations. Mention any relevant projects where you led the migration of data solutions, showcasing your leadership and collaboration skills.
Highlight Relevant Skills: Clearly list your technical skills related to Teradata architecture, performance tuning, and ETL processes. Make sure to include your familiarity with tools like Viewpoint and Query Grid, as these are crucial for the role.
Showcase Problem-Solving Abilities: Provide examples in your application that demonstrate your analytical and problem-solving skills. Discuss challenges you've faced in previous projects and how you overcame them, particularly in relation to data integrity and consistency during migrations.
How to prepare for a job interview at Queen Square Recruitment
✨Showcase Your Teradata Expertise
Make sure to highlight your extensive hands-on experience with Teradata utilities like BTEQ, FastLoad, MultiLoad, and TPT. Be prepared to discuss specific projects where you successfully implemented these tools, as this will demonstrate your capability to lead the migration process.
✨Demonstrate SQL Optimisation Skills
Since SQL optimisation is crucial for this role, come ready with examples of how you've improved query performance in past projects. Discuss the techniques you used and the impact they had on data processing efficiency.
✨Familiarise Yourself with GCP
As the role involves migrating to Google Cloud Platform, it’s essential to show your familiarity with GCP services, especially BigQuery. Brush up on your knowledge of cloud migration strategies and be ready to discuss how you would approach the transition.
✨Prepare for Collaboration Questions
This position requires collaboration with cross-functional teams, so be prepared to answer questions about your teamwork experiences. Think of examples where you successfully worked with others to achieve a common goal, particularly in data engineering or migration projects.
