Interview Questions

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

Jessica C. - "select customer_id, order_date, orderid as earliestorder_id from ( select customer_id, order_date, order_id, rownumber() over (partition by customerid, orderdate order by orderdate) as orderrankper_customer from orders ) sub_table where orderrankper_customer=1 order by orderdate, customerid; Standard solution assumed that the orderid indicates which order comes in first. However this is not always the case, and sometime orderid can be random number withou"See full answer

Shahrukh K. - "During my initial days as a Product Manager, I faced challenges working with our central design team. The team received requests from multiple Product Managers, and prioritization was often influenced by the rapport each PM had built with them. Since I was new, I struggled to convey the importance of my tasks effectively, leading to delays in my projects. This was a significant learning moment for me. I realized that to succeed, I needed to earn the trust of the design team and demonstra"See full answer

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

Anonymous Salmon - "Situation Action Result"See full answer

Nithesh S. - "First, let us start with the mission of Amazon: “We strive to offer our customers the lowest possible prices, the best available selection, and the utmost convenience.” Alignment of recommendations system with Amazon's mission: Suggesting recommendations to the users would be a part of this mission as it would allow users to buy things on their mind for the lowest cost in market (may or may not be true). They might get better prices if they order adjacent items together. For example, i"See full answer

Jagan M. - "This system design question is very small compared to other questions like design instagram, twitter, google drive etc... Since the design involves less components the level of detail we have to go in them were deep. I had to explain how to deal with all the NFR for the distributed cache system. Whether it is a push model or a pull model. Hade to do BOE calculations for the database too."See full answer

Beginner P. - "Skeleton: Mission Metrics to improve User segments & the segment with most impact User journey Pain points and opportunities Features/solutions & prioritization Starting with Twitter's mission, "the power to create and share ideas & information without any barriers", we are looking to empower people to be both consumers and generators of content. Are these users interacting with Twitter on the website or the mobile app? [Clarifying with interviewer, who answers mobile app.] "See full answer

Julien C. - "👇 Your feedback is very much appreciated 👇 Defining metrics: Activation Mobile downloads New user registration Retention and Engagement Nb messages sent Average nb of contacts per user Nb groups Monetization CAC LTV ARPU MRR Prioritizing: What matters most for WhatsApp right now is Engagement. I would therefore prioritize these three: Nb messages sent Average nb of contacts per user Nb groups"See full answer

Chayan R. - "Clarifying questions: You said on average, having 5 reviews can have positive impact, so I am assuming we will plan to pay for 500 reviews. Is that correct or am I missing anything here ? One information which seems to be missing here to come up with the exact price per review is the number of active visitors from which we are calculating the sales conversion rate. Do we have that information or I should include that as a variable in the price per review. ( assuming we are taking that as a var"See full answer

Aneesha K. - "-- Write your query here select u.userid as userid, IFNULL(sum(purchase_value), 0) AS LTV FROM user_sessions u JOIN attribution a ON u.sessionid = a.sessionid group by user_id order by LTV desc ; Needs a full join. Wondering why cant we do a left outer join here. All the sessions should have complete data."See full answer

Alick C. - "The first step is to engage the coworker. Listen to their request and try to understand the root cause of the discomfort. Is it internal or is it the environment that the team operates in, is it a specific individual. Having an open conversation, I believe adds to a culture of being open to discussions for feedback. Depending on the response, would work together with the coworker to identify means or ways that can reduce/remove the discomfort and what can produce an ideal working environment. Th"See full answer

Amparo L. - "The most impressive thing that I’ve done was I got to do a fowards flip on the gym mat and I’ve gotten way flexible "See full answer

Anonymous Sparrow - "I would go look in the mirror and ask that person why the legal team is only flagging issues a week ahead of launch date. Did I not engage our legal team way in advance at the conception stage? Did I not follow up or collaborated with my program manager to follow up shortly with the legal team to check their progress of evaluating issues? If I did not do these things, it is on me. Let's assume I did do those things, but the legal team needed a lot of time to evaluate or get external opinion, th"See full answer

shg - "(This was not search autocomplete based on prefix matching question.) First of all, please note :- The interviewer is not expecting you to get to the right answer in just 1 hr. These systems have been designed over months and improved over years and its impractical for anyone to expect you to get to the right answer in 1 hr. (There is no one single right answer). At the end, the interviewer (director level person) told me the same. What they are looking for is your thought process, getting from"See full answer

Amy M. - "Before we head into this - let's redefine this question to identify some objectives and key results: re-Design FB security privacy intimacy a few questions I want to clarify are: Is this for desktop, mobi web, or apps? Apps Is this for US only? Yes May I assume some resources available for me? Such as Designers, Data Scientists, Developers? Sure ----- Okay let me think about this for a min ---- I'd like to start off by: Thinking about th"See full answer

Aimable - "Clarifying question: Is there a goal that we have in mind? Fb mission: empower people to create community and bring the world closer together IG shops as I understand are the marketplace on IG, where users can view items listed for sale by creators/businesses and also search for specific items or categories. Users can actually buy through shops instead of getting navigated to the original business website. IG shop goals: Businesses continue to face the challenges of selling onli"See full answer