AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Teradata Interview Questions, Process, and Tips
Top Teradata Interview Questions and Answers
- Q1. Data dictionary tables and where the history Data is storedasked in Senior Database Administrator interview
- Q2. What is polymorphism principle?asked in Software Developer interview
- Q3. What is accounts payable, whats the universal purposeasked in Analyst interview
Teradata Interview Experiences
51 interviews found
Anonymous
Selected
I applied via Approached by Company and was interviewed before Apr 2022. There were 2 interview rounds.
(4 Questions)
- Q1. Code and Explain LRU Cache
- Ans.
LRU Cache is a data structure that stores recently used items in a limited size cache.
LRU stands for Least Recently Used
It has a fixed size and when the cache is full, the least recently used item is removed to make space for new items
It uses a combination of a doubly linked list and a hash map to achieve O(1) time complexity for both insertion and deletion
When an item is accessed, it is moved to the front of the list ...
- Q2. API Based Questions and Architecture Discussion
- Q3. Linked List Based Questions
- Q4. AWS and Cloud Based Questions
Skills evaluated in this interview
Cloud Engineer 2 Interview Questions asked at other Companies
I applied via Referral and was interviewed in Sep 2021. There were 3 interview rounds.
(1 Question)
- Q1. Mostly questions inclined to the Teradata architecture and BAR related questions and DBA questions
(1 Question)
- Q1. Here manager asked me what do you know about Teradata same some basic questions and shifts and teams management
Interview Preparation Tips
Associate Interview Questions asked at other Companies
Selected
I applied via Naukri.com and was interviewed before Mar 2022. There were 3 interview rounds.
(2 Questions)
- Q1. Deep about process knowledge
- Q2. What is accounts payable, whats the universal purpose
- Ans.
Accounts payable is the amount owed by a company to its suppliers for goods or services received.
Accounts payable is a liability account that tracks the amount a company owes to its suppliers.
The universal purpose of accounts payable is to keep track of the money owed to suppliers and ensure timely payment.
Examples of accounts payable include invoices for raw materials, utilities, and services like legal or accounting.
...
(2 Questions)
- Q1. Universal ap journal entries
- Q2. What is GR / IR reconciliation
- Ans.
GR/IR reconciliation is the process of matching goods received with invoices received and resolving any discrepancies.
GR stands for Goods Received and IR stands for Invoice Received
The reconciliation process involves comparing the quantity and price of goods received with the corresponding invoice
Any discrepancies are identified and resolved through communication with the vendor or supplier
The ultimate goal is to ensur...
Interview Preparation Tips
Analyst Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in May 2021. There were 3 interview rounds.
Interview Questionnaire
8 Questions
- Q1. Teradata Architecture
- Q2. Data protection techniques
- Ans.
Data protection techniques are essential for safeguarding sensitive information from unauthorized access or theft.
Encryption of data at rest and in transit
Access controls and authentication mechanisms
Regular backups and disaster recovery plans
Data masking and anonymization
Monitoring and auditing of database activity
- Q3. Difference between Role and Profile
- Q4. What is hop Amp CPU and how it is caused
- Ans.
Hop Amp CPU is a performance issue caused by excessive CPU usage in a database server.
Hop Amp CPU occurs when a database server is overloaded with too many queries or transactions.
It can also be caused by poorly optimized queries or inefficient database design.
Hop Amp CPU can lead to slow response times, system crashes, and other performance issues.
To prevent Hop Amp CPU, database administrators should monitor server p...
- Q5. Various methods to solve spool space issue
- Ans.
Various methods to solve spool space issue
Optimize queries to reduce spool space usage
Increase spool space allocation for the user
Use temporary tables to reduce spool space usage
Use compression techniques to reduce spool space usage
Avoid Cartesian joins to reduce spool space usage
- Q6. Teradata Utilities: Mainly Multipload and Fastload
- Q7. Grant and Revoke command
- Q8. Data dictionary tables and where the history Data is stored
- Ans.
Data dictionary tables store metadata about database objects. History data is stored in audit tables or separate history tables.
Data dictionary tables contain information about database objects such as tables, columns, indexes, and constraints.
History data can be stored in audit tables that track changes to data over time.
Separate history tables can also be used to store historical data.
Examples of data dictionary tabl...
Interview Preparation Tips
Skills evaluated in this interview
Senior Database Administrator Interview Questions asked at other Companies
Teradata interview questions for popular designations
Interview Questionnaire
4 Questions
- Q1. Regards previous experience?
- Q2. Any regrets from your previous organisation ?
- Q3. What was the role in previous organisation
- Q4. How you used to train the new joinees
Get interview-ready with Top Teradata Interview Questions
Interview Questionnaire
6 Questions
- Q1. 2 pros and 2 cons in you?
- Q2. What the best quality in you that has helped you prosper?
- Q3. Difference between Accounting and Finance?
- Q4. Difference between invoicing and billing?
- Q5. How do you handle/resolve escalation?
- Q6. How do you prosper in pressurized situation?
Interview Preparation Tips
2) Clean yourself, wear a mild perfume/deo
3) Voice needs to be moderate when you speak(not too low , not too loud)
4) Wear a faint smile (appear glad to be interviewed)
5) A faint humor can help clear the air
6) Try not to answer too prolonged
7) Give a second or two gap after the question and then start with your answer
8) Never cut the interviewer in whichever case allow him to complete his question/statement (Doesnt work vice versa)
9) When asked 'Do you have any questions on your profile', say you do and ask! (Or it looks like you are just looking to be hired and don't really care about the profile you are proposed)
10) If your interviewer is a lady, allow her to proceed a handshake do not initiate, however, if it's a male interviewer, you may.
Jobs at Teradata
I applied via Naukri.com and was interviewed in May 2021. There were 5 interview rounds.
Interview Questionnaire
1 Question
- Q1. Informatica basic to advanced
Interview Preparation Tips
1st was for technical. Below are some points
1. Basic to advanced Informatica.(scenario plus theory)
2.Basic to intermediate SQL all scenarios based.
3.Unix basic scenarios.
4.Resume questions on project tools,
roles and responsibilities
2nd round was Managerial round.
Below are some points.
1.Introduction
2.project roles and responsibilities
3.how to manage conflict
3r round was of HR it covered introduction and salary discussion
Informatica Developer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed before Oct 2021. There were 3 interview rounds.
(3 Questions)
- Q1. Java, Spring, Collections related questions
- Q2. REST APIs code flow and Spring annotations
- Q3. Asked based Ds and algo questions
(3 Questions)
- Q1. Transactions, challenges faced in Job
- Q2. In what position you want to be in 5 years
- Q3. Discussed job role and responsibilities
Interview Preparation Tips
Associate Software Engineer Interview Questions asked at other Companies
I applied via LinkedIn and was interviewed in Apr 2021. There were 4 interview rounds.
Interview Questionnaire
2 Questions
- Q1. 1. Gave some python programming questions.
- Q2. 2. Scenario based questions on testing and sql.
Interview Preparation Tips
Test Engineer Interview Questions asked at other Companies
I applied via Naukri.com and was interviewed in Aug 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Basic Questions on GCP and Advanced questions on Linux
Interview Preparation Tips
Teradata Interview FAQs
The duration of Teradata interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Teradata Interviews By Designations
- Teradata Software Engineer Interview Questions
- Teradata Associate Software Engineer Interview Questions
- Teradata Cloud Engineer 1 Interview Questions
- Teradata Senior Devops Engineer Interview Questions
- Teradata Software Developer Interview Questions
- Teradata Test Engineer Interview Questions
- Teradata Accountant Interview Questions
- Teradata Accounts Payable Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
- Software Engineer Interview Questions
- Senior Executive Interview Questions
- Analyst Interview Questions
- Design Engineer Interview Questions
- Software Developer Interview Questions
- Consultant Interview Questions
- Associate Software Engineer Interview Questions
- Java Developer Interview Questions
- Show more
Teradata Interview Process
based on 30 interviews
Interview experience
Interview Questions from Similar Companies
Fast track your campus placements
Teradata Reviews and Ratings
based on 381 reviews
Rating in categories
6-8 Yrs
Not Disclosed
6-8 Yrs
Not Disclosed
3-5 Yrs
Not Disclosed
|
Software Engineer
260
salaries
|  ₹7.8 L/yr - ₹23 L/yr |
|
Technical Consultant
191
salaries
| ₹5.2 L/yr - ₹19 L/yr |
|
Senior Technical Associate
158
salaries
| ₹6.9 L/yr - ₹14 L/yr |
|
Data Engineer
158
salaries
| ₹5.7 L/yr - ₹23 L/yr |
|
Senior Software Engineer
126
salaries
| ₹12.3 L/yr - ₹36 L/yr |
IBM
SAP
Oracle
Microsoft Corporation
- Home >
- Interviews >
- Teradata Interview Questions
