Informatica Interview Experience

#Interview_Exp_1

#Round 1 (45 Minutes):
There are 30 MCQs (no negative marking) was asked and focus on following topics :
Data Structures
Operating System
Database Management System

#Round 2 (90 Minutes): ? There are 4 Questions asked to code on Cocube.com

#Round 3 (60 Minutes) Technical interview :
1. Discussion about Project
2. Oops Concept in details (Tips: Explain with Examples)
3. What is virtual function , where it is use and how virtual function is implemented .
4. Implement Vector class in C++ with exception handling .

#Round 4 (60 Minutes) Technical interview :
1. Add two large number represented as strings
2. AVL Tree , Height of Tree , Max Heap , Minheap , Types of Tree
3. B Tree (I told i don’t know), Sql Query
4. He asked me about my electives paper (Tips : Don’t tell those elective papers which you don’t
know about otherwise they will ask questions from that paper)
5. Asked about server side scripting language , i worked on PHP.
6. What do you think about Informatica ?
7. Any Questions about company , i asked 4 or 5 questions about company culture , timing etc.

#Round 5 (20 Minutes) HR interview :
1. How was your previous interview ?
2. How was your online coding round and asked about difficulties level of questions ? 3. What did you learn from previous rounds of interview ?
4. Tell me about your family.
5. Do you drink ? I said NO . so he asked me why ?
6. Why should i hire you ?
7. Tell me something about yourself which makes you unique.
8. Why did you not get a job after BCA ?

#Round 6 (30 Minutes) Technical interview :
1. Difference between Process and Thread.
2. What is Deadlock and conditions for deadlock ?
3. Difference between Hold and Wait and Circular wait.
4. Producer and Consumer Problem.

#Interview_Exp_2

#WRITTEN TEST

#Technical : 75 Minutes

Details of types of questions asked in each of the sections:

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.

#PERSONAL INTERVIEW (TECHNICAL)

It was conducted in 2 rounds. Students selected in round 1 were interviewed for the second round.

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 type
b. FLight No.
c. Pilots
There 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.

#PERSONAL INTERVIEW (HR)

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?
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 projects will I be working on, the best product of the company etc.

#Tips_To_Clear_Interview

1. Be cool and calm while solving coding questions and start with your approach of solving problem and after that write clean code .
2. Always try to engage interviewers with your answer.
3. Whenever you get chance to ask questions then be prepare for that.
4. Always be honest while answering HR questions.

5. Question in the technical interviews were mainly design and deveopment based rather than subject specific. The interviewer was mainly looking for your thought process, how you comprehend the problem at hand and your reasoning.

6. 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 from my friends. I you have done some application or web project, that would be of great help

All the Best Whoever got call for the drive.

All the Best.

Team,
Helping Hands 7

Facebook Link - https://www.facebook.com/groups/helpinghands7/

You Tube link -  https://www.youtube.com/channel/UCq7l_bpEJglC7F0sqlZaYKg/featured?view_as=subscriber

Helping Hands Facebook Page - https://www.facebook.com/7Helping/

In case of  any query feel free to write us @helpinghands768@gmail.com