Interview Questions

Akshay D. - "SELECT u.user_id, u.user_name, u.email, ROUND(AVG(CASE WHEN b.status = 'Unmatched' THEN 1.0 ELSE 0 END), 2) AS avgunmatchedbookings FROM users u LEFT JOIN bookings b ON u.userid = b.userid GROUP BY u.user_id, u.user_name, u.email; `"See full answer

Louie Z. - "DNNs can learn hierarchical features, with each layer learning progressively more abstract features, and generalizes better. SNNs are better for simplier problems involving smaller datasets and if low latency is required."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

Mereke D. - " Before starting to answer let me gather the necessary details before proceeding: Objectives and Goals\: "What are the primary objectives of implementing the push notification system? Are we aiming to increase user engagement, drive sales, or provide timely updates?" Target Audience\: "Who is the target audience for these push notifications? Are there specific user segments we should focus on?" Platform and Device Considerations\: "Which platforms (iOS, Andr"See full answer

Kshitij A. - "The question is bit vague (I guess deliberately) so I believe firstly we shall ask questions and resolve ambiguity. Some initial questions could be : 1) Is this one time activity or something that should be done on continuous basis. If continuous basis then at what frequency. 2) How much staleness is acceptable in SYSTEM Y data 3) Are there any limitation in SYSTEM Y and is it fair to assume that we would need some kind of transformation to bring data into SYSTEM Y schema. 4) What kind of vol"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

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

Hidayat E. - "Value of Moving All Customers to the Mobile App Full Monitoring of User Behavior Gain deeper insights into customer preferences and habits. Use data analytics to identify trends, predict needs, and offer personalized solutions. Better Engagement Provide a more interactive and engaging experience compared to traditional channels. Enable gamification, personalized notifications, and targeted campaigns to keep users active. Enhanced Direct Interaction _Leverage"See full answer

Usman B. - "System Components Data Collection Layer Posts with hashtags are asynchronously sent to Kafka topics Each message contains: hashtag, timestamp, userid, postid Multiple Kafka partitions ensure scalability and fault tolerance Processing Layer Apache Flink processes streams in real-time Implements sliding window aggregation (1hr, 24hr, 7d windows) Calculates topic popularity using weighted metrics: Post count User engagement (likes, comments) Unique user"See full answer

Saisandeep M. - "Explained the charts with using Scatter Plot with Size and Color Encoding X-axis: Ride duration (in minutes). Y-axis: Total fare (in dollars). Point size: Encodes the star rating (e.g., larger points for higher ratings). Point color: Indicates whether the rating is favorable (green) or unfavorable (red). Heatmap for Correlation Analysis Why: Heatmaps are ideal for quickly identifying patterns and correlations between variables. How: Create a heatmap matrix where rows represent ride durat"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

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

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

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

Nimish J. - "The health of the product backlog can be determined by considering the following factors - Is the product backlog prioritized? Will each backlog be easily picked up by the engineering team i.e. does it have all the required details such as user story, acceptance criteria, and effort estimates? No items coming back to the product backlog from the sprint backlog due to incomplete development or bugs No of items moving to the "Done" state from the product backlog in each sprint A"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