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.
Interview questions [1]
Question 1
How would you build a pipeline to ingest GPS tracking data from trucks (streaming) into a warehouse?
Which AWS/GCP services would you use for ingestion, storage, and querying?
I applied through a staffing agency. I interviewed at Ecom Express (New Delhi) in Jul 2022
Interview
they have scheduled my round with one of the data science professional. at the time of interview he came to know that okay you don't have exp in data science domain. He asked someone on video call to take my interview and that interviewer is totally unprofessional.
he doesn't even know what he is asking and is debating with the answers I am giving and is ignoring and saying that this is not possible. It is incorrect, etc. Then after wasting 20 mins he told me that okay we will schedule another round and in next round two panelist were there one is not able to speak English and other one is totally unprofessional. They were asking some set of questions and keep on repeating that after 5 mins. I kept on saying that i have already told you the answer.
I don't know what sort of behavior they are carrying.
Interview questions [1]
Question 1
what is candidate key and primary key.
difference in truncate and delete
joins.
