Interview Questions

Anonymous Giraffe - "this is not a helpful interview, she seems so unprepared, confusing, unable to netting it out :("See full answer

Adrian V. - "What about sharding by Real Estate companies that are listing the homes? Because the homes can span zip codes. Then further shard by zip codes?"See full answer

Namrata L. - "NPS is the Net Promoter Score. It basically measures if the users will promote or recommend our product or not. Do we have any timelines for this? Also Amazon as in the Amazon MarketPlace right? So to improve NPS, we need to improve the customer experience and keep them more engaged. So lets focus on improving engagement. Mission of Amazon - Help users get any and everything by just clicking some buttons at their doorstep. Users Demographics - Teenagers, Young Adults, Adults, Oldies Pro"See full answer

Kevin S. - "The question given is intentionally very open ended. As the key phrases used are "air travel" which can encompass all parts of the journey not just the airport or flight experience & "improve the perception" which doesn't necessarily require fixing the problem (although you'd hope that was part of the conclusion). In addition, the constraints of time (1-year) and resources ($10M) means you must be very prescriptive. As such I think it'd be important to ask the following clarifying questions"See full answer

Mallikarjun B. - "I consider my greatest strengths to be my inquisitive nature and my ability to empathize with users. My inquisitiveness drives me to question and challenge the status quo, constantly seeking new perspectives and innovative approaches. I find inspiration in observing advertisements, analyzing their plots, and connecting them to the products being advertised. This curiosity fuels my creativity and pushes me to think outside the box. Furthermore, my empathetic nature plays a vital role in my desig"See full answer

Ridhima K. - "Youtube's mission is to give everyone a voice and show them to the world, in video format. In order to do so, Youtube is optimizing the experience for creators and consumers, and needs to add a layer of smart discovery for bringing the content to the world. Recommendation engine can be for creators- recommending what type of videos (length, genre, video size, etc) they should create for maximum viewership, or for consumers, recommending relevant videos. We'll focus on the recommendation engi"See full answer

Aekagra S. - "I'll approach this by asking questions and creating scenarios based on answers. If the answer to any questions points to a specific issue, I'll double down on that to understand the issue. This is more of a RCA question. First I'll quickly check Were there any recent updates released before we observed the drops? Assuming Yes, I'll check the updates released and check the test cases and testing results If the issue is identified, I will engage with the product leadership, update them and conne"See full answer

Himani S. - "select (case when scity < dcity then scity else dcity end) as city1, (case when scity < dcity then dcity else scity end) as city2, avg(distance) distance from city group by 1,2"See full answer

Scarlett S. - "(This is debugging, then trade off question) WAU and email open rates can be influencing each other, especially an email opened and then clicked could lead to an active user, but it doesn't necessarily mean that they have correlations or be the only reason causing changes. The approach So we definitely need to look at each cause of Why MAU goes up, and why email notification open rates go down, then develop some hypothesis on for proper cause, I'd love to gather some info to narr"See full answer

Exponent - "You should be able to easily identify this as a Measure Success question. These kinds of questions are used to test your analytical skills, as well as your ability to track project progress post-launch. Here's the strategy for tackling these: Ask clarifying questions State the goal of the feature / product Behavior Mapping / UX Flow Mapping Provide criteria to prioritize metrics Prioritize metrics Summarize Without further ado, let's dive in! Ask"See full answer

Vijay P. - "Explained in STAR format one of the project situation where I had to collect data points by deploying a minimum viable product due to unclear business requirements/dynamic nature of business. Emphasized on exact data points and how they strategically used to iteratively deploy improved version of product."See full answer

Farza S. - "It is the smallest level of significance at which the null hypothesis gets rejected"See full answer

Delyan P. - "Leadership though empathy - I helped underperforming engineer to break into product since she had great product qualities like good attention to the user.. Now she is my peer and we cross-collaborate extensively. I have earned her trust and she can go the extra mile when my team needs some support."See full answer

Tes d H. - "Here is my first shot at it. Please excuse formatting. To find the maximum depth of the dependencies given a list of nodes, each having a unique string id and a list of subnodes it depends on, you can perform a depth-first search (DFS) to traverse the dependency graph. Here's how you can implement this: Represent the nodes and their dependencies using a dictionary. Perform a DFS on each node to find the maximum depth of the dependencies. Keep track of the maximum depth encountered dur"See full answer

Sangeeta P. - "A/B testing is used when one wishes to only test minor front-end changes on the website. Consider a scenario where an organization wishes to make significant changes to its existing page, such as wants to create an entirely new version of an existing web page URL and wants to analyze which one performs better. Obviously, the organization will not be willing to touch the existing web page design for comparison purposes. In the above scenario, performing Split URL testing would be beneficial. T"See full answer