Open In App

Informatica Interview Experience | Set 5 (On-Campus)

Improve
Improve
Like Article
Like
Save
Share
Report

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.

1.) A boolean matrix 

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.

4)Number of islands

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 :

  1. Tell me about yourself.
  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.
  7. reverse a linked list.
  8. 1 Puzzle question.

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

  1. Tell me about yourself.
  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

  1. Tell me something about your family?
  2. What are my strong point?
  3. What are my week point?
  4. Ask me about Quick heal (mention in my resume)
  5. what are my long and short term goal?

some other basic question.

Note all the above round are elimination round at last 5 of them get selected and i am one of them


Last Updated : 09 Sep, 2023
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads