Upload Button Icon Add office photos

Teradata

Compare button icon Compare button icon Compare

Filter interviews by

Teradata Junior Technical Associate Interview Questions and Answers

Updated 27 Aug 2023

Teradata Junior Technical Associate Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Aug 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

General aptitude test consisted of Basic Maths/Logical Reasoning/Basic English Grammar questions followed by two programs which you can solve either in C, Python or Java

Round 3 - One-on-one 

(1 Question)

  • Q1. Was asked a myriad of questions from my final year project to basic SQL queries, joins, etc
Round 4 - HR 

(1 Question)

  • Q1. Basic questions about family, how I would plan to travel to office after being recruited, etc.

Interview Preparation Tips

Interview preparation tips for other job seekers - Read as much as possible about the company, its new products and know atleast basic Teradata SQL/SQL queries

Interview questions from similar companies

I applied via Naukri.com and was interviewed in May 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Programming

Interview Preparation Tips

Interview preparation tips for other job seekers - Interviewer had less knowledge on the current technologies and was more stereo type.

I applied via Company Website and was interviewed in Nov 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Linked list, data structure
  • Q2. Map,

Interview Preparation Tips

Interview preparation tips for other job seekers - Learn data structure and analysis

I applied via Naukri.com and was interviewed in Jul 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Java core microservices

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview was very good
Interviewer was knowledgeable

I applied via Referral and was interviewed in Feb 2021. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Why can’t a columns with unique with a not null constraint be used as a primary key?
  • Ans. 

    A unique not null column can be used as a primary key, but not vice versa.

    • Primary key must be unique and not null, but not all unique not null columns need to be primary keys.

    • Primary key is used to identify each row uniquely, while unique not null column is used to ensure data integrity.

    • A table can have multiple unique not null columns, but only one primary key.

  • Answered by AI
  • Q2. Because null can’t be equated
  • Ans. 

    Null cannot be equated as it represents absence of a value.

    • Null is not equal to any value, including itself.

    • Attempting to equate null can result in unexpected behavior.

    • Null is often used to represent the absence of a value or unknown value.

  • Answered by AI
  • Q3. We have 2 procedures with the same names. One with 2 parameters.. second one with 3 parameters. The procedure with 3 parameters has a null also. What will be invoked when we call the procedure
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

There were 2 coding questions which are online and moderate

Round 2 - Communication 

(2 Questions)

  • Q1. ECE related queries
  • Q2. Oops concepts, Data strucutes
Round 3 - HR 

(2 Questions)

  • Q1. Tell about the company
  • Q2. Why should we hire you

I appeared for an interview in Jul 2019.

Interview Questionnaire 

4 Questions

  • Q1. 1. Java questions basee on interfaces, Exception Handling, inheritance, Steam API;
  • Q2. 2. SQL questions related to joins, sub-queries, nth highest salary;
  • Q3.  3. Basic algorithms questions based on Arrays/Linked List.
  • Q4. 4. Puzzles based on basic aptitudes test.

Interview Preparation Tips

Interview preparation tips for other job seekers - I was interviewed for Java Developer. I had 4 rounds (all technical rounds). Each rounds comprises questions related to Java/Puzzles/Algorithms and my experience of project.

Go through your resume. Things should be relevant and one should have clear understanding of basics.

I applied via Naukri.com and was interviewed in Mar 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. What is rotational shifts. What is web service flow. How will you check ports on Unix or Solaris machine.
  • Ans. 

    Rotational shifts refer to working in different shifts at different times. Web service flow is the sequence of steps involved in a web service request. Checking ports on Unix or Solaris machine involves using the netstat command.

    • Rotational shifts involve working in different shifts at different times, such as day shift, night shift, and swing shift.

    • Web service flow involves a sequence of steps, such as sending a reques...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Total pathetic experience. Have heard of negative reviews from a number of people, but didn't believed. Unfortunately had to share same pain with them. What job description is given to you, doesn't matters because you won't be asked for that. Your resume will get shortlisted and then it doesn't matter what u have covered up in your career path, because interview rounds will consist of questions out of your scope. Your resume doesn't needs to be shortlisted at first end if it doesn't suit thier needs. HR people, they are on another level. You share your resume to them, and they will never ever reply back to you. Not a single HR, but it seems everyone has same culture. You keep trying to connect them for support. But they will just keep finding smarter ways to avoid.

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Jun 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. For java based profile, questions related to collections, usage of comparator, Class loading are asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be strong in basics of computer science like data structure and algorithms. Have a detailed understanding of java basics

I appeared for an interview before Sep 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 50 minutes
Round difficulty - Medium

Yes consist of two code and questions MCQ of ds ,algo,Linz,shell,English and DBMS
Test happens with your webcam access.

  • Q1. 

    Nth Fibonacci Number Problem

    Calculate the Nth term in the Fibonacci sequence using the formula: F(n) = F(n-1) + F(n-2) where F(1) = F(2) = 1.

    Given a number N, determine the Nth Fibonacci number.

    Input...

  • Ans. 

    Calculate the Nth Fibonacci number using the given formula and constraints.

    • Implement a function to calculate the Nth Fibonacci number using the formula F(n) = F(n-1) + F(n-2) with base cases F(1) = F(2) = 1.

    • Use dynamic programming or recursion to efficiently compute the Fibonacci number for large N values.

    • Ensure the input N is within the constraints 1 <= N <= 10000.

    • Example: For N = 5, the output should be 5 as th

  • Answered by AI
Round 2 - Face to Face 

(2 Questions)

Round duration - 40 minutes
Round difficulty - Hard

Late night around at 8 pm 
Environmental is positive.
Interviewer made me feel positive

  • Q1. 

    Priority Queue Implementation

    Ninja is tasked with implementing a priority queue using the Heap data structure. Since Ninja is busy with tournament preparations, your help is requested to complete this ta...

  • Ans. 

    Implement a priority queue using Heap data structure with functions like push, pop, getMaxElement, and isEmpty.

    • Implement push() function to insert element into the priority queue.

    • Implement pop() function to delete the largest element from the queue.

    • Implement getMaxElement() function to return the largest element.

    • Implement isEmpty() function to check if the queue is empty.

  • Answered by AI
  • Q2. You have 3 bulbs outside a room and 3 switches inside the room. The challenge is to determine which switch controls which bulb, with the constraint that you can only enter the bulb room once.
Round 3 - HR 

Round duration - 10 Minutes
Round difficulty - Easy

Morning time
Positive environment
Nice interviewer

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Associate Software Engineer in GurgaonEligibility criteria6 cgpa ,no gapAmdocs interview preparation:Topics to prepare for the interview - Python, Data structure, DBMS, algorithm, IotTime required to prepare for the interview - 6 MonthsInterview preparation tips for other job seekers

Tip 1 : practice on subject in which you are strong enough and unbeatable
Tip 2 : Always go through previous interview experiences on internet
Tip 3 : follow continuety

Application resume tips for other job seekers

Tip 1 : mention only you strong topics ,don't include anything you don't know about 
Tip 2 : always make your resume one pager

Final outcome of the interviewSelected

Skills evaluated in this interview

Teradata Interview FAQs

How many rounds are there in Teradata Junior Technical Associate interview?
Teradata interview process usually has 4 rounds. The most common rounds in the Teradata interview process are Aptitude Test, One-on-one Round and HR.
How to prepare for Teradata Junior Technical Associate interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Teradata. The most common topics and skills that interviewers at Teradata expect are Artificial Intelligence, C++, Communication Skills, Data Management and Data Structures.

Tell us how to improve this page.

Teradata Junior Technical Associate Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Oracle Interview Questions
3.7
 • 866 Interviews
Amdocs Interview Questions
3.7
 • 519 Interviews
Adobe Interview Questions
3.9
 • 236 Interviews
Salesforce Interview Questions
4.0
 • 230 Interviews
24/7 Customer Interview Questions
3.5
 • 176 Interviews
Chetu Interview Questions
3.2
 • 176 Interviews
AVASOFT Interview Questions
2.9
 • 167 Interviews
Dassault Systemes Interview Questions
4.0
 • 165 Interviews
Freshworks Interview Questions
3.5
 • 165 Interviews
View all
Teradata Junior Technical Associate Salary
based on 25 salaries
₹3.9 L/yr - ₹5 L/yr
35% more than the average Junior Technical Associate Salary in India
View more details

Teradata Junior Technical Associate Reviews and Ratings

based on 6 reviews

3.9/5

Rating in categories

3.2

Skill development

3.9

Work-life balance

3.7

Salary

4.1

Job security

3.4

Company culture

3.5

Promotions

3.4

Work satisfaction

Explore 6 Reviews and Ratings
Software Engineer
230 salaries
unlock blur

₹7 L/yr - ₹23 L/yr

Data Engineer
164 salaries
unlock blur

₹5 L/yr - ₹21 L/yr

Senior Technical Associate
158 salaries
unlock blur

₹6.9 L/yr - ₹14 L/yr

Technical Consultant
143 salaries
unlock blur

₹6.5 L/yr - ₹19 L/yr

Senior Software Engineer
130 salaries
unlock blur

₹11.1 L/yr - ₹36 L/yr

Explore more salaries
Compare Teradata with

Oracle

3.7
Compare

Amdocs

3.7
Compare

Automatic Data Processing (ADP)

4.0
Compare

24/7 Customer

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview