i
Rapido
Filter interviews by
Clear (1)
Sql test in Hackerrank
Test duration of 1 hour based on probability and control statements
I have prior knowledge about various machine learning algorithms.
Linear Regression
Logistic Regression
Decision Trees
Random Forests
Support Vector Machines
Naive Bayes
K-Nearest Neighbors
Gradient Boosting
Neural Networks
I have studied and used various data visualization techniques including bar charts, line graphs, scatter plots, and heat maps.
I have experience creating bar charts to compare data across categories
I have used line graphs to show trends over time
I have created scatter plots to identify correlations between variables
I have used heat maps to visualize data density and identify patterns
Top trending discussions
I applied via Campus Placement and was interviewed before Aug 2022. There were 3 interview rounds.
The aptitude questions were bit easy and there were questions about SQL, and also excel sheets.
I applied via LinkedIn and was interviewed before Feb 2023. There were 4 interview rounds.
Approx 30 questions which are to be solved in 1 hour. Questions include logical and mathematical questions along with basic ML and stats questions
Basic Apititude Questions
WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.
WHERE is used with SELECT statement to filter rows based on a condition
HAVING is used with GROUP BY statement to filter groups based on a condition
WHERE is applied before data is grouped, HAVING is applied after data is grouped
Example: SELECT * FROM table WHERE column = 'value'
Example: SELECT column, COUNT(*) FROM table GROUP B
Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.
Row level filters are used to filter individual rows of data before any aggregations are performed.
Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.
Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...
I applied via Approached by Company and was interviewed before Jun 2023. There were 3 interview rounds.
It was basic MCQ related to Javascript
It was easy consisting of sql and excel questions
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.
based on 3 interviews
Interview experience
based on 4 reviews
Rating in categories
Associate Manager
89
salaries
| ₹0 L/yr - ₹0 L/yr |
Delivery Boy
55
salaries
| ₹0 L/yr - ₹0 L/yr |
Data Analyst
53
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
44
salaries
| ₹0 L/yr - ₹0 L/yr |
Driver
36
salaries
| ₹0 L/yr - ₹0 L/yr |
Uber
Zomato
Swiggy
Ola Cabs