I applied through a recruiter. The process took 3 weeks. I interviewed at Deloitte (New York, NY) in Sept 2013
Interview
I had about 3 telephone interviews & 1 in person ( 4 people interviewed me)
Telephone
- What are cursors, triggers
- Asked me to write a small algorihtm for printing few #'s div by 3.
- Few other questions about .Net/ sql server etc..
In Person
I met with 4 people 2 of them were technical.
- SQL Server ( this is where I think I screwed up)
What are indexes? Clustered and non clustered?
What are cursors?
What are diff bween Inner join & outer join?
Write a query between two tables to show Sum of amount based on a certain field indicator on one of the column. amt > 1 Mil $ ( I didn't have enough time to write the query and the next guy barged in. So they dinged me on this one).
.Net
- Framework?
- Execute reader vs exec non query
- execscalar?
- Clustering of IIS servers.
Few other basic .net questions.
Interview questions [1]
Question 1
SQL query wasn't that hard but just had to put some thought to it.
it a very long and lengthy process, which involves meeting multiple people at various levels. the consulting and customer centric behavior is what they look for. recruiter first, then manager, then senior manager and principal
The interview process was average big4 interview with general questions about yourself and experiences, which took about 30 - 40mins. Interviewer was professional and I had a neutral experience about the interview
L’entretien s’est déroulé dans un cadre professionnel et bienveillant. Les échanges étaient fluides et respectueux, avec un réel dialogue. Les recruteurs étaient à l’écoute et ont pris le temps de répondre à mes questions. Les informations sont bien partagé. Un retour m’a été donné après l’entretien, avec une explication claire des étapes suivantes.
Interview questions [1]
Question 1
Pourquoi vous êtes motivé pour changer l'Enterprise actuelle