Interview Questions

Alok S. - "Functional Rquirements: User should be able to read account balance user should be able to withdraw money from account user should be able to add money to account user should be able to create a new account user should be able to cancel an opened account All of the above for Checkings and Savings account User should be able to pay credit card bill (similar to adding balance to checking and savings account) Non functional Requirements: ACID transactions. consistency > availabi"See full answer

Matan S. - "What are your top 3 favorite apps? (after picking one) How would you improve it? YNAB - You need a budget Robinhood Chase How would you improve YNAB? Clarifying questions What's my role? I'm a product manager at YNAB Why do we want to improve YNAB? Is there any specific goal? Structure YNAB - I'll share some information on YNAB Ynab's mission is to create the best budging app and empower people to gain control over their money and their life. Ynab's business model is a"See full answer

Anonymous Newt - "CQ: Goal - connect two large continents, reduce the distance Is it a motorable bridge -? Any specific use case on mind? Summarise: come up with the use cases of the bridge Google’s mission -> organise world’s information and make them more accessible and useful A bridge that way is a great way to reduce the distance between two large separate continents. This bridge can help spread information faster Possible Use cases of the bridge: Transportation of physical goods: Since road tran"See full answer

Priyansh J. - "By increasing the number of paid users, I assume we mean that we want to increase the % of DAUs who pay for YT Music. First, we need to understand the Youtube Music play here. Youtube Music was carved out of Youtube because Spotify and Apple Music were getting popular. Users were listening to music on Spotify instead of on Youtube, threatening ad revenue for Youtube. Therefore, Youtube Music was born as a standalone app, where users could listen to the music ad free from anywhere anytime. In"See full answer

Victor N. - "--country names are UPPERCASE but the table in the in the question showing lowercase. That's why it took me a while to figure it out until I ran the country column WITH RECURSIVE Hierarchy AS ( SELECT e.Emp_ID, CONCAT(e.FirstName, ' ', e.MiddleName, ' ', e.LastName) AS FullName, e.Manager_ID, 0 AS Level, CASE WHEN e.Country = 'IRELAND' THEN s.Salary * 1.09 WHEN e.Country = 'INDIA' THEN s.Salary * 0.012 ELSE s.Salary "See full answer

Cj K. - "Clarifying Q Is the search traffic meaning # visits clicked through the 'search' button from the homepage(search CTR)? or does this include # pages viewed after the search result pages (search depth)? Hypothesis I believe introducing Gen AI as a default feature on the Google's search box will increase #search traffic. I assume the biggest user pain point within current google homepage is that deciding on a keyword for search. Unlike other alternative platforms such as"See full answer

Daniel L. - "You're the PM for all of Instagram Stories. What is your North Star metric? Meta's Mission: Give people the power to build community and bring the world closer together. IG's Mission: To capture and share the world's moments User Types Marketplace / 2-sided ecosystem Creators and the Consumers Metric Categories Adoption Engagement Retention [not pictured]: create a table with 2 columns: Creators and Consumers and 3 rows: Adoption, Engagement, Retention. Talked through and priori"See full answer

Saurabh G. - " Company Goal: Make quality service at competitive price available for customers and enable contractor to maximize income sources Clarification: Post Booking Experience is the user flow from the point a booking is confirmed to the time the service is delivered to the customer. Metric: CSAT and Orders successfully completed Personas: Customer, service provider, business USER JOURNEY Customer (User Journey) Booking confirmed on portal Add to calendar Email / text con"See full answer

Krishnan S. - "Excellent job Roshan, really liked the explanation. Which software were you using to explain the system design diagrams?"See full answer

Amparo L. - "One weakness of mine is reaching stuff through higher shelves but I'm able to use a step ladder to address the situation."See full answer

M N. - "What is rider cancellation? Is it a rider requesting a ride but hitting the cancel button after the driver is on their way? Yes. I can see why it's concerning since that affects our # of completed rides and driver earnings. Let's try to understand the root cause. Rider cancellations have increased in what time period? We noticed it last week. Was it slowly dropping for a while or did we notice it only last week? It was a sudden drop last week How did other metrics behave last week? For eg,"See full answer

Harshita G. - "Is the "idea" I'm trying to sell something new or built off an existing service/product we offer? Interviewer: Let's assume new. Assuming it's a proper sit-down meeting with senior management to go over the proposal, here is what the slide deck would contain. Introduction/Description of the problem I'm trying to solve: Before proposing a solution, it is important to first identify the problem we're trying to solve. This section would contain the description of the problem/pain poi"See full answer

Bg - "Clarifying question: Am I the first one to notice the fire, or there are people already on it? Extent and source of fire - I am assuming it's localized and I am inside the data center, safe so far. Response: It is an emergency. I will do and coordinate the people to do the following in parallel, if I am the first one to know. Get immediate attention of folks in the data center. Get someone and many people to call 911 and security. Coordinate to have people in need evacuated. Turn off th"See full answer

Saurao D. - "How many shampoo bottles are sold in the US annually? Assumption: Shampoo for both male and female consumers Population of US (330Mn) Considering 50:50 Urban Rural breakdown Urban: 165Mn Rural: 165Mn Considering only 10% of Rural consumers will be using shampoo, which gives 16.5Mn people Urban: 165Mn Considering 50:50 Male Female breakdown Male: 82.5Mn Male consumers using shampoo: 60% = 49.5Mn Male consumers not using shampoo: 40% = 33Mn Female: 82.5Mn Female consumers using shampoo: 80%"See full answer

Sh R. - "i responded using a multi sourced BFS and in place marking, then i checked the final grid to see if any free spots were left unmarked."See full answer

Anonymous Krill - "Clarify the question. Any specific system? Will study the related systems in the environment. Will define the goal, attributes of the system, stakeholders expectations, problems this system is going to address in case these things don't exist already. With the above two steps, I Will come up with a draft of the System KPI. Will run it with leadership, stakeholders and will incorporate feedback. In parallel, will come up with quantification on these performance factors. Fina"See full answer

Shashikant A. - "I followed STAR format"See full answer

Sergio C. - "Clarifying questions is there a main reason why we want to improve it? For instance: active users declined monetization declined performance issues customer complaints (Based on this clarifying question the following answer could be any to be honest. if the interviewer says that it's an open questions, then I would go to the product design framework) Assumption Based on the impact that we would like to do, 1) I would assume that we are looking to improve the messaging experi"See full answer