Lazada eLogistics | Regional Head of Data | Singapore | Onsite | Full-time
See the full JD here: <a href=".
Apply by emailing your solution to the below filter to REDACTED_EMAIL. Please have “[your name] - Regional Head of Data - HN” as the subject line.
Technical Questions
Here (<a href=") is a simplified model of the systems used by a fictional online retailer. Their three systems track the flow of an order placed on their website, through their warehouse, and to the point of delivery. Each system uses its own database (MySQL for the shop, PostgreSQL for the warehouse, etc.). The systems communicate to each other via API calls (that are not shown here).
Please review the model and be prepared to discuss it with us. When we talk, we'll ask you how you would answer queries about this fictional business. These will be high-level questions and not deeply technical. We'll also want to hear your opinion of the model, its limitations, and how it could be improved.
1. Write a query to count the number of products across all orders received by the warehouse system today (the PostgreSQL database).
2. Given an order_id, how would you find its last GPS coordinates?
3. What do you think is the most serious problem among these systems, and why? (We are not looking for a specific answer, we want to know what you think is a problem.)
4. Why do you think this fictional company chose Redis for their delivery system, and is it a good choice?