Upload Button Icon Add office photos

Teradata

Compare button icon Compare button icon Compare

Filter interviews by

Teradata Informatica Developer Interview Questions and Answers

Updated 25 Nov 2021

Teradata Informatica Developer Interview Experiences

1 interview found

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

Interview preparation tips for other job seekers - The interview has 3 rounds.
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

Interview questions from similar companies

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 - 120minutes
Round difficulty - Easy

It was an online MCQ's + coding round consisting of 20 MCQ’s and 1 coding problem.

  • Q1. Check whether there exists a loop in the linked list.
  • Ans. 

    Check for a loop in a linked list by using two pointers moving at different speeds.

    • Use two pointers, one moving at double the speed of the other.

    • If there is a loop, the two pointers will eventually meet at the same node.

    • Example: 1 -> 2 -> 3 -> 4 -> 5 -> 2 (loop back to 2), the two pointers will meet at node 2.

  • Answered by AI
Round 2 - Face to Face 

(1 Question)

Round duration - 50 minutes
Round difficulty - Easy

The interview started at 8:30 pm in cc of Delhi Technological University itself and it was quite late. There was only a single interviewer and he asked me one coding question related to overflow of integers.

  • Q1. How can you check for integer overflow when multiplying two integers and ensure the result is stored correctly within an integer type?
  • Ans. 

    To check for integer overflow when multiplying two integers, use the properties of integer overflow and check if the result is within the valid range of the integer type.

    • Check if the signs of the two integers are the same to avoid overflow in case of multiplication.

    • Use the properties of integer overflow to detect if the result exceeds the maximum or minimum value of the integer type.

    • Consider using a larger data type or...

  • Answered by AI
Round 3 - HR 

Round duration - 15 minutes
Round difficulty - Easy

It was quite late . There was only one interviewer and I was asked about my family , education and future plannings and few questions related joining locations and documents etc.

Interview Preparation Tips

Professional and academic backgroundI completed Information Technology from Delhi Technological University. I applied for the job as SDE - 1 in PuneEligibility criteria6Amdocs interview preparation:Topics to prepare for the interview - I did a lot of practice of data structures and algorithms. I covered main topics such as arrays, strings, trees, linked lists, hashmaps, and recursion. Algorithms such as sorting, searching, BFS, DFS, and greedy were also covered by me.Time required to prepare for the interview - 3 monthsInterview preparation tips for other job seekers

Focus on data structures and algorithms part more. Tell the interviewer , starting from the brute force approach to the most optimal solution as this will give a good impression to the interviewer.

Application resume tips for other job seekers

To be honest, the problem-solving ability is the only thing that most companies care about. So you can manipulate your resume according to that. Mention your competitive programming handles in your resume and also other coding ranks or achievements which you have achieved.

Final outcome of the interviewSelected

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Apr 2020. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. I have got questions about vsam files and about SQL queries.
  • Q2. What is my previous work and project roles and responsibilities.?

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare with basics clear with your project,your work,and your roles and responsibilities and be good to make them understand what you willing to answer.

I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Questions about Comptel Eventlink tool, Perl scripting, unix shell scripting and a bit a SQL

Interview Preparation Tips

Interview preparation tips for other job seekers - Answer in details for whatever you are asked. Also be honest if you don't know something rather than guessing. Nobody is expected to know EVERYTHING.

Software Engineer Interview Questions & Answers

Chetu user image Nirban Chatterjee

posted on 11 Oct 2020

I applied via Naukri.com and was interviewed before Oct 2019. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Normal php questions like overriding,overloading,traits,interface,abstarct class nothing else.. It was online but in 2016.
  • Q2. Go though those topic as they are very important and asked in most companies.

Interview Preparation Tips

Interview preparation tips for other job seekers - Read those topics and try to understand with example and doing on your own.Before entering Chetu prepare yourself that you may get fire anytime.Because hiring and firing is lot in Chetu but in terms of salary it is good.

Software Engineer Interview Questions & Answers

Adobe user image Devendra Bendkhale

posted on 4 Dec 2015

Interview Questionnaire 

8 Questions

  • Q1. WRITE A GENERIC SWAP FUNCTION
  • Ans. 

    A generic swap function swaps two values of any data type.

    • The function should take two parameters of any data type.

    • Use a temporary variable to store the value of one parameter.

    • Assign the value of the second parameter to the first parameter.

    • Assign the value of the temporary variable to the second parameter.

  • Answered by AI
  • Q2. SEARCH AN ELEMENT IN ROTATED SORTED LINKLIST .
  • Ans. 

    Search for an element in a rotated sorted linked list.

    • Find the pivot point where the list is rotated.

    • Divide the list into two sublists based on the pivot point.

    • Perform binary search on the appropriate sublist.

    • Handle edge cases such as empty list and list with only one element.

  • Answered by AI
  • Q3. SEARCH AN ELEMENT IN ROTATED SORTED ARRAY. WRITED A CODE FOR IT
  • Ans. 

    Search an element in a rotated sorted array

    • Find the pivot point where the array is rotated

    • Divide the array into two sub-arrays based on pivot point

    • Perform binary search on the appropriate sub-array

    • Repeat until element is found or sub-array size is 1

  • Answered by AI
  • Q4. In an Array of size 95 contain numbers in range 1 to 100. each number is at max once in the array. find the 5 missing numbers in array between 1-100
  • Ans. 

    Find 5 missing numbers in an array of size 95 containing numbers in range 1 to 100.

    • Create a boolean array of size 100 and mark the present numbers

    • Iterate through the boolean array and find the missing numbers

    • Alternatively, use a HashSet to store the present numbers and find the missing ones

  • Answered by AI
  • Q5. Given sudoku as id array of size . in a given empty cell find the possible numbers that could be possible. Asked me to write code for it
  • Ans. 

    Given a Sudoku board, find possible numbers for an empty cell.

    • Iterate through empty cells and check possible numbers using row, column, and box constraints.

    • Use a set to keep track of possible numbers for each empty cell.

    • Return the set of possible numbers for the given empty cell.

  • Answered by AI
  • Q6. Given 4 unsigned integers find their integer average (eg. (2,2,2,3) => (2+2+2+3)/4 = 2) consider integer division ) without typecasting
  • Ans. 

    Find integer average of 4 unsigned integers without typecasting

    • Add all the integers and divide by 4

    • Use bit shifting to divide by 4

    • Handle overflow by using long long data type

    • Use unsigned int data type for input

  • Answered by AI
  • Q7. Write a code to identify wheter given processor is of 32 bit architecture or 64 bit architecture
  • Ans. 

    Code to identify 32 bit or 64 bit architecture of a processor

    • Check if the operating system is 32 bit or 64 bit

    • If OS is 32 bit, processor is 32 bit

    • If OS is 64 bit, check if processor supports 64 bit architecture

    • Use CPUID instruction to check if processor supports 64 bit architecture

  • Answered by AI
  • Q8. Convert a binary number into base 64 integer
  • Ans. 

    Convert binary number to base 64 integer

    • Divide the binary number into groups of 6 bits

    • Convert each group of 6 bits to decimal

    • Map the decimal value to the corresponding base 64 character

    • Concatenate the base 64 characters to form the final integer

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: SIMPLE CODING QUESTIONS SPEED MATTERS.
Duration: 60 minutes
Total Questions: 3

Skills: Analytics And Coding
College Name: IIT Guwahati

Skills evaluated in this interview

Interview Questionnaire 

6 Questions

  • Q1. Solving puzzles(25 horses,ant and sweets,height of a building..) try as many as possible before appearing for interview
  • Q2. If experienced , then project details of previous companies a must prepare question
  • Q3. Writing test cases for random scenarios
  • Q4. Programming in whatsoever language you r comfortable with, basic coding problems of DS,Algos. eg. Zigzag tree traversal algo,random linked list copy
  • Q5. Some people asked me questions related to the work i will do if hired in the project
  • Q6. Be genuine in ur CV, and be prepared with everything you write there.

Interview Preparation Tips

College Name: Na

Teradata Interview FAQs

How to prepare for Teradata Informatica Developer 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 Informatica, Database Design, Teradata, Unix Shell Scripting and Consulting.

Tell us how to improve this page.

Interview Questions from Similar Companies

Oracle Interview Questions
3.7
 • 865 Interviews
Amdocs Interview Questions
3.7
 • 518 Interviews
Adobe Interview Questions
3.9
 • 235 Interviews
Salesforce Interview Questions
4.0
 • 230 Interviews
24/7 Customer Interview Questions
3.5
 • 176 Interviews
Chetu Interview Questions
3.3
 • 176 Interviews
AVASOFT Interview Questions
2.9
 • 166 Interviews
Dassault Systemes Interview Questions
4.0
 • 164 Interviews
Freshworks Interview Questions
3.5
 • 164 Interviews
View all
Teradata Informatica Developer Salary
based on 4 salaries
₹12.4 L/yr - ₹15 L/yr
85% more than the average Informatica Developer Salary in India
View more details

Teradata Informatica Developer Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

4.0

Salary

4.0

Job security

4.0

Company culture

4.0

Promotions

4.0

Work satisfaction

Explore 1 Review and Rating
Software Engineer
230 salaries
unlock blur

₹7 L/yr - ₹23 L/yr

Data Engineer
162 salaries
unlock blur

₹6.1 L/yr - ₹23 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