It took 1-2 weeks to receive a call from the recruitment team.

Interview rounds:

1. Phone screening with Recruiter. It was a casual call where the recruiter tried to get an overall idea of yourself and/or your job motives. The call lasted for 15-20 minutes or so.

2. Three telephone interviews back to back. It took another 2 weeks to receive a call. The company is not very prompt with the recruitment process and has very stagnating working strategies.

• The first round of telephone interview was with the team lead. The person sounded knowledgeable and very professional. This round of interview majorly focused on Big Data foundations and its ecosystem tools which the company is using currently. I was glad this interview went well.

• The second round of interview was with another team lead. A similar set of questions were asked, similar to the first round. Most of the questions were originated from my resume. This person was not at all professional, and I observed lots of ego, pride, frustration, and supreme authority during the interview. I was not at all happy with the way the interview was conducted. Towards the end of the interview, when he asked, "Do you have any questions for me?" I asked if there were any grey areas in my resume that needed any specific elaboration on the skill set. He replied with lots of arrogance that he is the one who's supposed to question me, not the other way around. I was really dumbstruck with his response. In the world of MNC corporations, this kind of behavior is not at all appreciated. It seems like this person has issues.

• The third round of interview was with the Director. I was glad that this interview went well. This call was least into technical knowledge but was rather behavioral-based. This person was very cool and laid back but very professional.

1. Check the "rownum partition by order by" clause in SQL.
2. Be confident with the work you mentioned in your resume.