Experience with Teradata TDBMS ?
Teradata Developer Interview Questions
29 teradata developer interview questions shared by candidates
Can you write sample BTEQ to load data from source to target..
Tell me about confidence levels and collect statistics command.
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
Why Teradata is unique and 1 limitation.
When confronted with a database incident, what steps would you take to resolve?
My project related work .
How fast you can join
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.
1st round - Basic teradata questions 2nd round - they will check your problem solving and decision making skills.
Viewing 1 - 10 interview questions