I applied through a staffing agency. The process took 3 days. I interviewed at FIS (Chennai) in Jun 2016
Interview
I got call from Zenith consultancy and I accepted the interview call.
On the day of interview, everyone for .Net technology were called out to specific room and asked to submit resume. Everyone were given different times in group of 3-4 per half hour.
I went through 3 rounds of interviews,
1-Interview: Technical round - Basic technical round of around 30 minutes.
2-Interview: Advance Technical and Managerial round of around 1 hour.
3-Casual Discussion with PM
Interview questions [1]
Question 1
Practical questions of SQL queries on Joins and Ranking
1. Top 3 salaried employees for each department in Emp and Department tables.
2. Primary key, Foreign key and other constrains.
3. Effect of cascade on delete statement.
4. Joins in update query.