Interview Questions

Anonymous Hummingbird - "I started going through the different main area of focus stakeholder alignment with Product and engineering; resource alignment getting it into the backlog and then prioritization spoke about Sprint planning and timelines and timely communication back to stakeholders to be on track for this end to end demo / pilot options (but HM already wasn't too happy about the response and asked me the Question again)"See full answer

Ilnur I. - "I can try to summarize their discussion as I remembered. Linear regression is one of the method to predict target (Y) using features (X). Formula for linear regression is a linear function of features. The aim is to choose coefficients (Teta) of the prediction function in such a way that the difference between target and prediction is least in average. This difference between target and prediction is called loss function. The form of this loss function could be dependent from the particular real"See full answer

Niji R. - "General Approach: In a funnel, prospects that dropped off at the very end just before conversion are the ones that were most likely to convert simply because they went through the effort of going through multiple steps to advance to the very end of the funnel. The more the prospects advances through the funnel, better their probability of converting. I'd therefore focus more on reducing drop-offs at the final stages of the funnel for better conversion. Caveats: There are certain use-cases where"See full answer

Abdurhman M. - "Graphic design is the process of visual communication and problem-solving through the use of typography, photography"See full answer

Asish B. - "The supply and demand for Uber Eats may be greatly impacted in the near future by the two macroeconomic factors listed here. Each trend links to large alterations in consumer behavior, labor markets, and cost structures that can cascade across the delivery ecosystem. Changes in Consumer Spending and Inflation Growing Costs and Fees for Food: Customers may order fewer deliveries or choose less expensive goods if food prices, restaurant running costs, or delivery fees increase as a result of"See full answer

Ravi teja N. - "I solved it using recursion and then memoization. Used Dynamic programming approach"See full answer

Adib M. - "(1) Goals/Value Proposition: Provide context on why the API migration is important and the value add / benefits of doing so to the customer. Need to generate excitement.... (2) Identify stakeholders from Customer and internally for this API Migration. (3) Kick off Meeting : Invite stakeholders, agree on Communication Plan, (4) Planning: Create migration plan, internal development testing resources, timelines, how will we support our customers, testing strategy, rollout plan, rollback plan "See full answer

Anonymous Hummingbird - "Q: How do we know that they spend too much time in the app? A: User research/Qualitative survey goal: decrease dissatisfaction that they spend too much time in IG Persona's, lets segment based on usage: New users: just signed up and getting the hang of it lurkers: don't post or engage, just follow contributors: post occasionally (stories + posts) super users/micro influencers: post daily, engage with commenters, spend a lot of time in discover tab IG mission statement is to capture and s"See full answer

Surbhi G. - "Deep Learning is a part of Artificial Intelligence, it's like teaching the machine to think and make decisions on its own. It's like how we teach a child the concept of an apple - it's round, red, has a stem on top. We show them multiple pictures of apples and then they understand and can recognize an apple in future. Similarly, we feed lots of data to the machine, and slowly, it starts learning from that data, and can then make relevant predictions or decisions based on what it has learnt. A co"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

Michelle D. - "I would first want to confirm my understanding of the reasoning behind no-ads-allowed in the top left of the feed. For this case, I will assume that the rule is not a hard rule and one in which we may test in this prompt. I'd next confirm my understanding of Pinterest's revenue model with the interviewer. My understanding is as follows: Pinterest serves ads to pinners. Conversion (i.e., purchase) via the ad yields some amount of profit to Pinterest. There's some amount of costs associated and"See full answer

Kasturi K. - "What do you mean by smart lock. It is home locking system or digital locks Assuming it refers to home solutions that Google wants to get to build Customers Homeowners/ Rental Hotels Banks Vehicles Shops Each of the customer segments are good. Let’s investigate some of their characteristics Homeowners/ Rental – Huge Market as every urban house has a need. Hotels – Again the need is very high. Affordability is high. Low desirability to change existing set up. Banks – No"See full answer

Maliki U. - "Here is my implementation: select marketing_channel, AVG(purchasevalue) as avgpurchase_value from attribution group by marketing_channel order by avgpurchasevalue DESC ; There is no need to copy and past the line of code for calculating the average into order by, just Alias is enough because going by the order of execution in sql, Always, order by is executed after executing select clause."See full answer

Pm P. - "Alexa: Is the virtual assistant that runs on amazon smart speakers as well as on other devices. Clarification on goals/Objectives: What would the goal at that point of time be? Is it increase in revenue ? Either via new customers i.e. adoption or Increasing the wallet share of the customer? Increasing the sales ordered via Alexa ? Why do people want to use Alexa? To get answers, make their lives easier by automating activities within their home Integrates with amazon account so"See full answer

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

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

Parag L. - "I was in my early days of leadership and strategy. In Marriott when a decision was made by C suite to buy products as wrapper over cloud providers I was surprised and based on my limited information and knowledge posted a question to Chief technology officer as why it won't be a good strategy to directly use Native offering from AWS. The reason enlightened me and gave new a new thought process that being such a large enterprise that has presence in 200+ countries across globe we may have challen"See full answer

Anuradha T. - "What‘s the goal of increasing Spotify’s premium subscribers? - To monetize and get more premium subscribers Users: Target users could potentially fall in 3 categories 1) Users who are interested in paying a premium price for great curated playlists 2) Users who are interested in listening to music but not willing to pay a price Targeting #1 Pain points: 1) As a user I wouldn’t want to subscribe to something w/o being listening to the playlists 2) If I do subscribe I would like to receiv"See full answer

Gaurav K. - "I think sliding window will work here and it is the most optimized approach to solve this question."See full answer