Interview Questions

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

Bryan L. - "with var1 as (select players.playerid as playerid, player_name, team_id, score_id, max(scores.gamescore) as gamescore from players join scores on players.playerid = scores.playerid group by players.player_id) select teamid, playername, max_score from (select team_id, player_name, gamescore as maxscore, denserank() over (partition by teamid order by gamescore desc) as scorerank from var1) where score_rank <= 2 order by teamid, scorerank asc `"See full answer

Aman M. - "Apoorva Tai is the best. Wash-off effect can be applied on switchback if 1-hour time-block is persisted with, where the first 10-15 minutes of a switchback is ignored"See full answer

Hans - "Described a bug I found on an app designed for a specific make of tablet. In this sequence I described: The app the bug was found in The priority and severity of the bug That it was a regression to an existing working piece of functionality The hardware and the firmware on the device the bug occurred on The steps that led to me finding the bug and how it manifested itself Talked about how we debugged from the point of view of: Code Component Deployed application Comparison to"See full answer

Mitchell K. - "How does team matching and Bootcamp work for PMs?"See full answer

Zakery K. - "I told a story about having good intentions to help out a superior with a problem but I did so without seeking buy-in (permission) first. While I did solve the problem and provided value to him and my other colleagues, I was reprimanded for crossing boundaries and not respecting his privacy (I accessed his computer without his permission to deliver a resolution to a problem). While I had good intentions and the outcome was good, my approach left me with a negative mark and a life long lesson r"See full answer

Rajeev K. - "Here's how I'd approach investing that $10 million over the next year and a half. The biggest chunk about $4 million would go straight into our core infrastructure because that's what everything else depends on. We're seeing massive demand for real-time payments, so I'd put $2.5 million into building instant settlement capabilities and integrating with FedNow and RTP rails. The remaining $1.5 million would beef up our platform scalability because we're hitting capacity limits during peak times,"See full answer

Exponent - "This is an Improve a Product question. Let's first go over the Improve a Product formula: Ask clarifying questions Identify users, behaviors, and pain points State product goal Brainstorm small improvements Brainstorm bolder improvements Measure success Summarize Now, let's begin! Ask clarifying questions Before we begin listing off recommendations, it's important you ask questions to ensure you and the interviewer are on the same page"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

Vishal S. - "Product Understanding - Push notifications are pop up notifications received on the device (phone, tablet etc.) sent by various Meta apps whenever a new post has been made or a new message is received Clarifying Questions - Is is specific to one device? Is it specific to one product? Is it specific to one region? Is it specific to one OS? Is this as a result of changes to algorithm/UI? Existing or a new feature? Assumptions - KPI calculation will only be for users who h"See full answer

Nr 9. - "Assumptions: The question is for a PM working for a refrigerator startup company and for a domestic refrigerator (not industrial). The first model comes in the most commonly used form factor with fridge/freezer split, and it has standard cooling specifications. Target market is the US. The startup is for profit. Product goal: To make interacting with refrigerator easy, seamless and pleasurable for the blind. Target users and channel partners: Fully blind people between the ages o"See full answer

U K. - "Additional of COVID disclaimers to COVID related reels in instagram has helped users to navigate the crisis effectively as well as get the facts addressed regarding the vaccine."See full answer

rkk293 - "How would you increase the number of comments on groups?"See full answer