i
Licious
Filter interviews by
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
SQL based questions wer asked on joins , rank function,
I applied via Referral and was interviewed before May 2020. There was 1 interview round.
To understand the supply of restaurants in a particular area of a city, we can use various methods.
Collect data from online directories like Yelp, Zomato, etc.
Conduct surveys to gather information about the number of restaurants in the area.
Analyze the population density and demographics of the area to estimate the demand for restaurants.
Check the number of restaurant permits issued by the local government.
Use GIS mapp...
I applied via Naukri.com and was interviewed before Nov 2023. There were 2 interview rounds.
Use SQL query with ORDER BY and LIMIT to find 3rd highest salary.
Use SELECT statement to retrieve salary column
Use ORDER BY clause to sort salaries in descending order
Use LIMIT 2,1 to skip first two highest salaries and retrieve the third highest salary
I was interviewed in Mar 2021.
Steps involved in analyzing decrease in sales for a particular area
Identify the time period for which sales have decreased
Analyze the sales data for the area and compare it with previous periods
Identify any external factors that may have contributed to the decrease in sales
Conduct customer surveys to identify any issues with products or services
Analyze competitor activity in the area
Develop a plan to address the issues...
SQL query to find mean waiting period for delivery partner given driver ID, ordered time and delivered time.
Use AVG function to calculate mean waiting period
Subtract ordered time from delivered time to get waiting period
Filter data by driver ID and delivery partner
Group by delivery partner
Rolling sum query adds up a specified number of rows in a table based on a given condition.
Use the OVER() function to specify the window frame for the rolling sum.
Specify the number of rows to include in the window frame using ROWS BETWEEN.
Use ORDER BY to specify the order of rows in the window frame.
Example: SELECT column1, SUM(column2) OVER (ORDER BY column1 ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FR
I was interviewed in Nov 2021.
Round duration - 60 minutes
Round difficulty - Easy
Prepare well for SQL, you have to be strong in SQL. Questions related to SQL and A/B testing were asked.
Query to calculate rolling sum
Use window functions like SUM() OVER() in SQL
Specify the window frame to define the range for the rolling sum
Example: SELECT date, value, SUM(value) OVER (ORDER BY date ROWS BETWEEN 2 PRECEDING AND CURRENT ROW) AS rolling_sum FROM table_name
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Prepare well for SQL, you have to be strong in SQL.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via LinkedIn and was interviewed before May 2020. There was 1 interview round.
The amount of work experience is an important factor in determining the suitability of a candidate for the Business Analyst role.
Work experience helps in developing a deep understanding of business processes and industry trends.
It allows the candidate to gain practical knowledge and skills in data analysis, problem-solving, and project management.
Having relevant work experience demonstrates the ability to work effectiv...
I applied via Referral and was interviewed before Mar 2021. There were 4 interview rounds.
Types of SQL joins and their minimum and maximum possible rows.
Types of joins: Inner, Left Outer, Right Outer, Full Outer, Cross
Minimum rows: Inner - 0, Left/Right Outer - 1, Full Outer - 0, Cross - product of rows
Maximum rows: Inner/Left/Right/Full Outer - product of rows, Cross - product of rows
1.Features you would look for if you have to buy an elevator
2. How do you estimate the number of trains passing through a station
I applied via Company Website and was interviewed in Sep 2023. There were 4 interview rounds.
SQL and case study and was of an hour length
I applied via Approached by Company and was interviewed in Mar 2024. There were 4 interview rounds.
SQL And Excel Test with Intermidiate to Entry level questions
SQL Test with questions on Window fx and logic
Case on various company and there problems
The drop in Flipkart's revenue in December compared to November can be attributed to seasonal factors, promotional activities, or changes in consumer behavior.
Seasonal factors such as holiday sales in November leading to higher revenue compared to December
Promotional activities like Black Friday or Cyber Monday driving higher sales in November
Changes in consumer behavior, such as delayed purchases or reduced spending a
I want to join Swiggy because of its innovative technology, fast-paced environment, and impact on the food delivery industry.
Swiggy's cutting-edge technology and data-driven approach to food delivery excites me
I am drawn to the fast-paced and dynamic work environment at Swiggy
Swiggy's significant impact on the food delivery industry and its rapid growth potential are appealing to me
based on 1 interview
Interview experience
HUB Manager
109
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager
101
salaries
| ₹0 L/yr - ₹0 L/yr |
QA Executive
36
salaries
| ₹0 L/yr - ₹0 L/yr |
Executive Production
36
salaries
| ₹0 L/yr - ₹0 L/yr |
Territory Sales Manager
32
salaries
| ₹0 L/yr - ₹0 L/yr |
BigBasket
FreshToHome
ZappFresh.com
Blinkit