Informatica Interview Questions and Answers

Round: Test
Experience: Informatica recently visited our campus to hire full time employees and interns. About 70 students appeared out of which 4 were given internship and two were given both internship and full time job offer. I was lucky to get an internship. Here is my interview experience.
MCQs on Data structures, C/C++, DBMS, OS and networking

Round: Test
Experience: 20 questions of easy level. Time constraint exists. No one was able to solve all 20 questions. We had to write codes, algos, point out mistakes in given code etc
Total Questions: 20

Round: Technical Interview
Experience: 1. Discussion on ethical hacking2. Discussion on my projects at Microsoft IDC(I was an intern there)3. Print all nodes at same vertical in a tree.(very tough)4. Remove all occurrences of a particular value from a linked list5. Find all root to leaf paths with a given sum

Round: Technical Interview
Experience: 1. Implement insertion sort using stacks. Temporary memory, input, ouput etc, everything is in stacks.2. Implement 2-D array in heap segment. This has to be used for page faults and related OS tasks. What modifications will you make?3. Polymorphism, run time polymorphism and implementational details4. Find a magic index ‘i’ in an array in o(1) time, such that a[i] = i. The array is already sorted

Round: Technical Interview
Experience: 1. Flatten a multi level linked list2. Find Next greater element in an array.3. Check whether an array of strings can form a cycle, i.e., last element of one node can occur anywhere in the first of other

Round: HR Interview
Experience: Basic HR questions, relocation questions, family background etc.

College Name: NA

Round: Technical Interview
Experience: observed that most of my project work is in OS and Compilers. started asking about synchronization and advanced topics like transactional memory.

Tips: you MUST be able to explain your projects well. Don't be aggressive or arrogant in interview while being confident.yo

General Tips: Dont say you hv to be in delhi or some particular place.itwill reduce ur chances of getting selected.
Skills: Compilers, Operating Systems

Round: Test
Experience: 55 questions in 60 minutes of which 45 were technical and 10 were aptitude questions and there was no negative marking. The technical questions covered RDBMS, UNIX, C, C++, Java, Operating systems, Data structures and Algorithms. The questions were simple and the basics of each of the mentioned subjects were mainly asked.
Duration: 60 minutes
Total Questions: 55

Round: Test
Experience: Again mainly questions on the subjects covered in round 1 but bit more in deep questions required short but detailed answers.
Tips: Learn to write pretty good Unix Scripts and Know the Basics of Operating System & OOP
Duration: 40 minutes
Total Questions: 10

Round: Technical Interview
Experience: Questions mainly on UNIX & RDBMS. Interviewer will ask you to write UNIX scripts and SQL/JAVA-SQL queries/programs for some use cases.
Tips: Know how JOINS, INTERSECTION, UNION & Aggregation works in SQL.

Round: Technical Interview
Experience: Questions on Programming, Data Structure and algorithms.
You will be asked to write pseudo-program for some of the use cases.
Tips: Choose your programming language cleverly. ;)

Round: Other Interview
Experience: Round 5 is an interview with Technical Manager.
Questions are asked based on the content of your resume like projects, hobbies and traits.
Few puzzle questions are asked which usually can be answered with logical analysis.
Tips: Be prepared for questions on the answer you give for the previous question(s).

Round: HR Interview
Experience: Again question will be asked on the basis of your resume. Questions may also asked on your previous interview experience if you have any.
Tips: Clear your doubts before leaving the room.

General Tips: Be confident, be straight forward, do not try to bluff with answers and try to be creative with answers. Prepare well both technical and aptitude.
Skills: Algorithms And Data Structures, Operating Systems, Unix, SQL, Java Programming, Object-Oriented Programming (OOP), C Programming
College Name: JSS Mahavidyapeetha Sri Jayachamarajendra College Of Engineering, Mysore
Motivation: Work Environment of Informatica.

Round: Test
Experience: The written test was pretty much simple. It was in 2 parts:1. MCQs and 2. Coding. In MCQs, there were questions on only Data Structures and Algorithms. In the coding part, there were 15 questions of coding and debugging.
Duration: 75 minutes

Round: Technical Interview
Experience: It was conducted in 2 rounds. Students selected in round 1 were interviewed for the second round.Questions included:1. Design a File System based on some corresponding database where from you can query (using SQL) and get the same output as you would have got from the data base and then transform the result in XML. He asked me to present an abstract design not very detailed. I drew block diagrams and explained it to him.2. Write a C++ program to shuffle a given record stored in a file so that the resulting output is random. Optimize it so that each time the program produces a different output.3. Suggest a database table structure having 3 entities:a. Flight typeb. Flight No.c. PilotsThere could be millions of flight type. Each type may contain several flight numbers. A pilot can fly several types of flights. There will be queries like return all the flight nos. flown by a given pilot or no. of pilots flying a given type of flight.
Tips: Question in the technical interviews were mainly design and development based rather than subject specific. The interviewer was mainly looking for your thought process, how you comprehend the problem at hand and your reasoning.

Round: HR Interview
Experience: The HR interviewer asked me some typical HR questions:Favorite subjects? Hobbies?Why do you want to join our company.Why do you think you are creative? (Because i said earlier i was creative)Why do you want to go for development?What is your biggest regret in life?Other than this which company did you sit for?Why weren't you selected in that company?(Answer this very carefully!)Then they asked me to ask them any questions to them. I asked them about the work culture, what kind of projectsWill I b working on, how are the hierarchies in the company, the best product of the company etc.

General Tips: Since it is a Data Integration company, a sound concept of Data warehouse is advised though i wasn't asked any question on that. Java and JDBC were also asked for my friends. f  you have done some application or webproject, that would be of great help. All the best.
College Name: NIT WARANGAL