Informatica Interview Experience (On-campus)

• Difficulty Level : Expert
• Last Updated : 16 Mar, 2020

Round 1: (ONLINE MCQ – 30 QUESTIONS)

In the 1st round, there were a total of 30 questions were asked from OS, DBMS and Algorithms/DAA with an exact count of 10 each.

Questions are from Deadlocks, Banker Algorithm, B+ tree, Sorting techniques, Scheduling & Paging techniques.

Out of 350, only 42 were selected for Round-2.

Just brush up the basics of these 3 subjects!!!

Round 2: (ONLINE CODING ROUND – 4 QUESTIONS)

In the 2nd round, 4 questions were asked…

Languages available : C, C++, C#, JAVA (No Python)

1. Find the Maximum sum from the non-continuous subsets of the given array of positive & negative integers.
2. Find the Maximum sum from the Persubset of the given array where no two elements should be adjacent.

Eg: Input array is 1 2 3 4 5 6 and the maximum sum will be 12 (i.e., by taking subset = {6, 4, 2} as they’re non-adjacent).

3. Find the count of all contiguous sub-arrays of length>1 whose sum is divisible by the given number.

4. Print all combinations of the given string.

Out of 42, 14 made it to the next round.

Practice the Linked list, Array & Strings problems in Gfg!!!

Round 3: (TECHNICAL HR-1, 2, 3, 4, 5)

In this, I would like to compile the questions from all the technical rounds I faced because any question can be asked in any round…

Topics to be thorough at:

1. Nothing but the topics in the resume you’d provided them especially the Area(s) of Interest & Project(s) done.

Questions:

Try to say the interesting content(s) not in your resume!!!

2. What is your role in the Project and about the API of my project?

Here, only you can help yourself, and Gfg can’t do anything regarding this.

3. Least Common Ancestor of 2 given nodes with root node of the tree provided.

I solved it using Recursion!

4. OOPS concepts (My Area of Interest) with real time examples.

5. Given a sorted array and an integer(say ‘k’),   print the unique pairs whose sum is k.

Initially, I solved it with O(n^2) with 2 loops. Then as per his request, I solved it with O(n) complexity (by comparing the sum of 1st(pointer-1) & last(pointer-2) array element with k and moving pointer-1 and/or pointer-2 accordingly).

7. What is Normalisation?

8. Correlated Sub-Query problem.

Out of 14, 6 got selected for the final one.

Be patient till the end and don’t get frustrated by continuous rounds (take breaks) and be the best version of you on the Interview day.

Round 4: (FINAL HR)

Now, I could relax as there won’t be any technical queries any more.

Questions:

1. Why Informatica?
3. Where would you like to see you after 1 year?
4. Family Background.
5. Salary discussion.

Finally, 4 got selected for Full time+1 year Intern.

Don’t get overwhelmed until you crack the final one!!!

My Personal Notes arrow_drop_up