Ecom Express interview questions

Good process with things related to data and technology stack that you have worked on and the process with HR was really smooth ! Got the offer but declined it

Round 1: Online Assessment (90 mins) SQL Queries: Write a query to find the top 5 customers by shipment volume in the last 6 months. Given a table of orders and delivery status, calculate the percentage of delayed deliveries per city. Data Modeling: Design a schema to store shipment tracking data (including shipment ID, source, destination, hub checkpoints, status updates, timestamps). Coding (Python): Parse a JSON file containing daily shipment updates and load it into a structured table. Write a function to detect duplicate shipments (based on customer, date, and shipment weight). 👉 Difficulty: Moderate — more focus on SQL + real-world logistics data scenarios.