Skip to contentSkip to footer

Teradata Interview Questions

Salaries
Interviews

29 teradata interview questions shared by candidates

I want all Employee data from below table having duplicate salary without using group by , in a single query in a best performance EmployeeID Salary 100 20000 101 20000 103 1456 104 2235 104 60000 105 60000
avatar

ETL Lead - Teradata, Informatica

Interviewed at Carelon Global Solutions

3.8★
12 Oct 2018

I want all Employee data from below table having duplicate salary without using group by , in a single query in a best performance EmployeeID Salary 100 20000 101 20000 103 1456 104 2235 104 60000 105 60000

There were 7 questions and all were analytical except one (Most were based on real time scenarios). The interviewer had lot of experience and knowledge, but while giving the scenario, he did not give his complete requirement. Had to answer the questions, by taking assumptions on what his question could be like. I was close to his answers, but it looked like he was expecting specific answer (pin-pointed). Not sure how he could have expected this without complete requirement. Moreover, as these are analytical questions, decision can't be taken in just 5-6 minutes. One can only have an approach to the problem. The interviewer also gave me the answer on what exactly he was looking in my answers, but I am very much sure, that it would fulfill his specific scenario, but in a real time problem, it might be difficult to implement the same in the real world as it might impact several other usecase. I did not argue with the interviewer as it is not worth doing that. I thanked the interviewer asked his name and left.
avatar

Tech Lead Teradata

Interviewed at Tech Mahindra

3.4★
25 May 2014

There were 7 questions and all were analytical except one (Most were based on real time scenarios). The interviewer had lot of experience and knowledge, but while giving the scenario, he did not give his complete requirement. Had to answer the questions, by taking assumptions on what his question could be like. I was close to his answers, but it looked like he was expecting specific answer (pin-pointed). Not sure how he could have expected this without complete requirement. Moreover, as these are analytical questions, decision can't be taken in just 5-6 minutes. One can only have an approach to the problem. The interviewer also gave me the answer on what exactly he was looking in my answers, but I am very much sure, that it would fulfill his specific scenario, but in a real time problem, it might be difficult to implement the same in the real world as it might impact several other usecase. I did not argue with the interviewer as it is not worth doing that. I thanked the interviewer asked his name and left.

Viewing 1 - 10 interview questions

Glassdoor has 29 interview questions and reports from Teradata interviews. Prepare for your interview. Get hired. Love your job.