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

MIS Analyst Interview Questions & Answers

Meesho user image Subham Behera

posted on 14 Oct 2024

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Define CTE and how it works

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
-

I applied via Walk-in and was interviewed in May 2023. There were 2 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. Why swtiching your company
Round 2 - Coding Test 

Given a on spot question and we have to solve the problem. As i attended for MIS Job its in Excel. They have a set of questions in that question will be like basic to advanced formulas. We have to solve infront of Interviewer.

Interview Preparation Tips

Topics to prepare for Udaan MIS Analyst interview:
  • Pivot Table
  • VLOOKUP
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Walk-in and was interviewed in Jun 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(1 Question)

  • Q1. Self introduction and knowledge checking
Round 2 - Technical 

(1 Question)

  • Q1. SQL and Excel based questions
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

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Map implementation
  • Q2. Oops questions, exception handling
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Aug 2023. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. How much support does a CRO give to the company to do more business and how?
  • Q2. How to advance company productivity through marketing?
  • Ans. 

    Company productivity can be advanced through marketing by increasing brand awareness, targeting the right audience, utilizing digital marketing strategies, and analyzing data for optimization.

    • Increase brand awareness through targeted advertising campaigns

    • Target the right audience through market research and segmentation

    • Utilize digital marketing strategies such as social media, email marketing, and SEO

    • Analyze data to op

  • Answered by AI

Interview Preparation Tips

Topics to prepare for BlackBuck Assistant Manager interview:
  • direct marketing
  • Marketing
  • Business Development
  • Management
  • B2B Sales
Interview preparation tips for other job seekers - Honestly is the best policy for sale's marketing
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Jun 2024. There were 3 interview rounds.

Round 1 - HR 

(2 Questions)

  • Q1. Tell something about yourself
  • Ans. 

    I am a dedicated and hardworking individual with a passion for learning and growth.

    • I have a Bachelor's degree in Business Administration

    • I have 3 years of experience in marketing and sales

    • I am fluent in English, Spanish, and French

  • Answered by AI
  • Q2. Previous job experience
  • Ans. 

    I have 5 years of experience working in marketing and sales roles at a Fortune 500 company.

    • Managed marketing campaigns and strategies to increase brand awareness

    • Developed sales tactics to drive revenue growth

    • Collaborated with cross-functional teams to achieve business objectives

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. What was your job role in previous company?
  • Ans. 

    I was responsible for managing the marketing campaigns and social media presence of the company.

    • Managed marketing campaigns to increase brand awareness

    • Handled social media accounts to engage with customers

    • Analyzed data to measure the effectiveness of marketing strategies

  • Answered by AI
  • Q2. How you handle the customer on calls?
  • Ans. 

    I handle customer calls by actively listening, empathizing with their concerns, and providing solutions in a professional and friendly manner.

    • Active listening to understand the customer's issue

    • Empathizing with the customer's concerns to show understanding

    • Providing solutions or assistance in a professional and friendly manner

    • Ensuring clear communication and follow-up if needed

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Why you left the previous job?
  • Ans. 

    Seeking new challenges and opportunities for growth.

    • Desire for career advancement

    • Seeking new challenges

    • Opportunity for professional growth

    • Company restructuring

    • Relocation

  • Answered by AI
  • Q2. Anything you would like to ask?
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Apr 2023. There was 1 interview round.

Round 1 - One-on-one 

(2 Questions)

  • Q1. When are you working in Warehouse?
  • Q2. What do you do in the warehouse?

Interview Preparation Tips

Interview preparation tips for other job seekers - BDA

Tell us how to improve this page.

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5k Interviews
Flipkart Interview Questions
3.9
 • 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
 • 221 Interviews
Blinkit Interview Questions
3.7
 • 182 Interviews
View all
Community Operations Specialist
116 salaries
unlock blur

₹2.6 L/yr - ₹4.3 L/yr

Key Account Manager
106 salaries
unlock blur

₹4 L/yr - ₹12 L/yr

Store Manager
104 salaries
unlock blur

₹3.8 L/yr - ₹7 L/yr

Procurement Manager
104 salaries
unlock blur

₹3.5 L/yr - ₹7 L/yr

Delivery Boy
91 salaries
unlock blur

₹0.5 L/yr - ₹4.5 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