Upload Button Icon Add office photos

Swiggy

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

Swiggy MIS Analyst Interview Questions, Process, and Tips

Updated 1 Oct 2024

Top Swiggy MIS Analyst Interview Questions and Answers

  • Q1. 1.what do you know about Swiggy and it's business model. 2.simple SQL queries 3. Vlookup.
  • Q2. Write a query to find out students has greater than 80 marks and from English subject?
  • Q3. Write a query employes join between such dates?
View all 8 questions

Swiggy MIS Analyst Interview Experiences

3 interviews found

MIS Analyst Interview Questions & Answers

user image Anonymous

posted on 23 Aug 2024

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

Rate your
company

🤫 100% anonymous

How was your last interview experience?

Share interview

MIS Analyst Interview Questions & Answers

user image Anonymous

posted on 1 Oct 2024

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

Asking about ur self introduction and work experience

MIS Analyst Interview Questions Asked at Other Companies

asked in Swiggy
Q1. 1.what do you know about Swiggy and it's business model. 2.simple ... read more
asked in Swiggy
Q2. Write a query to find out students has greater than 80 marks and ... read more
Q3. How to start VBA code and what sub and what is sub called
asked in RBL Bank
Q4. Except excel what do you know Vba or python
Q5. How far have you the knowledge of Managing And it's systems..

MIS Analyst Interview Questions & Answers

user image Anonymous

posted on 25 Dec 2020

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 questions from similar companies

I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL, Business cases

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with examples for each of the 14 principles

I applied via Referral and was interviewed before Apr 2021. There were 3 interview rounds.

Round 1 - HR 

(3 Questions)

  • Q1. Why are you looking for a change?
  • Q2. Tell me about yourself.
  • Q3. Why should we hire you?
Round 2 - Aptitude Test 

Basic sql

Round 3 - Technical 

(1 Question)

  • Q1. Project manager round

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure to read Amazon list of principles,and ensure your cv speaks to it

Interview Questionnaire 

3 Questions

  • Q1. General HR questions, some based on the CV
  • Q2. A marketing specific question
  • Q3. Weight of an aircraft
  • Ans. 

    The weight of an aircraft is crucial for its performance and safety.

    • The weight of an aircraft includes the weight of the aircraft itself, fuel, passengers, cargo, and any other equipment on board.

    • The weight of an aircraft is measured in pounds or kilograms.

    • The weight of an aircraft affects its takeoff and landing performance, as well as its fuel efficiency and range.

    • Aircraft manufacturers provide maximum takeoff and la...

  • Answered by AI

Interview Preparation Tips

Round: Test
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.

Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.

Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.

Round: Guesstimate Interview
Experience: A very commonly asked guesstimate problem. Ask as many questions as possible to clear out the situation for yourself and get enough hints to solve the problem. Break it down into smaller sections and solve each section individually.
Tips: Follow "case in point", Analytics Vidya and similar blogs and websites to practice more and more guesstimates.

General Tips: There are so many opportunities. You just need one. Be focused on that ONE.
Skill Tips: Take part in discussions among your friends. Read books and quora to get more content. Practice as many questions as possible for aptitude. Discuss problems and have critical analysis sessions to understand things with a company's perspective.
Skills: Communication , Aptitude, Business Acumen
College Name: IIT GUWHATI
Motivation: To learn the operations and Logistics of the e-commerce industry.
Funny Moments: There will be many while you'll be preparing with your friends. :D
All the best.

Interview Questionnaire 

1 Question

  • Q1. Question 1: General HR questions, some based on the CV Question 2: A marketing specific question

Interview Preparation Tips

Round: Test
Experience: The test basically tests your ability to solve questions as quickly as possible as it's a 60 minute test for 60 questions. The level of difficulty is pretty decent, so one just needs to be focused right from the beginning. English can trouble a bit, so some practice in English sections is also advisable.
Tips: Prepare from Arun Sharma Quantitative Aptitude and Logical Reasoning for CAT. It's a wholesome book and has enough questions to practice and build concepts. Join a test series so that you get a timed analysis of your performance, the ability to skip tough questions and to score as many marks as possible.
Duration: 40 minutes

Round: Group Discussion
Experience: It went pretty well. We had a great discussion. The approach was to list out all the problems one by one and think of probable solutions for each of them. During this, general group dynamics should be taken in consideration. Respect the views and thoughts of other people. Add value to the discussion by thinking critically and bringing new content every now and then. Always be specific and speak to the point.
Tips: Read. Read and Read.
Follow google news, read relevant articles in newspapers, magazines, social media sites or any other place.
Follow Quora, It'a an amazing source to boost your knowledge around any topic.
Duration: 50 minutes

Round: HR Interview
Experience: Be spontaneous, little humorous and lastly very confident. Communication skills improve with time, so start as early as possible. Take part in discussions. Speak up !
Tips: Have a sound knowledge about the industry and the company. They just check your approach. So be very clear and critical on the approach. Have good reasons to back what ever you present. Rest will be fine.

Skills: Communication And Confidence, Analytical Skills, Business Logic, Business Acumen
College Name: Institute of Management, Nirma University

I was interviewed before Nov 2019.

Interview Questionnaire 

6 Questions

  • Q1. Visualize a Uber database of drivers and riders(users) and write a SQL query to get the top 100 drivers by city.
  • Ans. 

    SQL query to get top 100 Uber drivers by city

    • Join drivers and users tables on city

    • Aggregate driver ratings and count of rides

    • Order by rating and count of rides

    • Limit to top 100

  • Answered by AI
  • Q2. How do you optimize the listing of Restaurants on Swiggy?
  • Ans. 

    Optimizing the listing of Restaurants on Swiggy involves using data-driven strategies to improve visibility, relevance, and user experience.

    • Analyze user behavior and preferences to understand their needs and preferences

    • Implement a ranking algorithm based on factors like ratings, reviews, popularity, and delivery time

    • Optimize search functionality to ensure accurate and relevant results

    • Collaborate with restaurants to imp...

  • Answered by AI
  • Q3. What are the major differences between a Linear Regression and a Logistic Regression?
  • Ans. 

    Linear Regression is used for continuous data while Logistic Regression is used for categorical data.

    • Linear Regression predicts continuous values while Logistic Regression predicts probabilities.

    • Linear Regression uses a straight line to fit the data while Logistic Regression uses an S-shaped curve.

    • Linear Regression uses Mean Squared Error as the cost function while Logistic Regression uses Log Loss.

    • Linear Regression is...

  • Answered by AI
  • Q4. What is the Bias Variance trade-off and name some models with high bias and low variance?
  • Ans. 

    Bias-Variance trade-off is the balance between overfitting and underfitting. High bias models are simple but inaccurate, low variance models are complex but overfit.

    • Bias-Variance trade-off is a fundamental concept in machine learning.

    • High bias models are simple and have low variance, but are inaccurate.

    • Low bias models are complex and have high variance, but can overfit the data.

    • Examples of high bias models are linear r...

  • Answered by AI
  • Q5. A car manufacturer has observed a decline in profits by 40% year over year. What would be the possible reasons for this?
  • Ans. 

    Possible reasons for a car manufacturer's decline in profits by 40% year over year

    • Decreased demand for cars due to economic downturn

    • Increased competition from other car manufacturers

    • Rising production costs and expenses

    • Decline in consumer confidence and spending

    • Changes in government regulations impacting the automotive industry

  • Answered by AI
  • Q6. If you have 100 unbiased coins and one of them is defective. You have a weighing balance to check the weight of the coins. What is the minimum number of times you need to weigh the coins to identify the de...

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare well for the projects which you have worked upon. Practice case studies on varied businesses from a problem-solving perspective with an analytical approach.

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in Mar 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. TELL US ABOUT YOURSELF? WHY WOULD YOU BE A GOOD FIT FOR ZOMATO? WHAT ARE YOUR STRNEGHTS?

Interview Preparation Tips

Interview preparation tips for other job seekers - IT WAS GOOD

Interview Questionnaire 

1 Question

  • Q1. How would you sell a simple pen for 1 lakh.
  • Ans. 

    This pen is not just a writing instrument, it's a statement of luxury and exclusivity.

    • Highlight the pen's unique design and craftsmanship

    • Emphasize the use of high-quality materials

    • Mention any special features or functions

    • Create a sense of exclusivity and rarity

    • Appeal to the buyer's desire for luxury and status

    • Offer personalized engraving or customization options

  • Answered by AI
Contribute & help others!
anonymous
You can choose to be anonymous

Swiggy Interview FAQs

How many rounds are there in Swiggy MIS Analyst interview?
Swiggy interview process usually has 1-2 rounds. The most common rounds in the Swiggy interview process are Technical and Aptitude Test.
What are the top questions asked in Swiggy MIS Analyst interview?

Some of the top questions asked at the Swiggy MIS Analyst interview -

  1. 1.what do you know about Swiggy and it's business model. 2.simple SQL queries ...read more
  2. Write a query to find out students has greater than 80 marks and from English s...read more
  3. Write a query employes join between such dat...read more

Recently Viewed

PHOTOS

InsuranceDekho

3 office photos

LIST OF COMPANIES

Credit Bajaar

Overview

SALARIES

OPPO

REVIEWS

Amdocs

No Reviews

SALARIES

OPPO

SALARIES

OPPO

REVIEWS

Swiggy

No Reviews

COMPANY BENEFITS

Swiggy

No Benefits

COMPANY BENEFITS

Bosch

No Benefits

SALARIES

OPPO

No Salaries

Tell us how to improve this page.

Swiggy MIS Analyst Interview Process

based on 2 interviews

Interview experience

3
  
Average
View more

Anonymously discuss salaries, work culture, and many more

Get Ambitionbox App

Interview Questions from Similar Companies

Amazon Interview Questions
4.1
 • 5.1k Interviews
Flipkart Interview Questions
4.0
 • 1.4k Interviews
BigBasket Interview Questions
3.9
 • 357 Interviews
Udaan Interview Questions
4.0
 • 335 Interviews
Meesho Interview Questions
3.7
 • 329 Interviews
Zomato Interview Questions
3.7
 • 322 Interviews
Info Edge Interview Questions
3.9
 • 320 Interviews
Lenskart Interview Questions
3.2
 • 302 Interviews
Zepto Interview Questions
3.5
 • 202 Interviews
View all
Swiggy MIS Analyst Salary
based on 51 salaries
₹2.3 L/yr - ₹5.2 L/yr
At par with the average MIS Analyst Salary in India
View more details

Swiggy MIS Analyst Reviews and Ratings

based on 7 reviews

4.0/5

Rating in categories

4.4

Skill development

3.8

Work-life balance

3.9

Salary

3.7

Job security

4.7

Company culture

2.9

Promotions

4.4

Work satisfaction

Explore 7 Reviews and Ratings
Delivery Boy
871 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Fleet Manager
583 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Manager
523 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Manager
498 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Assistant Store Manager
450 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Swiggy with

Zomato

3.8
Compare

Dunzo

3.4
Compare

FoodPanda

3.7
Compare

Rapido

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