Interview Questions

Aekagra S. - "Clarified whether this drop is observed in a particular geography or with a particular demography or devices. Then moved to the analysis of any bugs or flow broken or any defects. If not then talk about any competitor launching a product or feature in a similar category. If yes then double down on that or else speak about any political or marketing campaign that's been launched or any negative news about Facebook. What-Why analysis and concluded with a possible cause."See full answer

Scott S. - "The growth of remote work presented engineering managers with the unique problem of leading scattered teams. Keeping remote workers engaged, motivated, and productive can be a daunting endeavour, but with the appropriate tools and methods in place, it’s possible to bridge the gap caused by physical distance and establish a thriving work environment. One crucial part of managing remote or hybrid teams is good communication. Establishing clear routes of communication and setting expectations fo"See full answer

Anonymous Flamingo - "Design a washing machine for Google Step 1: Building Context through clarifying questions Are we looking at building a complete washing machine(new line of business) or a connected app for washing machine like Android Auto? Any specific geography to look for Goal? Increase usage of any specific google product or introduce smart white goods hardware Step 2: Target users Individuals Single Family Couple Hotels Students Laundromats **Apartments/Studen"See full answer

Apurv W. - "Clarify: Understanding of wallets an UPI What is failure rate here? - transaction failed Is it real time failure or successful on front end but failed in backend - assuming it is front end, real time failure. Have other related products/features experienced the same change? Diagnose (impact, significance) Failure rate = assuming it is significantly increasing Impact = customer lifetime value, # of bookings, Avg order value and satisfaction too. Users & value Seller = Revenue "See full answer

PTL - "Clarify the default pick up location/pin feature - I'm assuming it lets you define a location in settings that is used for pickups unless you over ride it. this is a rider feature. It is not used by the driver to specify where they want to pick up riders Feature goal Make it simpler for the user to book a ride as they no longer need to type in an address when going to the default location User Journey assuming they have already set the default location they open the app cl"See full answer

Tracy C. - "Before I walk you through my thought process, I want to align you with the definition of discovery. I assume discovery is the journey before a guest adds a property or experience to the cart, which can be broken down into the discovery of listings pre-search bar on the homepage and discovery post-search bar on the search results page. Are we talking about both touch points as discovery, or would you like me to focus specifically on one? Is this for a specific platform, mobile or desktop web? Bec"See full answer

Arya R. - "I'm going to assume the problem is limited until the point of where the rider get into the car. Rider segments/characteristics: Local rider (lives and travels in the same city) Tourist rider (visiting a city, using Lyft for the first time in the city) Lets think about some problems for these types of users: Local rider: (Choose to prioritize on these use-cases assuming its a larger % of rides overall) Ride shows as confirmed, but driver does not move on the map Driver does"See full answer

Anonymous Minnow - "Goals (Prod & Safeway) User Groups: Shoppers: College Students Professionals Families Elderly New customers (not already in the store) I selected elderly due to trends on the aging population being a significant population in the next decade and it being a group we have the most opportunity as Safeway to support. Pain Points **Most likely these customers are buying things in person or someone is purchasing items for them and gettin"See full answer

Luke P. - "A full stack developer could be summarized as the person who both writes the APIs and consumes the APIs. They are familiar with Databases/Data-layer services, middle-layer/application services and business logic, and finally familiar with the consumers whether front-end applications/UIs or other systems. They can understand the trade-offs up and down the stack, where to adjust along the service-call-path. Ideally they are comfortable programming both async calls (front end javascript promises, e"See full answer

Arasu raja B. - "Amazon price tracker tools like Aarabuy function by monitoring the prices of products listed on Amazon and notifying users when prices drop or reach a desired level. Here's a detailed look at how these tools generally work: Data Collection Web Scraping: Price trackers use web scraping techniques to extract product prices from Amazon's website. They periodically visit product pages to collect current prices. Amazon API: Some tools may use the Amazon Product Advertising API, which provides pro"See full answer

Ana A. - "Amazon: Mission: to be Earth's most customer-centric company Insight: Quick delivery and Great Customer Care are the key value prep of AP. Vision: To be earth's most customer-centric company; to build a place where people can come to find and discover anything they might want to buy online. Strengths: Personalization Wide User Base + Wide Seller Base Own delivery fleet (planes, trucks etc) How they make Money: Sellers Commission "See full answer

Amney M. - "it is really good explanation thanks it is really good explanation thanks"See full answer

Steven S. - "too many questions for clarification on this to start"See full answer

Arnab R. - "with mrg as( select strftime('%Y',order_date) as yr, strftime('%m',order_date) as mo, orderid as oid, orderamount as oa, o.departmentid as did, d.departmentname as dn from orders o inner join departments d on o.departmentid = d.departmentid), mrg1 as( select did,dn,yr, mo, oa, sum(oa) over (partition by did, yr, mo) as ymtot From mrg), mrg2 as( select distinct did,dn,yr,mo,ymtot from mrg1), mrg3 as( select did, dn, yr,mo, ymtot, lag(ymtot) over(partition by did order by yr,mo) as pymtot"See full answer

Gloriose H. - "Required output in the solution not the one requested from the question. only customerid, firstname, last_name and years were required. Please this needs to be very clear. Otherwise my answer is with totalorderyear as ( SELECT o.customer_id, c.first_name, c.last_name, EXTRACT(YEAR FROM o.orderdate) AS orderyear, COUNT(o.orderid) AS totalorders FROM orders o LEFT JOIN customers c ON c.customerid = o.customerid GROUP BY o.customerid, c.firstname, c.last"See full answer

Jaime A. - "I might be missing something but the solution, seems to be incorrect. ... , post_pairings AS ( SELECT ps.user_id, ps.postseqid AS failpostid, ps.postseqid + 1 AS nextpostid FROM post_seq AS ps WHERE ps.issuccessfulpost IS TRUE ) -- here ps.issuccessfulpost IS TRUE the condition should be FALSE -- in that way ps.postseqid is the actual failed post(failpostid) -- Additionally, at the end the join is assumming that the sequence id is going to match the post_id, wh"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

Anonymous Roadrunner - "-- Write your query here select t.user_id, u.name, count(t.id) as orders from transactions t join users u on t.user_id = u.id group by 1, 2 order by 3 desc limit 1 `"See full answer