Interview Questions

Tim F. - "One project that stands out involved building a customer segmentation dashboard for our marketing team using Power BI. The goal was to help them target campaigns more effectively by segmenting customers based on purchase behavior and demographics. Early in the project, I noticed significant data quality issues in the source tables coming from our CRM system. There were missing values in key fields like customer age and region, duplicate customer IDs, and inconsistencies in how product categories"See full answer

Sri A. - "Success for Yelp reviews. (assuming these are standard reviews posted by customers, for a restaurant or bar or a cafe listed on Yelp. Has a 5-star calibration that users can enter and free-form text.) Select Metrics should span the entire funnel across adoption, engagement, quality, and overall impact for Yelp. Adoption metrics: Total # of reviews written, Avg reviews/ listing Engagement metrics: # reviews being scanned, marked as being useful, etc. Quality metrics: %ge of disputed"See full answer

Ben G. - "Situation - A time I had to think “outside of the box” was while I was at Google working on hotel solutions for smart displays. Smart displays are mutli-modal meaning they accommodate both touch and voice. I was given the task of leading the effort of scaling a new third party solution on top of our existing first party design system. However, the pandemic caused an unfortunate turn of events in that the needs of guests changed drastically and now needed a much more voice forward solution for"See full answer

Peter W. - "In the question it says: "above the overall average total posts", which to me implying a >, yet in the solution it uses >= Caused me 1 hr to find out. plz fix"See full answer

Ankita S. - "let's say I'm working on a social media platform and considering implementing a new feature: "Reactions" to posts, similar to Facebook's reactions (like, love, haha, wow, sad, angry). Here's how I would conduct an A/B test for this feature: Define goals and Identify the feature: Goal is to increase user engagement and provide more nuanced ways for users to express their reactions to posts.The feature I want to test is the introduction of "Reactions" buttons alongside the traditional "Lik"See full answer

Manish G. - "When the COVID influx started to flow through hospitals, there were a lot of questions and no time to find solutions. So we set up a command center to manage the flow of issues, triaged them appropriately, and mobilized teams to find quick resolutions. We had to escalate quickly and effectively to find quick resolutions. The team had to rotate the leadership of the command center to avoid burnout due to working round the clock and in unconventional ways to manage the workload. For example, we ha"See full answer

Ekta M. - "Some clarification questions On a very top layer these are the building blocks of the Quick Commerce companies. Let me know if you wanna deep dive in any specific. Users - browses the catalogue and selects the items that they wanna buy. Dark Store - This is where the catalogue is stored i.e. the items to be ordered. Imagine this to be a huge super store but only the delivery executives are allowed to shop in their. There are multiple of these dark stores, when you enter your address you get"See full answer

Adib M. - "Any answer after this video won't compare. Not an expert. With that caveat out of the way, here is my answer I'd break this work into different phases = Discovery Phase, Planning Phase, Execution Phase, Monitoring phase, Ongoing Discovery : How many Products does this enterprise have? Are we talking about internally developed Products that we sell in the market place? or also third party Products that our enterprise has purchased for internal use? Should we include Operating Systems, net"See full answer

Mayank S. - "[2:53 pm, 02/12/2021] Mayank: Before we deep dive into brainstorming the solution I go ahead and make few assumptions for clarifying questions: Step-1- Framing a problem 🎯Why users go to gym? To relieve stress by doing exercise To maintain their body To reduce their weight To remain active To make good physique 🎯Who goes to gym? Couples Group of friends Individuals Here we are trying to design high tech gym so it means we are looking to create good experience-and"See full answer

Aditya S. - "I told a story about how our team was focussed on moving a key metric i.e. NPS and to do that we build 3 top requested user feature. Post release the detractors % didn't move even though the detractors request for features shipped went down. Then I connect with users and did some analysis post which we realised that we need to pivot our focus from shipping features to enabling complete workflows for our users i.e. shipping all those feature which are used together in a feature as then only users"See full answer

Sunflower - "Can you clarify how we define cyberbullying? To me, it means negative or abusive content targeted towards an individual or a group. This can be in the form or text or media. Lets talk about Reddit as a product: To enable positive discussions on diverse topics. Did I miss anything here? Lets talk about users here: We have: Teenagers: 13 - 19 years old Millennials: 20 - 39 years old Gen X and Baby Boomers: 40+ I think teenagers are the most vulnerable and the highest priority group for this use"See full answer

Saurabh K. - "Goals : Determine if the TV series should be renewed If it should be renewed, how much should Netflix be willing to pay for this series Let's assume that the goal is to maximize subscriber retention and engagement while paying a reasonable amount for the licensing costs that is justified by the value added by the series. Assumptions : The show is exclusive to Netflix for a particular region (for eg. US) It has been on the platform for an year Netflix has subscriber level data around"See full answer

Clayton P. - "I've watched all the ML Systems designs interviews and this solution provides a clean baseline for predicting ETA using historical averages, but it falls short of addressing the broader problem of route planning. The system predicts ETA for a given segment and time interval, but it doesn’t explain how to compute the ETA for an entire route or how to integrate this into dynamic path selection. It also lacks depth on handling real-time data, adapting to distribution shift, or reacting to sudden"See full answer

Curly T. - "One thing is not clear to me, We encoded the length of the word to a character, but the max number which can be converted to char ascii is 255. How will it work for length till 65535?"See full answer

R K. - "Clarifying questions: Can we pick any business product across CapOne spectrum? any preference? - Assume pick any Are there any specific geographies you'd like to focus on? Are there any specific customer segments you'd like to focus on? Are you able to provide any information on the market/competitive analysis? Or I can just make reasonable assumptions along the way. Confirming we care about revenue? not profit per customer? Lay out the framework: I'd like to focus on the followi"See full answer

Vaishnavi T. - "During my time as a Product Manager, we were preparing for a major product release with a tight deadline and discovered that implementing both a new feature and crucial performance improvements wasn't feasible within the timeframe. So, I organized a meeting with stakeholders to assess the impact of each option. We analyzed user data, projected ROI, and considered long-term product strategy. Ultimately, I decided to prioritize the performance improvements. As a result, the product launched on tim"See full answer

Uttam R. - "Clarifications ( Assuming this a technical question ) What is the purpose of this News feed ? Do we have a specific platform in mind ( Assumed Android phones ) Focus user group - People who use News feed a lot Business goal - Provide fresh and engaging content. Basic functionalities of news feed: News feed - A space where articles is collated and presented to the user Organise content. Customise news feed based on reading patterns. Push down older content. Keep the reader"See full answer