Deloitte Analyst Interview Questions, Process, and Tips

It was kinda moderate

The topics were quite interesting

Q1. They asked both technical and personal questions
Add your answer
Q2. Tell me about yourself?
Add your answer

The coding round was average, a little bit tough. The duration of the coding contest was 45 min.

Q1. Tell me something about yourself, Java, Html
Ans. 
I am a skilled Analyst with expertise in Java and HTML.
• Proficient in Java programming language for developing applications

• Experienced in creating web pages using HTML

• Familiar with front-end development tools and frameworks like Bootstrap
Answered by AI
Add your answer

Q1. Why do you want to join Deloitte? What is your future goal?
Add your answer

40 questions in 1.5 hr

Q1. Can you provide details about yourself and your technical background?
Add your answer
Q2. Sql coding questions and it’s logic behind the solution
Add your answer
Q3. What are the basic differences between the different types of SQL joins?
Ans. 
SQL joins are used to combine rows from two or more tables based on a related column between them.
• INNER JOIN: Returns records that have matching values in both tables.

• LEFT JOIN: Returns all records from the left table and the matched records from the right table.

• RIGHT JOIN: Returns all records from the right table and the matched records from the left table.

• FULL JOIN: Returns all records when there is a match in either...read more
Answered by AI
Add your answer

Basic Aptitude test MCQ

Q1. Basic accounting questions and depreciation concept
Add your answer

Q1. Previous Experience, why switching the job, JD related questions.
Add your answer
Q2. Salary round with the HR
Add your answer

Logical reasoning, Aptitude, Basic CS questions. networking

Q1. What are the layers of OSI model
Ans. 
The OSI model consists of 7 layers that define the functions of a network communication system.
• Physical layer - deals with physical connections and transmission of raw data

• Data link layer - responsible for node-to-node communication and error detection

• Network layer - manages routing and addressing

• Transport layer - ensures end-to-end communication and data flow control

• Session layer - establishes, manages, and terminates...read more
Answered by AI
Add your answer
Q2. What is a deadlock
Ans. 
A deadlock is a situation in which two or more competing actions are each waiting for the other to finish, preventing any of them from progressing.
• Occurs in concurrent programming when two or more threads are waiting for each other to release a resource

• Can lead to a standstill where none of the threads can proceed

• Commonly seen in database systems when multiple transactions are trying to access the same data but in diff...read more
Answered by AI
Add your answer