Interview Questions

Shahrukh K. - "When I transitioned from the Analytics team to the Product team, I faced challenges in gaining the trust of the engineering team. Having previously worked with them in a role where I provided insights rather than defining their priorities, they were initially hesitant to accept my inputs in my new role. This led to some misalignment, as they chose to focus on tasks independently rather than incorporating my recommendations. Recognizing the need to build credibility, I took a proactive approach."See full answer

Kinjal S. - "Shopping funnel and engagement: Global search brings up food items from multiple restaurants but results don't directly lead users to the item in the restaurant. Retention and repeat: Users are not able to earn and burn store-specific rewards. Similarly stores/restaurants can't build direct relationship w/ the customers and provide custom offers Multi-store cart and checkout. Currently DD supports cart and checkout from a single restaurant at a time. Many times customers want to order f"See full answer

Scott S. - "Great question! Before communicating any major change, I would ensure I have a deep understanding of the strategic shift, its rationale, and its implications. This involves meeting with senior management to gather all necessary details and preparing to address any questions or concerns from the team. To share a recent experience I had, so Last year, our senior management decided to shift our focus towards leveraging machine learning and advanced real-time analytics to enhance our trading stra"See full answer

Adam M. - "This is a great question! If you don't mind, I'd love to list 3 strengths and weaknesses then dive a little deeper on one of each of them. I think my three greatest strengths are: Empathy Openness to feedback Drive And three weaknesses I have been working to strengthen are: Sometimes my desire to achieve can put me at risk of overcommitting Communicating status to the right stakeholders at the appropriate time Creating detailed and strategic lists of priorities so I can meet th"See full answer

Srilaxmi C. - "Step 1: Clarify Before delving into the metrics, should I consider the current state of Google or when it just launched? Here, I am assuming the current state of Google. Google is currently a company that makes approx $15) billion in Revenue and 90 % of the revenue comes from Ads. Ads are core for Google's business and Google is the major player in the market Step 2: Goals: The main goal is to maximize revenue through effective Google Ads campaigns. This means ensuring that the campaign"See full answer

Rjj - "I tried solving this question and here is the recorded video for the entire solution - https://youtu.be/G_LIbTp58XA Feel free to comment here or on the video for further discussion."See full answer

Aditi N. - "Clarifying question: Why would google want to sunset Youtube? What would the business objective be? Based on how the interviewer responds this could go down multiple paths: If they said just because, then I would address the current state data for the YouTube business. Material benefits: XX Million active users $$ in Annual revenue $$ in subscription revenue $$ monetization through influencers Non-material benefits that align to google core values: Democracy on the web works"See full answer

Rudra pratap S. - "select sum(orderquantity) as totalunitsorderedyesterday from orders as ord join items as it on ord.itemid=it.itemid where order_date="2023-10-14""See full answer

Bless M. - "You can ask some clarifying questions like 1) Ask if the list is already sorted or not 2) is zero included in the list ? 3) Natural numbers are usually positive numbers ( clarify they are non negatives) Solution : 1) If sorted use two pointers and sort them in O(N) 2) if not sorted , -ve / only +ve numbers in the list doesn't matter - the easiest solution is Use a priority queue and push the number and its square in each iteration Finally return the list returned by the priority Queue. N"See full answer

Kshitij I. - "Data lake and warehouse are both places that allow an organization to store large amounts of data. When swimming in a lake, one would imagine that they come across all sorts of stuff - floating twigs, fish in the water, stones, chemicals and sometimes may be even a snake. Similarly, a data lake stores all forms of data that the company has without any indexing. The data is available at any time but needs to be first cleaned up and reorganized before it can be used for any type of analysis. A"See full answer

Amparo L. - "The reason I want to work at Apple Company is because I have great communication skills"See full answer

Jatan P. - "Step 1 - clarifying question: Are we just focusing on the customer who rented a car or both who has given a car? (Assumed only a customer who rented a car) Are we just focusing on the mobile or web apps? (Assumed only the mobile app) Step 2 -Define users: customer who rented a car. Step 3 - pain points: unclear communication between both parties. lack of support if needed. hassle-full car drop experience. No survey or complaint channel about how the experienc"See full answer

Amparo L. - "One time at Lifetime Fitness 2019, One student was throwing a lot of towels in the counter which made things very disorganized, then I made a compromise with my coworker to put 2 towels at a time and then it worked well because it made the workspace very organized."See full answer

Snehangsu B. - "In a recent implementation of a large core banking project where we were breaking away from monolithic architecture to microservice based one we faced a situation where customer wanted to have a single repository of user and role management. Since Micro service based architecture talks about individual entities for multiple product suite it was mandatory to maintain individual user base. Based on the customer feedback, we had to come up with an unique design of single user base and replicating"See full answer

Aeshvarya J. - "Food delivery apps : Food delivery apps are clear example of demand and supply functions, Both end need to monitored closely. Ecosystem : Order placer, Restaurant and Food delivery Platform Value : Order placer find value when they can order food at home from their fav restaurants. Restaurant find value when they make sell via order coming in and probably good reviews which marks future growth. Food delivery platform when orders are being placed. North star metrics : # of order delivered Bre"See full answer