Zepto Interview Questions, Process, and Tips

Factors such as proximity to suppliers, transportation infrastructure, labor availability, and market demand are key parameters for selecting the location of a mother hub.

• Proximity to suppliers to reduce transportation costs and lead times

• Availability of transportation infrastructure for efficient distribution

• Access to a skilled labor force for operations at the hub

• Consideration of market demand and customer locations ...read more

Optimise operations by streamlining communication, inventory management, and logistics between dark stores and mother hubs.

• Implement a robust inventory management system to track stock levels at both dark stores and mother hubs.

• Utilize technology such as RFID tags or barcode scanners to improve accuracy and efficiency in inventory tracking.

• Establish clear communication channels between dark stores and mother hubs to en...read more

Design a movie booking system

• Create a database to store movie details, showtimes, and seat availability

• Develop a user interface for customers to browse movies, select showtimes, and book seats

• Implement a payment gateway for secure transactions

• Include features like seat selection, seat reservation timeout, and booking confirmation

To get customers and categories they did not purchase, use SQL query with LEFT JOIN and WHERE NOT EXISTS. To find potential new customers, analyze categories with low sales.

• Use LEFT JOIN to combine customers and categories tables

• Use WHERE NOT EXISTS to filter out categories that customers did not purchase

• To find potential new customers, analyze categories with low sales and target marketing efforts towards them