Interview Questions

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

P K. - "Clarifying questions, Before I begin, I want to make sure I understand what the product is. FB fundraiser is a platform for entities (charitable organizations) and individuals to create fundraising campaigns, invite certain users to it, share it with others and ask them to invite potential contributors to it. It is also part of the core facebook product. The approach I want to take about defining goals is as following: Define the mission of FB as a company, goal of fundraiser p"See full answer

Balaji G. - "My Answer. Please let me know your feedback. I have led many projects throughout my career. So, whenever I lead the project, I first try to clarify the goals and values delivered. For example, I was in charge of Data Analytics projects at my employment at a Startup. The team’s goal was launching the MVP. First, I discussed with the CEO to define the clear goal and scope for each of the projects. Next, I identified all the key stakeholders and received their inputs on the project's different a"See full answer

Meenakshi sundaram M. - "Structure: 1. Ask Clarifying Questions 2. Look at external factors 3. Look at Internal factors ( Slice the data aross different cuts and plan accordingly) Clarifying Questions: What's an outbound message? Is it something Linkedin users send among each other? Decline trends: Is the decline steep or gradual? From when, are we seeing this decline (Say since a week, fortnight, month, etc) External Factors: Have we seen any competition led changes/ new campaigns etc? Have we see"See full answer

Kapil D. - "Overall a very good summary of ranking problems. I wish there are more details in the post on depth of modeling. One can talk more about advance ML architectures like DCN, BertRec etc"See full answer

Pm P. - "Clarification: Are we talking of Amazon as an entity in whole (or) Amazon E-commerce ? I would like to use overlap across following buckets with emphasis on current product & markets, Future adjacencies and expansions, strengths barrier to entry in the markets either way Amazon Intuit Products - Considering Amazon as a whole - Devices - AWS - E-Commerce - Music - Video - E-Books - All other services, currently there is no overlap between the use-cases and services offered"See full answer

Manas M. - "Couple of Clarification Questions to be asked are: Aim of the physical product Retention/Encourage Loyalty Attract new customers Collect customer Data outside of the Airbnb ecosystem for better advertising and customer focus User Base of Airbnb Solotravellers - traveling to new places for exploring/solo travel Business Travelers - Lot of business Travelers who own small/medium businesses and book their own travel can choose airbnb Family gr"See full answer

Dan H. - "Assumptions Instacart for Business is core Instacart with additional features and capabilities tailored to businesses. Users Potential user segments: Office managers (Focus here) Entrepreneurs/small business owners Restauranteurs Opportunities (pain points, needs, problems) Many places don’t offer same-day shipping. Inconvenient to physically go out and purchase these items from a store if urgent Hard to predict an"See full answer

Snighdha G. - "By showing results that I have achieved by taking that action because seeing is believing. For example, when we had issues with our child's behavior and wanted to understand what as parents we are doing wrong, we went and sought help from a specialist and similarly advised same to others having some form of mental health issues to seek help since we benefitted with it a lot."See full answer

Adhitya G. - "Clarifying Questions: Product → It is a online Professional Services platforms where jobs are made much easier for both recruiters and for job-seekers Goal → Increase Number of Users/ Any other Business Goal? Mission → It is to make job-posting/seeking completely hassle free and accessible to everyone. Do we have any timeframe to do this and is there any growth rate that I should be targeting? - 5x in 5 years Students → Are we focusing on Full-time or Part-time students? Any"See full answer

Miguel C. - "Missing launch. Only design is covered."See full answer

Bini T. - "I understand this is more focused on ML. However, I have a system question. If users allow us to access their location, or they send location via text box, could we use CDNs for the search without hitting our database? We only query the database when we have zero information on location. Other questions: does embedding always guarantee information on location? Do we discharge the user images after we return a prediction? I heard the feedback that we should keep it for future learning. What would"See full answer

Scott S. - " A couple of years ago, we were working on a project to integrate a new third-party data feed into our existing data processing pipeline. This data feed was critical for enhancing our trading algorithms with more comprehensive market data. Given the tight timeline and high stakes, I decided to push for a rapid implementation. In my eagerness to meet the deadline, I underestimated the complexity of integrating this new data feed. I did not allocate sufficient time for thorough testing and valida"See full answer

Dhruv M. - "During my internship at Inceptra Analytics, our team was working on improving the monthly reporting process for the operations department. I proposed switching from manual Excel reports to a Power BI dashboard to automate and visualize key metrics. However, some team members were hesitant—they felt the current process, although tedious, was more familiar and controllable. My task was to get buy-in from the team to adopt a more efficient reporting method without causing disruption or resistance."See full answer

D S. - "Estimate Google ads revenue. Clarifications: Google ads: only includes ads shown on Google search pages. It does not include any other ads such as display advertisement etc. Google makes money everytime a user clicks on an ad. Market - US Monthly / Yearly - Yearly Revenue in $ For 2020 ? - yes So to state the Q again, I have to estimate Google’s annual search ads revenue for 2020. Ads revene =( $ads clicked everyday * avg price per ad ) * 360 $ads clicked every"See full answer

Praful B. - "The customer's business needs and requirements. The technical aspects of their legacy system. The budget and timeline constraints. The risks and mitigation strategies. The customer's specific concerns. Assess the feasibility of migrating their legacy system to the cloud - This will involve evaluating the technical aspects of their legacy system, as well as the business impact of the migration. Develop a migration plan -This plan should outline the steps involved in migrat"See full answer

Dan D. - "I love the answer and framework, my summary of the interview: it is a slightly modified version of Porter's 5 Forces: User benefit -> Bargaining Power of Buyers Apple benefit -> Talks about the company mission and culture (esp. on the relatively closed eco-system) It was expanded more in the latter half of the interview (SWOT + a bit of Value Chain) Competitive landscape -> Industry Rivalry + Threat of New Entrants + Threat of Substitutes Partnership Impact -> Bargaining Power of"See full answer

Bradley E. - "Here's a simpler solution: select u.username , count(p.postid) as countposts from posts as p join users as u on p.userid = u.userid where p.likes >= 100 group by 1 order by 2 desc, 1 asc limit 3 `"See full answer

Sri A. - "Mission: to help users buy and sell products from groups. If we think about the value here, users want to join groups that sell/buy products of interest (young moms or vinyl), or location of interest, or trust, or some other factor - either from other users or SMBs. User Actions: create groups, join groups, active in groups - make posts to sell or show interest in buying (like, commenting, sharing or ideally transacting) deeper engagement - sharing , saving , searching more based on wh"See full answer

Ben G. - "Situation - A time I dealt with conflict while on a team was while I was working at Shopify on physical and digital gift card refund point of sale solutions. The situation was that we were dealing with complex technical constraints including not changing particular UI components behavior to act as they should be intended. On the refund screen, the existing design was using a toggle on the same screen to bring up a modal for gift card selection to either select digital or physical options. Thi"See full answer