At a Glance
- Tasks: Design and optimise high-performance Teradata data warehouse solutions while leading migration initiatives.
- Company: Join a forward-thinking company focused on data innovation and transformation.
- Benefits: Attractive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic role with a chance to work on cutting-edge cloud technologies.
- Why this job: Be at the forefront of data migration and modernisation, making a significant impact.
- Qualifications: 8-12+ years in Teradata development with strong SQL and performance tuning skills.
The predicted salary is between 70000 - 90000 € per year.
We are seeking a highly experienced Teradata Subject Matter Expert (SME) with strong expertise in Teradata development, performance optimization, and metadata management. The role involves designing, maintaining, and modernizing enterprise data warehouse solutions while supporting migration initiatives from Teradata to modern data platforms.
Key Responsibilities
- Design, develop, and maintain high-performance Teradata data warehouse solutions.
- Write and optimize complex SQL queries, stored procedures, macros, and views.
- Implement data modeling techniques including star and snowflake schemas.
- Develop and manage ETL/ELT pipelines using Teradata utilities and integrated tools.
- Ensure data quality, integrity, and consistency across enterprise systems.
- Perform query tuning and optimization using explain plans.
- Implement indexing strategies including PI, SI, Join Index, and PPI.
- Manage workload using TASM/TDWM.
- Monitor and troubleshoot production issues.
- Deep understanding of DBC.Tables, DBC.Columns, DBC.Indices, TablesV, ColumnsV.
- Use metadata for lineage, diagnostics, and schema discovery.
- Develop automation scripts using metadata.
- Lead migration from Teradata to cloud platforms.
- Define migration strategies and re-engineer ETL pipelines.
- Perform validation, reconciliation, and benchmarking.
Required Qualifications
- 8–12+ years of Teradata development experience.
- Strong SQL, data modeling, and performance tuning skills.
- Experience with ETL tools such as Informatica or DataStage.
- Knowledge of Unix/Linux scripting.
Preferred Qualifications
- Experience in Teradata migration projects.
- Knowledge of GCP is a plus.
- Experience with Apache Spark is a plus.
- Experience with DataStage or similar ETL tools.
Teradata Subject Matter Expert in London employer: HCLTech
Join a forward-thinking company that values innovation and expertise, offering a collaborative work culture where your skills as a Teradata Subject Matter Expert will be recognised and nurtured. With a focus on employee growth, we provide ample opportunities for professional development and the chance to lead exciting migration initiatives to modern data platforms. Located in a vibrant area, our workplace promotes a healthy work-life balance and fosters a supportive environment for all team members.
StudySmarter Expert Advice🤫
We think this is how you could land Teradata Subject Matter Expert in London
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even online forums. The more people you know, the better your chances of landing that Teradata SME role.
✨Show Off Your Skills
When you get the chance to chat with potential employers, don’t hold back! Share specific examples of your Teradata projects, especially those involving performance optimisation and data migration. Let them see your expertise in action!
✨Tailor Your Approach
Every job is different, so make sure you tailor your conversations to highlight the skills they’re looking for. Focus on your experience with SQL, ETL tools, and cloud migrations to show you’re the perfect fit for their needs.
✨Apply Through Our Website
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Teradata Subject Matter Expert in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your Teradata experience and skills. We want to see how your background aligns with the role, so don’t be shy about showcasing your SQL prowess and any relevant projects you've worked on.
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about the Teradata SME role and how your expertise can help us modernise our data solutions. Keep it engaging and personal!
Showcase Your Problem-Solving Skills:In your application, give examples of how you've tackled performance optimisation or migration challenges in the past. We love seeing candidates who can think critically and come up with innovative solutions.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at HCLTech
✨Know Your Teradata Inside Out
Make sure you brush up on your Teradata knowledge before the interview. Be ready to discuss your experience with SQL queries, performance tuning, and data modelling techniques like star and snowflake schemas. The more specific examples you can provide, the better!
✨Showcase Your Problem-Solving Skills
Prepare to talk about how you've tackled challenges in previous roles, especially around query optimisation and troubleshooting production issues. Use the STAR method (Situation, Task, Action, Result) to structure your answers and highlight your analytical skills.
✨Familiarise Yourself with Migration Strategies
Since the role involves migration from Teradata to modern platforms, be ready to discuss any relevant experience you have. If you’ve worked on cloud migrations or re-engineering ETL pipelines, make sure to highlight those projects and the strategies you employed.
✨Ask Insightful Questions
Interviews are a two-way street! Prepare some thoughtful questions about the company's data architecture, their current challenges with Teradata, or their future plans for data migration. This shows your genuine interest in the role and helps you assess if it’s the right fit for you.
