Zepto Interview Questions, Process, and Tips for Experienced

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

Experienced logistics and warehousing professional with a proven track record of optimizing operations and maximizing efficiency.

• Over 10 years of experience in logistics and warehousing management

• Skilled in inventory control, supply chain management, and process improvement

• Implemented new warehouse layout that reduced picking time by 20%

• Led team in achieving 99% on-time delivery rate

I have over 5 years of experience in managing logistics and warehousing operations, including inventory control, transportation coordination, and team supervision.

• Managed inventory control processes to ensure accurate stock levels

• Coordinated transportation logistics for timely delivery of goods

• Supervised a team of warehouse staff to optimize efficiency and productivity

• Implemented new warehouse management systems to imp...read more

One of the big challenges in today's logistics industry is optimizing last-mile delivery for efficiency and customer satisfaction.

• Increasing consumer expectations for fast and convenient delivery options

• Rising costs associated with last-mile delivery due to factors like traffic congestion and labor expenses

• Need for innovative solutions such as route optimization software and alternative delivery methods like drones or

Reducing Cost Per Order (CPO) involves optimizing processes, enhancing customer experience, and leveraging data analytics.

• Streamline operations: Automate order processing to reduce manual errors and speed up fulfillment.

• Enhance marketing strategies: Use targeted advertising to reach the right audience, reducing wasted spend.

• Improve customer retention: Implement loyalty programs to encourage repeat purchases, lowering a...read more

Calculate the number of riders needed for 1900 orders at a rate of 2.2 orders per hour (OPH).

• Total orders: 1900

• Orders per hour per rider: 2.2 OPH

• Total hours needed = Total orders / OPH = 1900 / 2.2 ≈ 863.64 hours

• If one rider works 8 hours a day, then total days = 863.64 / 8 ≈ 107.96 days

• To find the number of riders needed, divide total hours by hours worked per rider.