Interview Experience with Deloitte USI Mumbai for Full Stack Developer

Deloitte USI Mumbai for Full Stack Developer

I got a call from the recruitment firm a week before my interview at Deloitte Mumbai(IN) on 29th Feb 2020. The very next day I got an email stating that my profile has been shortlisted and I will receive the test link in the next 24 hours, which I received the same evening.
The test was very easy which comprises of 40MCQ in 40mins and 2 basic Java coding question.
MCQ: core java, servlet, REST/SOAP,  JSP, request dispatcher.

After clearing the test, I got the interview to call a day before. I have to travel to the Deloitte office for a f2f interview.

Interview Question/Answers:

• First Technical Round

1. What is polymorphism?
   Polymorphism allows you to define one interface and have multiple implementations. (Link)
2. What is a static keyword? Static methods are the methods in Java that can be called without creating an object of the class. They are referenced by the class name itself or reference to the object of that class.
3. Output of following code:class A{ public static void display(){System.out.println("ABC");}}
   class B extends A{public static void display(){System.out.println("XYZ");}}
   class C{public static void main(String[] args) {A obj=new B(); obj.display(); A.display(); B.display();}}
   
   Output: ABC ABC XYZ
4. Runtime and Compile Polymorphism? 
5. Write a program to print Triangle Input: {1,2,3,4,5,6,7,8,9,10}Output:
               1
              2 3
             4 5 6
            7 8 9 10
6. Basic SQL Query:
   
   Table – EmployeeDetails

   EmpId	FullName	ManagerId	DateOfJoining
   121	John Snow	321	01/31/2014
   321	Walter White	986	01/30/2015
   421	Kuldeep Rana	876	27/11/2016

   Table – EmployeeSalary
   

   EmpId	Project	Salary
   121	P1	8000
   321	P2	1000
   421	P1	12000

1. Write a SQL query to fetch employee names having a salary greater than or equal to 5000 and less than or equal 10000.
   SELECT FullName FROM EmployeeDetails WHERE EmpId IN (SELECT EmpId FROM EmpolyeeSalary WHERE Salary BETWEEN 5000 AND 10000);
2. Write a SQL query to fetch project-wise count of employees sorted by project’s count in descending order.
   SELECT Project, count(EmpId) EmpProjectCount FROM EmployeeSalary GROUP BY Project ORDER BY EmpProjectCount DESC;
7. Few More Questioned Based on Core Java
   
   After 1 hour I got to know I have cleared the first round.

• Second Technical Round

1. It was totally based on your resume and what you have written on it, projects and recent work experience.
2. Java Question: DeadLocks, Generic, Lamda Expression, Collections, HashMap, HashSet
3. SQL questioned 

• Managerial Round