Deloitte interview experience Real time questions & tips from candidates to crack your interview

Data Analyst

Deloitte
upvote
share-icon
2 rounds | 11 Coding problems

Interview preparation journey

expand-icon
Journey
I started my journey by getting admission to DTU. After exploring different courses and trainings, I finally decided to start learning about data analysis. For this, I took a course from Coding Ninjas. The course helped me build some good projects, which played a key role in helping me crack the internship at Unified Mentors.
Application story
Deloitte had arrived on campus for hiring candidates. The application process was very simple. They provided us with a website where we had to apply for the job. After that, our resumes went through screening and shortlisting. After 2–3 days, I received an email from Deloitte stating that I had been shortlisted for the online assessment round.
Why selected/rejected for the role?
I was not able to clear the technical round, as they were looking for someone with experience in data analysis. They also asked me questions related to machine learning, which I couldn't answer. Additionally, they expected a strong project in machine learning.
Preparation
Duration: 1 month
Topics: Python, Machine Learning Concepts, SQL, Advance Excel, Tableau, Power BI
Tip
Tip

Tip 1: Practice basic questions of coding like write a program for table of 5.
Tip 2: Practice SQL query questions.
Tip 3: Learn Excel from basic to advance.

Application process
Where: Campus
Eligibility: 8 CGPA, (Salary package: 6 LPA)
Resume Tip
Resume tip

Tip 1: Add at least 2 projects.
Tip 2: Don't put irrelevant information in the resume.
Tip 3: The resume should be clean and crisp.

Interview rounds

01
Round
Medium
Online Coding Interview
Duration60 minutes
Interview date10 Apr 2025
Coding problem6

There were 50 MCQs based on Logical Reasoning, Quantitative Aptitude, Verbal Skills, Excel, Data Analysis, and Python.

1. Data Analysis

How does the term "bootstrapping" contribute to statistical analysis?

A) By creating resampled datasets with replacement
B) By fitting multiple models to the same dataset
C) By testing the significance of correlations
D) By estimating the correlation matrix of a dataset

Problem approach

Ans:- A) By creating resampled datasets with replacement

2. Machine Learning

What is the difference between precision and recall?

A) Both measure the same thing
B) Precision focuses on false positives, recall focuses on false negatives
C) Precision focuses on false negatives, recall focuses on false positives
D) Precision and recall are unrelated metrics

Problem approach

Ans:- B) Precision focuses on false positives, recall focuses on false negatives

3. Machine Learning

What is the role of the learning_rate parameter in gradient descent optimization?

A) The speed at which the algorithm converges
B) The regularization strength applied to the model
C) The number of iterations in the optimization process
D) The size of the steps taken during each iteration

Problem approach

Ans:- D) The size of the steps taken during each iteration

4. Excel

How can you create a drop-down list in Excel?

A) Using the AutoFill feature
B) Applying conditional formatting
C) Using the Data Validation feature
D) Applying a filter to a column

Problem approach

Ans:- C) Using the Data Validation feature

5. Code Output

What will be the output of this code:-

count = 1

def doThis():

   global count

   for i in (1, 2, 3): 
       count += 1

doThis()

print (count)

Problem approach

Ans:- 4

6. Number of occurrence

Moderate
26m average time
0/80
Asked in companies
SAP LabsAmazonHSBC

Given a sorted array arr[] and an integer target, the task is to find the number of occurrences of target in given array.

Problem approach

Since the array is already sorted, we can use binary search to find the occurrences of a given target. First, we find the index of the first occurrence (Lower Bound) of target and then the index of the first element greater than the target (Upper Bound). The difference between these two indices will give the total number of occurrences of the target

Try solving now
02
Round
Medium
Video Call
Duration45 minutes
Interview date14 Apr 2025
Coding problem5

The interviewer was nice. He was on time and first he introduced himself and then asked my introduction. Then he asked questions from machine learning, projects and also gave a coding question to solve.

1. Sort 0s, 1s, 2s

Easy
0/40
Asked in companies
AmazonWells FargoDeloitte

Given an array arr[] consisting of only 0s, 1s, and 2s. The task is to sort the array, i.e., put all 0s first, then all 1s and all 2s in last.

Problem approach

Traverse the array once and count number of 0s, 1s and 2s, say c0, c1 and c2 respectively. Now traverse the array again, put c0 (count of 0s) 0s first, then c1 1s and finally c2 2s. This solution works in O(n) time, but it is not stable and requires two traversals of the array.

Try solving now

2. SQL

Write a SQL query to print details of the Students whose first name ends with 'a'.

3. Machine Learning

  • What are some of the hyperparameters of the random forest regressor which help to avoid overfitting? (Learn)
  • How you would assess the goodness-of-fit for a linear regression model? (Learn)
  • Why does PCA maximize the variance in the data? (Learn)

4. Data Analysis

What is the difference between pandas Series and pandas DataFrames? (Learn)

5. Python

What is a break, continue, and pass in Python? (Learn)

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is recursion?

Choose another skill to practice
Similar interview experiences
company logo
Data Analyst
3 rounds | 3 problems
Interviewed by Deloitte
3255 views
0 comments
0 upvotes
company logo
Software Engineer
2 rounds | 2 problems
Interviewed by Deloitte
1374 views
0 comments
0 upvotes
company logo
SDE - Intern
2 rounds | 3 problems
Interviewed by Deloitte
1370 views
0 comments
0 upvotes
company logo
Product Engineering Intern
2 rounds | 5 problems
Interviewed by Deloitte
833 views
0 comments
0 upvotes