Instacart·Data Scientist·Onsite - System Design / Architecture
- Design a product catalog system for a large e-commerce platform supporting 100M+ products, with search, browsing, inventory, pricing, and internationalization.
- How would you keep the search index in sync with the product master database at this scale?
- Walk me through your caching strategy for product pages, including how you'd handle cache invalidation when a product is updated.
- How would you handle inventory consistency, specifically ensuring stock levels are accurate during high-concurrency checkout scenarios?
- How would you design the API layer for browsing and search, including pagination for large result sets?
- How would you support internationalization across product titles, descriptions, images, and pricing for different locales and currencies?
“This is basically the whole interview wrapped into one prompt.”