Interview Questions

Zacharias E. - "SELECT pro.id, pro.title, pro.budget, COUNT(employeeid) AS numemployees, SUM(e.salary) as total_salaries FROM projects pro JOIN employeesprojects ep ON ep.projectid = pro.id JOIN employees e ON e.id = ep.employee_id GROUP BY project_id; `"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

Dr. chantel P. - "Currently, I work in banking fraud detection. Recently, my teammate and myself were asked to assist the Check Deposits team in enhancing their fraud detection ML solution by evaluating new data sources and eliminating past data sources for possible lift. We retrieved data from Hadoop and Netezza databases including deposit transaction data, mobile & computer device, authentication logs, account balance, and customer demographic data. We then created new and recreated old features including tem"See full answer

Anonymous Flamingo - "As a product manager, my first step in designing a free product would be to define the product's target audience and the problem it aims to solve. Once these factors are established, I can then determine the best way to monetize the product. One way to monetize a free product is through advertising. This involves displaying ads to users as they use the product, and earning revenue based on the number of clicks or impressions the ads receive. This model is commonly used by social media platforms,"See full answer

Harsh W. - "Me: That's an interesting challenge. I would like to get some clarifications before jumping into potential solutions. Are we talking about the global search market irrespective of device or are we talking about a specific geography / device type? Interviewer: Lets go ahead with all possible searches. Me: Ok. Is there a specific reason we want to capture a significant market share from Google (e.g. higher search revenue, cross-selling MSFT services etc.) and are there any timelines we should k"See full answer

Rustam - "There are number of ways where an app could lose users. I would try and speak with the following teams to figure out the issue. Data Team - I'd ask data team to see if there are any drops in the existing game funnels. There could have been an issue in game design. Potentially players could have gotten stuck on a super hard level and left or flew through a puzzle that was too easy, and also left. Essentially, figuring out the progression curve of the game, which often times can lead to play"See full answer

Anonymous Sparrow - "Clarifying question: how does Uber know that this is happening and has there already been research as to why drivers are doing this? Approach: Understand the problem and how big of a problem is it? Is it a big enough problem to address given other competing priorities? Given the why's both for drivers and riders, ideate solutions to both drivers and riders Prioritize solutions Measure of success Summary Propose the approach above and solicit feedback from interviewer, incorporat"See full answer

Anonymous Flamingo - "Handling projects out of my expertise: When faced with a project that falls outside of my expertise, I take the following steps: Identify my skills and knowledge gaps: I assess my own strengths and limitations, and determine which areas of the project may be outside of my comfort zone or expertise. Seek guidance and mentorship: I reach out to colleagues or subject matter experts who have relevant knowledge or experience, and ask for their advice and guidance on the project. Learn and adapt"See full answer

Kiley S. - "Measure Success of FB rooms. First I would like to clarify my understanding of the product: FB Rooms is a video call product similar to zoom in which a user can create a room and then invite people to join either with Facebook, if they are already friends or with a link or invite. Able to use filters and virtual backgrounds Now that we have aligned on the understanding of the product, I would like to think about the goals for the product. Goals: Business goals: Rooms was FB’s"See full answer

Asset T. - "Ask clarifying questions: There are a few different products within Coinbase platform - Coinbase, Coinbase Pro, Coinbase Wallet. Which one would you like me to focus on? Let’s assume it is Coinbase main app Coinbase has both desktop and mobile apps - is it ok if I focus on one of them first, and if time permits, extend it to another? Let’s assume we focus on the mobile version Coinbase is available in 100+ countries, can I focus on the US version? Let’s assume yes. Is"See full answer

Takashi M. - "Me: First of all, I’d like to have some clarification about this project. Me: What is the current product line design of the vending machine? Is this a traditional vending machine? Customers pay money cash or credit card, and select products and receive the product. Interviewer: Yes, that is the correct assumption. We make vending machines for canned drinks and bottled drinks. Another product line is for selling small packaged snacks. Me: What is the goal of this project? Is"See full answer

Prabhav G. - "Assumptions and Clarification! What kind of blind person are we talking about ? Are they partially blind? Color Blind? Can Detect Light ? Can See blurry Images? Is the Blind person an adult, elderly or a teenager? Do they have any additional disabilities? Where will this Iron be used? At home? or perhaps one for travel? Do we have any limitation of resources? Assumptions- We are talking about a Complete Blind person who cannot see anything at all i.e Zero ability to se"See full answer

Sarabjeet S. - "Goal of YT search is to enable quick access to a video of interest to user. So success for YT search would mean access to videos that interest, and user actually clicks on one or more searched videos to watch them. It also means reduced time searching overall, with high relevance results shown for search string. Actions performed by users are: Goes to the YT site or Mobile app Clicks on the Search window to type Enters search string and presses enter Browses the list, scrolls"See full answer

Vlada J. - "Adding to what Zoe already mentioned: running a user study with existing customers to understand if they see the proposed design as favorable running AB testing with users to compare two different designs and decide which one is more favorable (based on a previously determined metrics)"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