Informatica Interview Experience For Apprenticeship + FTE (On-Campus) 2024

Informatica visited our LPU campus to hire Trainees/ Apprentices. About 360 students appeared for the drive, out of which 2 got selected from campus. Here’s my interview experience.

It was an online MCQ-based test containing 30 questions to be solved in 30 minutes. It was focused on C, Data Structures, Operating Systems, DBMS (SQL queries), and Computer Networks. Questions included output-based answers, finding out the correct SQL queries, match the following. The test was conducted in the last week of March on the CoCubes platform.

Out of 350 students, only 35 were shortlisted for the next round.

The first technical interview round was scheduled for the first week of April and was conducted over a Zoom call. This interview was scheduled with one of the Lead Software Engineer of Informatica. The interview involved:

1. Introduction
2. Discussion on Projects
3. Questions based on Java and OOPs.
4. Two Coding questions (Basic-Intermediate level)
5. Writing test cases for one of the projects.

In this round, I was asked in detail about Java and OOP concepts such as Encapsulation, Abstraction, Polymorphism and its types, Inheritance, Over-riding vs Overloading, Abstract classes, Interfaces, Constructors, static methods, main class, JDK, JVM, JRE, lambda expression, Singleton class, Keywords such as static, final, public, private, protected, super.
There were questions based on Design Patterns and threading concepts. Since in college, my minor course was Informatica, I was asked about Data Integration tools, ETL, MDM, Filter vs Router etc.

Apart from this, I was asked to write basic coding questions either in Java or Python. One question was calculating the factorial of a number and the other was based on the maximum and next maximum sum.
I was also asked to explain any one of the projects mentioned in my Resume and write some test cases.
After the interview, I asked for my feedback and the interviewer provided me with the same.
The interviewer was impressed with my interview and congratulated me for moving to the next round.

I got the email for the second interview after 2 hours of the first interview round. This interview was with another Lead Software Engineer at Informatica. This involved:

1. Two Coding questions (Intermediate level)
2. One System Design Question
3. Operating System Questions
4. Project Discussion

In this round, I was asked to write code to create a Binary Search Tree class and node insert method along with an example. And then I was asked to explain the approach for checking if a Linked List is a palindrome or not.

After this, we moved towards Low-Level System design Questions based on the Informatica Developer tool internal work. After this, I was asked about Operating system concepts such as Deadlock, Mutex, Virtual Memory, Multi-Threading, and Design Patterns.

After the interview, I asked for my feedback and the interviewer provided me with the same.

The results were declared after 2 weeks, and out of 35 only 7 students reached the next round. This time, the company visited the Campus for a final face-to-face interview.

For this round, I was interviewed by the Director of Product Development at Informatica. It involved:

1. Introduction
2. Machine Learning Concepts
3. Project Discussion
4. Coding Questions
5. Puzzles
6. Behavioural Questions and Future Prospects
7. Previous Internship Experiences
8. College Experiences

After this round, I was shortly called for the last round.

This round was more like a discussion-based round, and the HR was open to discussion for any type of questions and doubts. This involved:

1. Introduction
2. Projects Discussion
3. Previous Internship Experiences and Roles
4. Current market situation.
5. Discussion on Interview Experience
6. Background based questions
7. Behavioural questions
8. Relocation based questions
9. The role offered and work expectations

After this, I was selected for their Apprenticeship-based role. It’s like a dream come true to be placed at a Product based MNC.