I had already attended few interviews at top india's IT companies but I liked the way how infosys organised the interview.first and formost I felt it like it was a walk in drive,atleast 250+ were present in an lecture hall at 11am.Infy spoc was giving instructions to the candidates for proper application filling it took a while and the spoc was sending 10 candidates at a time to a different building for interview.when I entered the building no.4 I saw another 60 ppl waiting.Now I confirmed to myself this must be a walk in.
After waiting for an hour my name was called.The interviewer introduced himself and we had a firm handshake and took me to first floor.
Now coming to the questions part
As usual tell about your self which I spoke for a minute or two and then asked about my project which I explained for 5 minutes atleast then few technical pl/sql basic questions like
Diff between proc and function,diff between primary n unique key
What is a distinct clause
What is the diff bet proc n package
What are joins and then he gave me a paper and asked me to write a simple query for the scenario to fetch a name and salary from 2 diff table for the emp name'xyz' which I wrote in no time.
Then he asked about polymorphism which I said I dont know.He then asked me how do we query records dynamically apparently I did not understand and told something like using pragma then the interviewer himself gave the answer it is using EXEcute immediate statement we query dynamically
Then he asked me about SDLC
Which I explained for 2-3 minutes then he asked what methodology of SDLC u use in your project I told waterfall model.he then asked me to explain that which I did for another 2-3 minutes.then he asked few leadership skills like have u lead a team etc and then asked me do u have any questions for me.i just asked how did I perform in the interview for that he he is satisfied and asked me to wait outside.
Then after waiting for 40 min another person took me in for a validation round he again asked me my project roles n resp and asked few questions on the project tool I mentioned in my resume after that few stress management quest were asked like y do u want to leave the previous company for that I said I am looking for more career opportunities and a job switch is a must for career growth at some point of time.he then posted another question if you don't find good opportunities at infy u will leave infy also.i smiled and said its a tough question and told the definitely infy is a better company when compared to my company and strongly believe that there will be much more opportunities here. That's it he told me to wait out side after 30 min another HR called me in his cabin and we negotiated the ctc.
Totally very good experience.