Dunzo interview experience Real time questions & tips from candidates to crack your interview
Analyst
Dunzo
2 rounds | 7 Coding
problems
Rejected
Interview preparation journey
Journey
Dunzo is a 24x7 delivery app that instantly delivers everything you need to your doorstep. I applied for the profile of Data Analyst 1 on the careers website of Dunzo. Fortunately, my resume was shortlisted and I got the test link for that profile. I passed the test successfully, then the technical interview was conducted. Unfortunately, I could not clear the interview and hence got rejected in that round.
Application story
I applied for the profile of Data Analyst 1 on the careers website of Dunzo. Fortunately, my resume was shortlisted and I got the test link for that profile. I passed the test successfully, then the technical interview was conducted. Unfortunately, I could not clear the interview and hence got rejected in that round.
Why selected/rejected for the role?
I was rejected for this role after the technical interview as I was a bit nervous during the interview and hence could not match the expectations of the interviewer. Thus, I could not clear the interview and hence got rejected in that round.
Preparation
Duration: 2 months
Topics: SQL, Python, Power BI, Data Structures, Machine Learning
Tip 1: Have machine learning projects in resume
Tip 2: Better to have analyst experience in any company (internship or full-time)
Tip 3: Have advanced knowledge of SQL
Application process
Where: Company Website
Eligibility: Good Resume
Tip 1: Have machine learning projects in resume
Tip 2: Do not put false things in the resume
Interview rounds
01
Round
Medium
Online Coding Interview
Duration90 mins
Interview date23 Mar 2022
Coding problem4
This round was conducted on the Hackerrank platform. It was 90 minutes long test. It had 2 SQL questions, 2 coding questions, and 8 MCQs on SQL, Python, and data structures.
1. Python Questions
To add a new element to a list we use which Python command?
Which of the following is the use of the id() function in Python?
Problem approach
Tip 1: Read the Python MCQs available on net
Tip 2: Study the question carefully
2. DBMS Question
Query the names of all the cities in the CITY table that have FURNITURE as the main occupation.
Query an alphabetically ordered list of all names in OCCUPATIONS, immediately followed by the first letter of each profession as a parenthetical.
Problem approach
Tip 1: Do practice SQL queries
Tip 2: Keep pen and paper by your side
3. Balanced parentheses
Moderate
10m average time
90% success
0/80
Asked in companies
Given an integer ‘N’ representing the number of pairs of parentheses, Find all the possible combinations of balanced parentheses with the given number of pairs of parentheses.
Note :
Conditions for valid parentheses:
1. All open brackets must be closed by the closing brackets.
2. Open brackets must be closed in the correct order.
For Example :
()()()() is a valid parentheses.
)()()( is not a valid parentheses.
Problem approach
Step 1: Iterate through each character in the expression.
Step 2: If it encounters an opening bracket, it pushes it onto the stack.
Step 3: If it encounters a closing bracket, it checks whether the stack is empty or the top element of the stack does not correspond to the current closing bracket's matching opening bracket.
Step 4: If either of these conditions is true, it means the expression is unbalanced, and the function returns False. Otherwise, it continues checking the remaining characters.
Step 5: Finally, after the iteration, if the stack is empty, it means all the parentheses are balanced, and the function returns True; otherwise, it returns False.
4. DBMS Question
In SQL, which command is used to SELECT only one copy of each set of duplicable rows?
Find all the cities with temperature, condition and humidity whose humidity is in the range of 63 to 79
Problem approach
Tip 1: Read SQL MCQs available on net
Tip 2: Study the question carefully
02
Round
Medium
Video Call
Duration30 mins
Interview date5 Apr 2022
Coding problem3
This round was conducted on Google Meet. I got a bit nervous during the interview and the interviewer made me calm during the interview. It was 30 minutes long.
1. SQL Question
What is the difference between the CHAR and VARCHAR2 datatype in SQL?
Problem approach
Tip 1: Study SQL in detail.
Tip 2: Answer confidently
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
How do you remove whitespace from the start of a string?
Choose another skill to practice
Similar interview experiences
SDE - 1
3 rounds | 4 problems
Interviewed by Dunzo
Selected 
1254 views
0 comments
0 upvotes
SDE - 2
3 rounds | 4 problems
Interviewed by Dunzo
Selected 0 views
0 comments
0 upvotes
SDE - 1
3 rounds | 5 problems
Interviewed by Dunzo
Selected 4718 views
0 comments
0 upvotes
SDE - 1
3 rounds | 6 problems
Interviewed by Dunzo
Rejected
886 views
0 comments
0 upvotes