Candidatei-me por meio de uma agência de recrutamento. O processo levou 3 dias. Fui entrevistado pela FIS (Chennai) em jun. de 2016
Entrevista
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
Perguntas de entrevista [1]
Pergunta 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.