Deloitte Interview Questions, Process, and Tips

1 Hrs session with basic aptitude question.

Q1. Group by clause and example
Ans. 
Group by clause is used in SQL to group rows that have the same values into summary rows.
• Group by clause is used with aggregate functions like SUM, COUNT, AVG, etc.

• It is used to group rows based on one or more columns in a table.

• Example: SELECT department, COUNT(*) FROM employees GROUP BY department;
Answered by AI
Add your answer
Q2. DML statements and questions on that
Add your answer

Q1. Spring security
Add your answer
Q2. Solid design principles
Ans. 
Solid design principles are a set of best practices for designing software that is maintainable, scalable, and flexible.
• Single Responsibility Principle - each class should have only one responsibility

• Open/Closed Principle - classes should be open for extension but closed for modification

• Liskov Substitution Principle - objects of a superclass should be replaceable with objects of its subclasses without affecting the pro...read more
Answered by AI
Add your answer

Q1. How authentication and authorization works in java
Ans. 
Authentication verifies the identity of a user, while authorization determines what actions they are allowed to perform.
• Authentication is the process of verifying the identity of a user, typically through credentials like username and password.

• Authorization determines what actions a user is allowed to perform after they have been authenticated.

• Java provides various authentication mechanisms like Basic Authentication, D...read more
Answered by AI
Add your answer
Q2. Design patterns in java
Ans. 
Design patterns in Java are reusable solutions to common problems in software design.
• Design patterns help in creating flexible, maintainable, and scalable code.

• Examples of design patterns in Java include Singleton, Factory, Observer, and Strategy.

• Each design pattern has its own purpose and can be applied in different scenarios.

• Understanding design patterns is essential for Java developers to write efficient code.
Answered by AI
Add your answer

The online assessment consists of 67 questions divided into 4 sections with a sectional cutoff for each. The topics covered included Analytical Ability, Quantitatitive Ability, Verble Ability and CS fundamentals focusing on key areas like OS, DBMS, SQL, Cloud and Pseudocodes. It also consist two coding questions.

Q1. The technical segment focused on my resume and projects, with an emphasis on Data Structures, Algorithms, OOPS, DBMS and other courseworks.
Add your answer
Q2. Coding question include problem to reverse a string, while SQL questions involved crafting a query to perform a left join between two tables.
Add your answer
Q3. Verbal SQL tpoics - Explains joins, group by and aggregate functions.
Add your answer
Q4. Behavioral Questions: Assessing teamwork, communication and problem-solving.
Add your answer

Q1. What is reindexing
Add your answer
Q2. How do you drop columns and rows
Add your answer
Q3. What is comprehension
Add your answer
Q4. Write python code to find odd sum pairs in a list
Add your answer

I cleared the aptitude and coding tests, followed by the communication assessment. After successfully passing both rounds, I was shortlisted for the interviews.

Q1. Tell me about yourself
Add your answer
Q2. Projects and what kind of person I am. Background check.
Add your answer

Q1. Projects, resume
Add your answer
Q2. Cloud computing and cyber security questions.
Add your answer

Q1. Managerial round both technical and HR type questions where asked.
Add your answer
Q2. Scenario based questions
Add your answer