Deloitte Business Technology Analyst interview questions

3 rounds of Interview in Pune, technical, lead round, managerial round, and HR It was a one day process. After selection, there was also a communication test. Offer was given on same day. 1. Oops, Basic concepts, string and StringBuilder, value type and reference type, Inheritance, virtual override, Polymorphism. In depth knowledge of these 2. SQL concepts joins, indexers, views, temp tables, functions, and stored procs, Asked me some queries to write, or give an output of joins. 3. MVC routing, Action methods, Generic collections

Interviewer asked to me introduce myself . Then he asked questions related to projects on my Resume(not technical details but what i did in it). Why did you choose computer science ? What I know about Machine learning ? Then some questions on DBMS like normalisation, consistency in database. Lastly he asked whether i had questions for him