Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Dunzo Team. If you also belong to the team, you can get access from here

Dunzo Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Dunzo Analyst Intern Interview Questions and Answers

Be the first one to contribute and help others!

Interview questions from similar companies

I applied via Recruitment Consultant and was interviewed before Dec 2019. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1.what do you know about Swiggy and it's business model. 2.simple SQL queries 3. Vlookup.
  • Ans. 

    Swiggy is an Indian food delivery company that operates through a website and mobile app.

    • Swiggy was founded in 2014 and is headquartered in Bangalore, India.

    • It partners with local restaurants to provide food delivery services to customers.

    • Swiggy's business model is based on charging a commission fee from the restaurants for every order placed through their platform.

    • It has expanded to over 500 cities in India and has ov...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Do not join as MIS in Swiggy. Work of MIS will be just copy paste nothing else. Join only if you have financial problems. Here you can't get any hike nor they will make permanent.

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Dec 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Basic attitude test conducted first.

Round 3 - One-on-one 

(5 Questions)

  • Q1. Questions related to Advanced MS Excel, Basic SQL Queries.
  • Q2. Count total no. of cities ?
  • Ans. 

    The total number of cities cannot be counted without specific data or context.

    • The total number of cities can vary depending on the country, region, or dataset being considered.

    • One would need a list of cities or a specific area of focus to accurately count the total number of cities.

    • For example, the total number of cities in the United States is different from the total number of cities in India.

  • Answered by AI
  • Q3. What is Index and Match ?
  • Ans. 

    Index and Match are functions in Excel used to lookup values in a table based on specific criteria.

    • Index function returns the value of a cell in a table based on the row and column number provided.

    • Match function returns the position of a value in a range.

    • Index and Match functions are often used together to perform more flexible lookups than VLOOKUP or HLOOKUP.

    • Example: =INDEX(A1:D10, MATCH(123, B1:B10, 0), 3) will retur...

  • Answered by AI
  • Q4. What is Vlookup and Hlookup ?
  • Ans. 

    Vlookup and Hlookup are functions in Excel used to search for a value in a table and return a corresponding value.

    • Vlookup stands for vertical lookup and is used to search for a value in the first column of a table and return a value in the same row from a specified column.

    • Hlookup stands for horizontal lookup and is used to search for a value in the first row of a table and return a value in the same column from a speci...

  • Answered by AI
  • Q5. How to calculate Vlookup?
  • Ans. 

    Vlookup is a function in Excel used to search for a value in a table and return a corresponding value.

    • Use the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

    • lookup_value is the value to search for in the first column of the table

    • table_array is the range of cells that contains the data

    • col_index_num is the column number in the table from which to retrieve the data

    • range_lookup is optional and ca...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Work on MS Excel & SQL Queries
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Technical 

(4 Questions)

  • Q1. Rank Function Application in Google Sheet?
  • Ans. 

    Rank function in Google Sheets is used to assign a rank to a value in a list based on its order.

    • Rank function is used to determine the rank of a value in a list.

    • It can be used to rank values in ascending or descending order.

    • The syntax for the rank function is RANK(value, range, [is_ascending]).

  • Answered by AI
  • Q2. Joins From SQL?
  • Ans. 

    Joins in SQL are used to combine rows from two or more tables based on a related column between them.

    • Joins are used to retrieve data from multiple tables based on a related column.

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column;

  • Answered by AI
  • Q3. Order Of query execution in SQL?
  • Ans. 

    The order of query execution in SQL is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • FROM: Specifies the tables from which data will be retrieved.

    • WHERE: Filters the rows based on specified conditions.

    • GROUP BY: Groups the rows based on specified columns.

    • HAVING: Filters the groups based on specified conditions.

    • SELECT: Retrieves the columns specified in the query.

    • ORDER BY: Sorts the result set based on specified column

  • Answered by AI
  • Q4. Write a query to find out students has greater than 80 marks and from English subject?
  • Ans. 

    Query to find students with over 80 marks in English subject

    • Use SELECT statement to retrieve data

    • Filter the results using WHERE clause for marks greater than 80

    • Include condition for English subject using AND operator

  • Answered by AI
Round 2 - Technical 

(4 Questions)

  • Q1. When we use having clause ?
  • Ans. 

    HAVING clause is used in SQL to filter groups based on specified conditions after GROUP BY clause.

    • HAVING clause is used with GROUP BY clause to filter groups based on specified conditions.

    • It is used to filter the results of aggregate functions like COUNT, SUM, AVG, etc.

    • It is used to apply conditions to groups, similar to WHERE clause which applies conditions to individual rows.

    • Example: SELECT department, AVG(salary) FR...

  • Answered by AI
  • Q2. Aggregate Function Application?
  • Ans. 

    Aggregate functions are used to perform calculations on groups of rows in a table.

    • Aggregate functions include SUM, AVG, COUNT, MIN, and MAX.

    • They are commonly used in SQL queries to summarize data.

    • For example, you can use SUM to calculate the total sales for a specific product.

    • Another example is using AVG to find the average salary of employees in a department.

  • Answered by AI
  • Q3. Group by and order By?
  • Q4. Write a query employes join between such dates?
  • Ans. 

    Use a SQL query with JOIN to retrieve employees between specified dates.

    • Use the JOIN keyword to combine data from two tables

    • Specify the date range using the WHERE clause

    • Example: SELECT * FROM employees e JOIN dates d ON e.date = d.date WHERE d.date BETWEEN '2022-01-01' AND '2022-12-31'

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Swiggy MIS Analyst interview:
  • EXCEL FUNCTIONS
  • SQL JOINS
  • SQL CLAUSES
Interview preparation tips for other job seekers - Prepare well for advance excel and google sheet function and formulas Theoretically as well as practically.
also prepare deep from SQL basic to advance.

Skills evaluated in this interview

Interview experience
1
Bad
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Asking about ur self introduction and work experience

I was interviewed before May 2016.

Interview Preparation Tips

Round: Group Discussion
Experience: Extempore was conducted which is almost same as GD. In Extempore round each individual should select his own topic and talk for 2 minutes. Eye donation was the topic selected by me. The main concept of this round is to check the fluency over language
Tips: Be confident in what you speak. Dont get nervoused in this round

Round: Problem Statement
Experience: Extempore was conducted which is almost same as GD. In Extempore round each individual should select his own topic and talk for 2 minutes. Eye donation was the topic selected by me. The main concept of this round is to check the fluency over language
Tips: Be confident in what you speak. Dont get nervoused in this round

I was interviewed in Sep 2016.

Interview Questionnaire 

2 Questions

  • Q1. Being a mechanical engineer why do you choose corporate?
  • Ans. 

    As a mechanical engineer, I choose corporate because it offers diverse opportunities, professional growth, and stability.

    • Corporate provides a wide range of industries and sectors to work in, allowing me to explore different areas of mechanical engineering.

    • Working in a corporate environment offers opportunities for professional growth through training programs, mentorship, and exposure to new technologies.

    • Corporate jobs...

  • Answered by AI
  • Q2. Common puzzle questions

Interview Preparation Tips

Round: Group Discussion
Experience: Extempore was the name of the round. It is almost same as GD but instead each candidate should select his own topic and talk for 2 minutes.
Tips: Fluency over language is the main element focused in this round
Duration: 2 hours

Round: Problem Statement
Experience: In this round the candidate should attend online aptitude test for 1 hour. It consists of three parts : Logical part, Reasoning part, Language part. This round is easier one.
Tips: Concentrate more on English grammar

Round: HR Interview
Experience: Shortlisted candidates were called for HR round. For non IT students the main question asked was being a non IT student why do you choose corporate field.
Tips: The answer for this question cannot be provided by myself. Each of you candidates should build a genuine answer for this one

Round: Puzzle Interview
Experience: This is the final round of the whole interview process. In this round the candidates were focused asking only on puzzle questions. 3 to 5 questions were asked in this round depending upon the mentality of HR. 75 % score is required to clear this round
Tips: Just Google puzzle questions for interview, then work on those questions. You will get an idea on how to clear this round

Associate Interview Questions & Answers

Amazon user image Sayeda Peerzade

posted on 10 Jul 2017

I was interviewed in Mar 2017.

Interview Questionnaire 

1 Question

  • Q1. Self introduction, Strengthens and weakness, best friend, why Amazon

Interview Preparation Tips

Round: Resume Shortlist
Experience: We were asked to introduce ourselves and also speak about the environment of the room. Then asked to speak about Amazon and why do we want to work with Amazon
Tips: Be confident

Round: Test
Experience: Pronounciaton skills were examined
Tips: Flexible in talking in English
Duration: 20 minutes
Total Questions: 25

Round: HR Interview
Experience: HR was really cooperative he asked to relax and then started asking questions in a gentle manner. He made me feel comfortable. And reduced the nervous environment.
Tips: Be confident and don't be nervous

Skills: Language, Time Management
College Name: VHD central institute of home science

Analyst Interview Questions & Answers

Flipkart user image Pratyaksh Karan

posted on 28 Mar 2015

Interview Preparation Tips

Round: Group Discussion
Experience: Nicely organized GD, civilized and intellectual GD group, discussion rich topic
Tips: Allow others to speak when they have something to say. Do try to push your way in if someone is talking too long or talking gibberish. Do not push your point too much, however, present logical arguments in favor. Try to draw similarities from what others say. Try to include all.

Round: HR Interview
Experience: Friendly HR interviewer. Non-direct questions but not too difficult.
Tips: Answer all questions honestly but be polite. Don't present too strong views, you are too young for that. Don't repeat content with different words, but be elaborate enough to let the interviewer know you.

Round: Guesstimate Interview
Tips: Read up some guesstimates and case studies before placements, discuss some with friends too. Open up your mind while guesstimating. Speak all that comes to your head, and vocally sift through them to get the logical and pursue-able approaches. The interviewer should get a complete idea of your analytical approach.

College Name: IIT Kharagpur
Motivation: First foray into corporate structure. Lots of opportunities. Diversified experiences.

I applied via Company Website and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. About previous work experience
  • Q2. About process improvements

Interview Preparation Tips

Interview preparation tips for other job seekers - Interview is quiet tough

Analyst Interview Questions & Answers

Ola Cabs user image Tarun Meena

posted on 15 Jan 2015

Interview Preparation Tips

Round: Test
Experience: It was a very general aptitude test, including probability reasoning etc.
Tips: practice some CAT papers

Round: HR Interview
Experience: Very basic and general HR questions starting with tell me something about yourself and why this job?
Tips: You should have tailor made answers for tell me about yourself for different sectors/firms, this will help a lot, start preparing on this a month in advance.

College Name: IIT BOMBAY

Tell us how to improve this page.

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5k Interviews
Flipkart Interview Questions
4.0
 • 1.3k Interviews
Paytm Interview Questions
3.3
 • 752 Interviews
Swiggy Interview Questions
3.8
 • 428 Interviews
BigBasket Interview Questions
3.9
 • 359 Interviews
Udaan Interview Questions
4.0
 • 334 Interviews
Meesho Interview Questions
3.7
 • 328 Interviews
Zomato Interview Questions
3.8
 • 312 Interviews
Zepto Interview Questions
3.5
 • 207 Interviews
Blinkit Interview Questions
3.7
 • 181 Interviews
View all
Community Operations Specialist
116 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Store Manager
104 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Procurement Manager
104 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Delivery Boy
91 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Inward Executive
90 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Dunzo with

Swiggy

3.8
Compare

Zepto

3.5
Compare

Porter

3.9
Compare

Rapido

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview