At a Glance
- Tasks: Design and optimise high-performance Teradata data warehouse solutions while leading migration to modern platforms.
- Company: Join a forward-thinking tech company focused on data innovation.
- Benefits: Attractive salary, flexible working options, and opportunities for professional growth.
- Other info: Dynamic role with excellent career advancement potential.
- Why this job: Be at the forefront of data transformation and make a significant impact in the tech industry.
- Qualifications: 8-12+ years of Teradata experience and strong SQL skills required.
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.
- 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.
Performance Optimization & Database Management
- Perform query tuning and optimization using explain plans.
- Implement indexing strategies including PI, SI, Join Index, and PPI.
- 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.
Data Migration & Modernization
- 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 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 strong focus on employee growth, we provide ample opportunities for professional development and the chance to work on cutting-edge data migration projects in a dynamic environment. Located in a vibrant area, our workplace promotes a healthy work-life balance and fosters a sense of community among team members.
StudySmarter Expert Advice🤫
We think this is how you could land Teradata Subject Matter Expert
✨Tip Number 1
Network like a pro! Reach out to your connections in the data warehousing space, especially those who have experience with Teradata. A friendly chat can lead to insider info about job openings or even referrals.
✨Tip Number 2
Show off your skills! Prepare a portfolio showcasing your best SQL queries, ETL pipelines, and any performance optimisation projects you've tackled. This will give potential employers a taste of what you can bring to the table.
✨Tip Number 3
Ace the interview! Brush up on common Teradata interview questions and be ready to discuss your experience with migration strategies and cloud platforms. We want to see your passion for data and problem-solving skills shine through.
✨Tip Number 4
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
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 job description, so don’t be shy about showcasing your expertise in SQL, data modelling, and performance tuning!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re the perfect fit for the Teradata SME role. Share specific examples of your past projects, especially those involving migration to modern data platforms.
Showcase Your Problem-Solving Skills:In your application, highlight instances where you've tackled complex issues, like performance optimisation or troubleshooting production problems. We love seeing how you approach challenges and find solutions!
Apply Through Our Website:Don’t forget to submit your application through our website! It’s the best way for us to receive your details and ensures you’re considered for the role. Plus, we can’t wait to see what you bring to the table!
How to prepare for a job interview at HCLTech
✨Know Your Teradata Inside Out
Make sure you brush up on your Teradata skills before the interview. Be ready to discuss your experience with performance optimization, SQL query tuning, and data modelling techniques like star and snowflake schemas. The more specific examples you can provide, the better!
✨Showcase Your Migration Experience
If you've worked on migration projects from Teradata to modern platforms, be prepared to share your strategies and challenges faced during those transitions. Companies love hearing about real-world applications, so highlight any successful migrations you've led or contributed to.
✨Demonstrate Problem-Solving Skills
Expect questions that test your troubleshooting abilities. Prepare to discuss how you've monitored and resolved production issues in the past. Use specific scenarios where you implemented indexing strategies or used explain plans for query optimisation to illustrate your problem-solving prowess.
✨Familiarise Yourself with ETL Tools
Since experience with ETL tools like Informatica or DataStage is crucial, make sure you can talk about your hands-on experience with these tools. If you have knowledge of Unix/Linux scripting, don’t forget to mention it, as it can set you apart from other candidates.
