
Teradata Data Engineer Interview Questions
& Process
Real candidates share what happened, how many rounds they had,
and how the experience turned out.
Based on 16 interview experiences · FREE TO READ
Candidate interview experiences
First-hand accounts from people who interviewed at Teradata.
Data Engineer
Basic questions on teradata indexes and optimisation. Explain secondary index. Explain teradata architecture. What is the purpose of partition primary index. What is the use of bynet. Explain teradata architecture. Explain amp storage. Explain data retrieval strategy.
- Can you explain performance optimization and primary indexes?
Senior Data Engineer
The interview process went very well until the end. I interviewed with 4 people and the process took about 2 months. Since every subsequent interview was dependent on a successful previous interview, I assumed they went well. After the last interview, I was told they will review feedback and contact me afterward. I didn't receive a call in 2 weeks. So I contacted the recruiter and she again said they are gathering feedback. After another 1 week, I sent another email asking if they were still interested. It's been 2 weeks since that email and no response. I wish they were courteous enough to tell their interviewees they didn't get the job. I had completed the last interview and was really excited about the idea of working for Think Big and even thought about turning down other offers. I feel they could have put me in a very precarious situation by not responding.
- Can you write a method to print a tree using indented lines?
Big Data Engineer
This was a terrible experience, I was treated poorly and advise others to avoid this company. The process started with an online technical test, which I passed. Next, I had a 90-minute technical interview involving coding, also passed. The final interview was with the hiring manager, and I received a draft offer by email with salary and contract details. A few days later, they asked about relocating to Rome. When I declined, as I had applied for the Milan position, everything stalled with ridiculous excuses. Initially, there was talk of 'due diligence,' then suddenly Hadoop became mandatory. The whole thing took 3 months, and throughout, the people I spoke with repeatedly assured me Hadoop wasn't required and that training was available, just like the job post said. The Milan position I was offered has since been reposted without the Hadoop requirement. It feels like they're making a mockery of candidates.
- Could you explain what a higher-order function is?
- Can you write the code to replicate the functionality of the Linux 'tree' command?
- In what scenarios would you consider pruning a decision tree?
Teradata Data Engineer Interview Questions
Quoted word for word from Teradata interview reports.
“What is an inode?”
Read reports →“Can you write the code to replicate the functionality of the Linux 'tree' command?”
Read reports →“What distinguishes an outer join from an inner join?”
Read reports →“Can you write a method to print a tree using indented lines?”
Read reports →“Given a table of customers and their food preferences, identify customers who like both oranges and apples.”
Read report →“What are the different types of memory in the Java Virtual Machine, such as young and tenured generation?”
Read report →“How would you go about terminating a process for any user in a Unix environment?”
Read report →“Could you explain what a higher-order function is?”
Read report →“Can you explain the difference between vertical and horizontal partitioning?”
Read report →Formats, difficulty and experience
Across all 16 Teradata interview reports.