Filter interviews by
Clear (1)
I applied via Instahyre and was interviewed before Nov 2022. There were 5 interview rounds.
Sql Coding round questions were asked
Top trending discussions
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 Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
SQL based questions wer asked on joins , rank function,
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 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 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 Approached by Company and was interviewed in Apr 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed in Oct 2020. There was 1 interview round.
I applied via Recruitment Consulltant and was interviewed in Jun 2022. There were 2 interview rounds.
WHERE clause filters rows before grouping while HAVING clause filters groups after grouping.
WHERE clause is used to filter rows based on a condition before grouping them.
HAVING clause is used to filter groups based on a condition after grouping them.
WHERE clause is used with SELECT, UPDATE, DELETE statements while HAVING clause is used with GROUP BY clause.
WHERE clause is faster than HAVING clause as it filters rows be...
based on 3 interviews
Interview experience
Hub Lead
19
salaries
| ₹0 L/yr - ₹0 L/yr |
Customer Support Executive
19
salaries
| ₹0 L/yr - ₹0 L/yr |
Store Manager
19
salaries
| ₹0 L/yr - ₹0 L/yr |
Cluster Manager
17
salaries
| ₹0 L/yr - ₹0 L/yr |
Customer Service Executive
16
salaries
| ₹0 L/yr - ₹0 L/yr |
Licious
ZappFresh.com
BigBasket
Blinkit