i
Zomato
Filter interviews by
Clear (1)
I applied via Campus Placement and was interviewed in Aug 2024. There were 2 interview rounds.
Aptitude
SQL MCQ
SQL query -4
On hacker rank - 90 mins
Developed a project to optimize production processes using data analysis
Implemented statistical analysis to identify bottlenecks in production
Utilized machine learning algorithms to predict equipment failures and prevent downtime
Collaborated with cross-functional teams to implement process improvements
Generated reports and dashboards to track key performance indicators
Hacker rank 30 ques aptitude 3 ques sql and one ques python
I applied via Campus Placement and was interviewed in Apr 2023. There were 3 interview rounds.
Simple aptitute question based on mathematics based
What people are saying about Zomato
I applied via Referral and was interviewed before Apr 2021. There were 3 interview rounds.
Basic sql
I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.
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...
I was interviewed before Nov 2019.
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
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...
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...
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...
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
I applied via Naukri.com and was interviewed in May 2024. There were 2 interview rounds.
Basic aptitude test which is easily done
Joins are used to combine rows from two or more tables based on a related column between them. Window functions perform calculations across a set of table rows that are related to the current row.
Joins are used in SQL to combine data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Window functions are used to perform calculations on a set of rows rela...
Use Excel functions like VLOOKUP or INDEX/MATCH to derive results from SQL queries in Excel.
Use VLOOKUP function to search for a value in a table and return a corresponding value from another column.
Use INDEX/MATCH function to perform a two-way lookup by matching values in two different ranges.
Import SQL query results into Excel using data connection or copy-paste method.
based on 4 interviews
Interview experience
based on 2 reviews
Rating in categories
Key Account Manager
928
salaries
| ₹0 L/yr - ₹0 L/yr |
Delivery Boy
893
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Analyst
588
salaries
| ₹0 L/yr - ₹0 L/yr |
Accounts Manager
296
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Associate
273
salaries
| ₹0 L/yr - ₹0 L/yr |
Swiggy
Amazon
Dunzo
Flipkart