I applied through a recruiter. The process took 3 weeks. I interviewed at Deloitte (New York, NY) in Sep 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.
I applied through other source. The process took 2 months. I interviewed at Deloitte (Singapur) in Jul 2012
Interview
Went through 3 rounds + 1 round of HR. All the rounds were telephonic as I was based out of another country and the position was based in Singapore. Overall, the questions were quite generic in terms of technology and process consulting as they company was just getting started with focussing on this emerging cloud technology
Interview questions [1]
Question 1
Questions were quite generic, not relevant to any specific technology but were more towards understanding my current experience as well as my point of view on the cloud computing as a technology