Ho sostenuto un colloquio presso Ecom Express (Gurgaon, Haryana)
Colloquio
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.
Domande di colloquio [1]
Domanda 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?
Ho presentato la mia candidatura tramite un'agenzia di reclutamento personale. Ho sostenuto un colloquio presso Ecom Express (Nuova Delhi) nel mese di lug 2022
Colloquio
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.
Domande di colloquio [1]
Domanda 1
what is candidate key and primary key.
difference in truncate and delete
joins.