Filter interviews by
Clear (1)
I applied via Referral and was interviewed in Sep 2024. There was 1 interview round.
The requirement of bananas in a city like Mumbai can be calculated based on population, consumption habits, and availability.
Calculate the population of Mumbai
Estimate the average consumption of bananas per person
Consider factors like tourism and events that may increase demand
Take into account the availability of bananas from local markets and imports
A good retailer focuses on customer satisfaction, product quality, and efficient operations.
Good retailers prioritize customer satisfaction by providing excellent customer service and addressing customer needs.
Good retailers offer high-quality products that meet customer expectations.
Good retailers have efficient operations, including inventory management, supply chain logistics, and streamlined processes.
Bad retailers...
I applied via Naukri.com and was interviewed in Jan 2024. There was 1 interview round.
Advanced Excel formulas are complex functions used for data analysis and manipulation.
Advanced formulas in Excel include VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, and IFERROR.
These formulas are used for tasks like data lookup, conditional calculations, and summarizing data.
For example, VLOOKUP is used to search for a value in a table and return a corresponding value from another column.
Top trending discussions
Normal distribution is a probability distribution that is symmetric and bell-shaped.
It is also known as Gaussian distribution.
It is characterized by mean and standard deviation.
Many natural phenomena follow normal distribution, such as height and weight of individuals.
68% of the data falls within one standard deviation of the mean, 95% within two standard deviations, and 99.7% within three standard deviations.
It is wid...
SQL jobs include database administrator, data analyst, data scientist, business intelligence analyst, and software developer.
Database Administrator
Data Analyst
Data Scientist
Business Intelligence Analyst
Software Developer
I applied via Referral and was interviewed before Aug 2022. There were 2 interview rounds.
Setting up a Dark Store involves converting a retail store into a fulfillment center for online orders.
Select a suitable location for the Dark Store, preferably in a centralized area with good access to transportation.
Optimize the layout of the store for efficient picking, packing, and shipping of orders.
Implement inventory management systems to track stock levels accurately and prevent stockouts.
Train staff on order f...
Joins combine data from two or more tables based on a related column.
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.id = table2.id
The order of execution in a query determines the sequence in which operations are performed.
1. The order of execution in a query typically follows the sequence: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.
2. The FROM clause specifies the tables involved in the query.
3. The WHERE clause filters the rows based on specified conditions.
4. The GROUP BY clause groups the rows that have the same values into summary rows.
5...
Group By is used to aggregate data based on a specific column, while Distinct is used to remove duplicate rows from a result set.
Group By is used with aggregate functions like COUNT, SUM, AVG, etc.
Distinct is used to retrieve unique values from a column or set of columns.
Group By can be used to group data based on multiple columns, while Distinct operates on individual columns only.
I applied via Instahyre and was interviewed in May 2024. There were 2 interview rounds.
Asked to write different SQL queries.
1. Moving average of lf previous 10 days
2. For a data which records in and out time of an employee. How many employees were present in the office at a given time
3. A/B testing vs pre-post testing
1. Had to come up with a method to give a score to each user based on FRM(frequency, recency, monetory)
2. Guesstimate: how many burgers does McD sells in a day
I applied via Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
I was interviewed in May 2021.
Round duration - 20 minutes
Round difficulty - Easy
Received a sudden call from one of the interviewers (Came to know this later as first round interview was with the same person). No background disturbances, but they took me by surprise.
Round duration - 90 minutes
Round difficulty - Easy
Evening time
Virtual interview from home, so choose a calm place
Interviewer really helpful and was giving ample time to solve
Round duration - 90 minutes
Round difficulty - Easy
Afternoon
Round duration - 60 minutes
Round difficulty - Easy
Evening
Given an array 'ARR' of 'N' distinct integers, determine the third largest element in the array.
The first line contains a single integer 'T' representing the numb...
Find the third largest element in an array of distinct integers.
Sort the array in descending order
Return the element at index 2 as the third largest element
Round duration - 90 Minutes
Round difficulty - Easy
Evening.
This round is with the co-founder as he acts as the hiring manager as well.
This round is the most tricky one and you really need to be very careful in what you answer in this interview.
Tip 1 : Extensively practice on SQL, SQL queries, extracting data, different types of joins as I had to solve and extract specified data from a dataset in front of the interviewer during the interview. Also, there is a telephonic pre-interview round that is focussed on SQL and Statistics basics. You need to clear that to move to the interviews.
Tip 2 : Practice lots of guesstimates, puzzles, problem solving and Case studies. Guesstimates may include questions like estimating the total area under warehouses in a specific region (I was asked something similar to this).
Tip 3 : Extensively read about the company, JD and the core values of the company. They seem to focus extensively on these values and you need to prove that you fit within them.
Tip 4 : Be really cool, confident and you need to know even the tiniest details of your project work. Grinding on projects and tech skills are a part of all interview rounds.
Tip 1 : Clean and Concise, only put things that you are very much comfortable in answering even to the tiniest details.
Tip 2 : Heavy focus on technical Skills. Mention the exact tech skills and project work/tech you used on those projects because they really pay attention to every nook and corner of your resume. Include you extra-curriculars as this is extremely important during the interview process. They will ask you to mention/describe situations where you showcased a particular skill (for hints related to these, refer to the core values section of their website.)
I applied via Instahyre and was interviewed before Nov 2022. There were 5 interview rounds.
Sql Coding round questions were asked
I applied via Naukri.com and was interviewed in Aug 2022. There were 3 interview rounds.
As I had applied for analyst role, I was asked questions from SQL, Excel and Python.
based on 2 interviews
Interview experience
based on 1 review
Rating in categories
Assistant Manager
57
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Manager Procurement
23
salaries
| ₹0 L/yr - ₹0 L/yr |
Deputy Manager
10
salaries
| ₹0 L/yr - ₹0 L/yr |
Operations Executive
9
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
8
salaries
| ₹0 L/yr - ₹0 L/yr |
BigBasket
Blinkit
FreshToHome
Ninjacart