Interview Questions

Aarav G. - "Is there a reason a confidence interval was used to solve this problem over just using the mean/expected value directly?"See full answer

James W. - "I've recently worked closely with a product that had both the best and worst performing teams. The situation is that one team is struggling to deliver within a reasonable timeframe, a few stronger members of the team are carrying the weaker. Work is taking a long time. They aren't listening to each other. They aren't helping each other to get work over the line. They are getting stuck down rabbit holes. They aren't continually improving their processes. They are getting frustrated and at risk o"See full answer

Saurabh K. - "Missing Item - User ordered multiple items, few items are missing Wrong Item - Entire order is wrong / there are items in the order that were never ordered How is this measured ? CSAT Missing Items Wrong Items Step 1 : Collect data on orders that reported missing / wrong items. Dive deep to understand if the problem is isolated to a specific metro/zip code/restaurant type (say fast food vs fine dine), time of day (lunch vs dinner), tenure of the courier on th"See full answer

Raul K. - "No of Cars in 1 year = [ Total Road Length] / [Distance Covered by 1 Self Drive Car in One Year] Clarifying Question - How does Mapping work? I assume the car has a bunch of cameras and the car needs to go via a road each once to do the mapping for Google Street view. Is that correct? Assumption Google Street view required cars to go via road once and then use camera for mapping Assumption for average speed of the car - This can vary if the car is on the highway Assumption of Area of"See full answer

Vihari K. - "First, let me clarify a few points to ensure I understand the scope of the case study correctly: • Scope of Resources and Timeline: Are there any constraints on resources or timeline we should consider, or can we assume unlimited resources for this project? • Target Market: Is this tool aimed at a global market or specific regions? • Integration: Should the tool integrate with existing TikTok Shop features, or are we developing a standalone solution? • Technological Capabilities: Are there s"See full answer

FuzzyLogic - "Context Photo app || Click images, videos via mobile app (android, ios) + editing + share + upload Who are we? || Startup who wants to build accessibility apps for the disabled people Why do we want to build this app? || Current apps are not usable by visually impaired, we can bring difference & gain market share. Constraints || To launch in next 12 months Is this app exclusively targeted for blind? || Yes but regular people may also use it but not our main target group **Goa"See full answer

Takashi M. - "My approach is try to narrow down by 4W1H. When - When this happened? Still continuously happen the problem? Where - Is this happen specific region or entire customers? What - What kind of problem? One time big error or any data show the curve? Who - Is it all platform or specific platform (Web, iOS, Android) How - How serious problem? How many customer affected? Next step is to narrow down the causes is from internal factors or external factors. For internal factors: Any recent up"See full answer

Nikita B. - "Mission: Tiktok's mission is to inspire creativity and Joy. Any business wants to make sure that they are serving the value to their customers: For TikTok customers are: Viewers 2. Content Creators 3. Advertisers So few metrics we could measure are: Time spent/day Total no of videos created/day engagement rate = users who interacted in one of the meaningful action on Tiktok / total users at a day level either likes, share, watched vide for at least 5 mins, created video "See full answer

Kartikeya N. - "Clarifying Questions How do we define restaurants? Do only delivery/ pick up outlets qualify? : No. Consider only places where people can sit and eat Do restaurants within hotels count? : No Should I include cafes too? : Yes Can I assume the year to be 2024?: Yes Are we looking at specific areas within Bangalore or entire city ? : Entire city Here's how I will approach this question. I will divide Bangalore into places with High, medium and low population density. This is a relat"See full answer

Anonymous Boa - "Clarifying questions: what exactly do we mean by travel product? Travel recommendation. Travel bookings( airlines/hotels) Itinerary planning etc. Is it going to be a completely new digital product or an extension of instagram? Assuming travel product here means recommendations/bookings, and it going to be an extension within instagram, lets dwell further: Meta's vision: To make the world a closer place by offering connections; build communities. Instagram's mission: To capture , c"See full answer

Anonymous Salmon - "Product Bugs can be categorised by severity associated with them. Product Roadmap prioritization happens by MuSCoW technique, or WSJF for big ticket items. Suggestions from Leadership normally fall in expedited bucket. Overall, if there's a Scrum way of executing all priorities, then the PO and Team get together to decide the scope of the sprints for execution."See full answer

Gloriose H. - "Required output in the solution not the one requested from the question. only customerid, firstname, last_name and years were required. Please this needs to be very clear. Otherwise my answer is with totalorderyear as ( SELECT o.customer_id, c.first_name, c.last_name, EXTRACT(YEAR FROM o.orderdate) AS orderyear, COUNT(o.orderid) AS totalorders FROM orders o LEFT JOIN customers c ON c.customerid = o.customerid GROUP BY o.customerid, c.firstname, c.last"See full answer

Akshai V. - "When are you talking about Sales Is the Number of Items that have dropped or GMV dropped ? If the GMV has dropped then clearly there is a drop in the Price of Items ? Is there any category or White Goods which have lead to decrease in the Price of Goods ? Is there a Long Term Promotion running By the Marketing and not because of it ? A customer Journey in a typical Market Place is that customer adds items to car Go To E-Commerce Site -----> Search--->Add Items to Bag"See full answer

David E. - "Its enough that I shared the question. Im not going to tell you how I answered. If you dont know how to answer, then this isn't the job or company for you. Sorry."See full answer

Namu - "Provided an example from my work history where I asked to move the Go-live date to prevent launch date failure."See full answer

Brajendra S. - "Clarifying Questions and Assumption: It is a Online store or a offline store ? Assuming it is an online store There would be multiple processes, for which process the CSAT score needs to be increased ? Assuming the CSAT score needs to be increased for product search & checkout process. Does this required for Mobile App or Website ? assuming mobile app Mission & goal: CSAT score of online search process for Costco needs to be increased. User personas: Working profession"See full answer