Interview Questions

Ruth J. - "Provided an overview of IG Search and the value it provides for users Gave 3 metrics that I would consider when determining success Shared the metric that I would use as the north star Got a follow up question. If users were clicking on irrelevant results from their search would that affect your metrics and how would you deal with that Do you think it is a bad thing if users use search to search for something, get irrelevant results and perform an action based on that?"See full answer

Michelle D. - "I'd first start with confirming my understanding with the interviewer of Spotify's key metric overall. For this exercise, my working assumption of Spotify's north star is time spent listening (TSL, for short), which can be measured daily, weekly, and monthly. As the PM for Discover Weekly, I want to improve Discover Weekly such that I positively impact TSL. As such, my goal is to increase minutes spent listening to Discover Weekly playlists. The primary metric I will want to track is minutes s"See full answer

Dev S. - "Clarfying questions : When we say a decrease in users adding the bank accounts. I would like to understand how the users making payments within Venmo I assume they are either using their credit cards/debit cards? I would like to understand why the Adding of Bank Accounts is integral to Venmo since the users are using the debit card and Credit Cards. My understanding is when the payments happen through debit cards rails Venmo pays higher interchange fees and to Reduces any losses incurred"See full answer

Reno S. - "import Foundation func spiralCopy(inputMatrix: [[Int]]) -> [Int] { let arr = inputMatrix var top = 0, down = arr.count - 1 var left = 0, right = arr[0].count - 1 if top == down && left == right { return arr[top] } var ans: [Int] = [] while top <= down && left <= right { for i in left..<right { ans.append(arrtop) } for i in top..<down { ans.append(arri) } fo"See full answer

Mitchell K. - "How technical and specific do you have to go when describing your past projects?"See full answer

Steve M. - "def split_count(s): return 2**(len(s)-1) `"See full answer

Rahul J. - "Netflix Solves a problem that's mass market High importance and people actively looking for new solutions Value proposition Variety of content reasonable prices for tier 1, 2 and 3 cities Available on mobile, desktops and tablets Business model: subscription based, Revenue = f { # of users, lifetime of subscription, fee charged to user } --> Should Improve engagement to increase lifetime. User journey: Find content: Search for it / take a recommendation Watch it Give"See full answer

XponentShift32 - "solving to find a cycle in directed graph"See full answer

Dhruv M. - "During my internship at Insighta Analytics, our team was planning to prioritize a marketing campaign focused on customer acquisition through social media ads. The marketing lead was confident this would yield the best ROI based on past success. I was tasked with supporting the strategy by analyzing customer engagement trends. But as I dove into the data, I started to question whether the current direction was the best use of our budget. I analyzed customer conversion data from the last two quart"See full answer

Jaime A. - "I would avoid converting order_date WITH monthly_totals AS ( SELECT department_id, SUM(CASE WHEN DATETRUNC('month', orderdate) = '2022-11-01' THEN orderamount ELSE 0 END) AS novtotal, SUM(CASE WHEN DATETRUNC('month', orderdate) = '2022-12-01' THEN orderamount ELSE 0 END) AS dectotal FROM orders WHERE order_date BETWEEN '2022-11-01' AND '2022-12-31' GROUP BY department_id ), mom_increases AS ( SELECT "See full answer

Nithesh S. - "First, let us start with the mission of Amazon: “We strive to offer our customers the lowest possible prices, the best available selection, and the utmost convenience.” Alignment of recommendations system with Amazon's mission: Suggesting recommendations to the users would be a part of this mission as it would allow users to buy things on their mind for the lowest cost in market (may or may not be true). They might get better prices if they order adjacent items together. For example, i"See full answer

Kim L. - "Explore expanding beyond just two small roooms-- bigger rooms or a third room? Get insights from those who are teleporting about what the experience is like"See full answer

Sumeet R. - "Got a very different answer than everybody. I seem to be off here. But here goes ..will appreciate feedback Clarifying ..all human population in US and not just working population? Yes US Population: ~300Mn Segmenting Population. 0-19 - 75M 20-40- 75M 41-60 - 75M 60-80- 75M 80-100 - 5 Mn Removing 80 segment as stay at home and not eligible for commuting Revised Table 2-19 - 75M 20-40- 75M 41-60 - 75M 60-80- 75M Out of this employable audience that is has"See full answer

Scott S. - "To recount an experience from my last project . We were at the initial stages of designing a new data platform to enhance our trading analytics capabilities. The conflict arose over the selection of a data processing framework. I was advocating for Apache Spark due to its scalability and performance benefits, especially for handling large volumes of derivatives data. Another senior team member preferred a different technology they had more experience with, which they believed would be easier to"See full answer

Aimable - "."See full answer