I applied through college or university. The process took 2 days. I interviewed at Informatica (Hubli) in Jul 2014
Interview
It was a 2 day process.
First day was an online test consisting of aptitude,logical reasoning and fundamentals of computer science objective type questions.
Second day was the technical and HR interviews.
Technical and hr interviews lasted for an hour each.
There were totally 4 technical and one hr round.
Technical interviews were bit difficult.
overall 160+ candidates attended the interview process only 16 were shortlisted after round 1.
Finally 4 candidates were selected and offered internship and full-time.
Interview questions [1]
Question 1
Design a schema for cricket match.(unexpected one)
I applied through college or university. The process took 4 weeks. I interviewed at Informatica
Interview
The interview process consisted of four one-on-one interviews, with three taking place during the final round. All interviewers were friendly, fair, and professional, asking questions that test one's technical and social aptitude.
The process took 2 days. I interviewed at Informatica
Interview
There was an aptitude test which consisted of two sections:
1. Logical section
2. Basic CS
The logical section was simple, but the CS section was a little bit difficult. It mainly consisted questions related to OS, Networking, Java and algorithms.
After clearing this round we had 5 rounds of interview. 3 technical, 1 managerial and 1 HR.
The technical rounds mainly consisted of questions of OS(Unix scripting), DBMS(basic/complex queries), PL/SQL, Data warehousing, programs and puzzles.
The managerial round mainly consisted of questions related to HR and also puzzles.
Each round was an elimination round.
Interview questions [1]
Question 1
Read records from a .txt file and update the records in database using PL/SQL or Java