Informatica Interview Experience | Set 5 (On-Campus)

• Difficulty Level : Medium
• Last Updated : 15 May, 2018

Round 1:(45 minutes)

There are 30 MCQs (no negative marking) was asked and focus on following topics (cocubes platform):
Data Structures and Algorithms
Operating System
Database Management System

Approx 60 students cleared 1st round .

Round 2:(90 minutes)

There are 4 coding question to be solved in 90 minutes cocubes platform.

Given a boolean matrix mat[M][N] of size M X N, modify it such that if a matrix cell mat[i][j] is 1 (or true) then make all the cells of ith row and jth column as 1.

2). Given a BST find Ceiling value of given key

``````                     1
6     12
2   4 11    14
``````

key = 8 return 11
key = 1 return 2
key = 16 return Null

3.)Palindrome problem: input a integer n. We need to check that if n represent in binary, octal, hexadecimal form palindrome or not.

30 student get shortlist i am one of them. I am able to solve 3 problem.

Round 3 (45 Minutes) Technical interview :

Interviewer ask me very strange question.

He told me that i gave you an year like 2018 what information you can gave to me, it sound strange then i ask him can you give me one example he told for example we can tell that year is leap or not

Another question was if i gave you two dates like 14 may 1997 and 23 march 2015 can you tell me number of days between them, later on he told me to give an approach to tell how many seconds are there between two dates.

He ask me some puzzles and some question from resume.

Round 4 (60 Minutes) Technical interview :

2. sql query given two table how you join them.
3. different type of join.
4. what is stack, queue different between them and real life application of stack and queue.
5. given two number add them without + operator.
6. given two number find max of them without any loop or condition.
8. 1 Puzzle question.

Round 5 (70 Minutes) Technical interview + situation based:

2. what is odbc, jdbc some java question.
3. what are compiler and interpreter which one is better and why.
4. Normalization  in detail.
5. what is sql, pl/sql. (He ask me what version of sql you are using i am no able to ans this one)
6. process is not killed by using kill command what can be the reason explain?
7. your data base is working perfectly yesterday but now it not working what can be the possible case?
8. suppose you make a bug in a code and the developer refuse to fix it what you can do?
9. our company server are able to work only for 4 hours how you make it to work for 24 hours in less cost.

Round 6 (15 Minutes) HR