Interview Questions

Erjan G. - "i said there is hashed, clustered, non-clustered"See full answer

Dessalew A. - "Parquet = reading only the columns you need in a spreadsheet Avro = reading full rows one at a time"See full answer

Tony A. - "The correct question is: Build a product for celebrities to engage with their followers."See full answer

onering2ruleall - "Total volume of the swimming pool, let's say it's a standard 50m x 25 m x 2m =2500 m3 = 2.5 million litter standard water horse water flow rate is 17 liter per min. So, 2.5 m / 17 =147,059 min"See full answer

onering2ruleall - "Would consider the following factors: Customer demographic and preferences Location of the warehouse and what's the local product trends Seasonality and time of the year for trendy products Balance of volume and margin products Supply chain consideration Competition analysis Inventory turn over rate eCommerce aspects of the inventory Plus the following types: Essential and groceries Electronic and entertainment Apparel and footwear Home and lifestyle Seasonal and promo"See full answer

Rajeev K. - "I’ve spent over 6 years building and scaling e-commerce products across EMEA and APAC. At Jumia, I led product initiatives on the checkout and payments side. For example, I launched gamified promotions on PDP and checkout that improved engagement and delivered a 2.3x uplift in conversion. I also introduced automated installment payments and order cancellation flows, which not only improved user trust but also reduced complaints by 30% and lowered operational costs. Before that, at Lazada, I work"See full answer

Nikita B. - "Mission for TikTok shop is to increase brand growth and sales. TikTok gives platform to these brands/advertiser to market their products via influencers/creators to be able to sell their products faster and users on tiktok platform(mainly Gen-z) are motivated to make inspirational based discovery of products and purchase them So main objective for TikTok shop could be Increase sales for diverse brands So, some of the metrics to consider would be: no of orders placed per week"See full answer

Jessie Y. - "Instagram Reels: Instagram's answer to TikTok, Reels allows users to create and share short-form videos within the Instagram app. It leverages Instagram's existing user base and social features. YouTube Shorts: YouTube introduced Shorts as a feature within its platform to enable users to create short, catchy videos. It capitalizes on YouTube's extensive content creator community and viewer base. Snapchat Spotlight: Snapchat's Spotlight feature highlights short-form videos in"See full answer

Scott S. - "Designing a Price Drop Tracker system like CamelCamelCamel involves creating a platform that tracks price changes for products on various e-commerce websites and notifies users when prices drop. Here’s a detailed system design for such a service: Functional Requirements User Registration and Authentication\: Users can register and log in. Support for social media logins (e.g., Google, Facebook). Product Tracking\: Users can add products to their watchlist for"See full answer

Faraz A. - "Scoped out problem constraints - how much data to download, how many computers, and how much time, how you can be detected (decentralized load). Designed a web crawler."See full answer

Anonymous Spider - "1) Start by clarifying your constraints - which side of the marketplace am I focusing on and what are they solving for? (e.g., minimize cost for hoster, maximize comfort for renter indoor etc.). Assuming this is a "dealer's choice" type response then proceed to step 2 2) Where to focus: which customer segment, which job-to-be-done, and why I'd start by laying out segments on 2 dimensions: urban (think big cities, downtowns) and suburban (think suburbs, beach towns, mountains) areas focused on e"See full answer