Interview Questions

Jeff M. - "At Evernote and Wise, I've created a personalized approach for working more efficiently I've taught to coworkers with either our own proprietary software and off the shelf software. With Evernote, I did this by creating a hyper personalized templates for responding to customer concerns. With Wise, it's been a reworking of their traditional way of approaching Due Diligence and use of resources"See full answer

Nature - "I would be oil. As oil would float and can be moulded according to the sourrounding."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

Sulaiman A. - "Are the revenues down for the entire market/industry? is it an external effect? Has the company made any major shifts in the last month? I'm wondering if this could be a lagging indicator of a change that happened a few weeks ago. Are the revenues down across all product lines, or is it being driven by a particular product? Was there any particular day or time in the last week, when revenues were lower than average? Did we face any outages? is there a competitor in the market? Did we stop advert"See full answer

Alina G. - "SELECT upsellcampaignid, COUNT(DISTINCT trans.userid) AS eligibleusers FROM campaign JOIN "transaction" AS trans ON transactiondate BETWEEN datestart AND date_end JOIN user ON trans.userid = user.userid WHERE iseligibleforupsellcampaign = 1 GROUP BY upsellcampaignid `"See full answer

Prashant R. - "Goal of the pilot deployment: 1) Evaluate if riders would choose self driving cars (SDC) over regular driver operated cars 2) Test SDC performance/efficiency in given area before scaling operations Interviewer liked my goals and asked me to proceed , this is where I got stuck. I wasnt sure if this was an algorithmic based problem or something else and started saying about general issues SDC may have that may impact customer experience such as SDC waiting too long in traffic affecting ETA, SDC"See full answer

R K. - "Some clarifying questions: Is this going to be a part of exciting Meta product or completely new one? you choose Is there a particular sport or range of sports that the product should cater to? all sports, should be agnostic. What is "athletes"? pros? amateurs? fitness enthusiasts? you can decide Is there a specific problems or challenges faced by athletes does he want the product to address? feel free to make assumptions Is there a specific goal that we want to achieve"See full answer

Ananya M. - "assuming food delivery is about convinience not transport ex: household with working members who own a car might still order in instead of driving. to a restaurant for convenience excludes tips and taxes HH = 100M 90% internet penetration low : mid : high income : 20:50:30 preference for the service 30% (bike service would be slower, one needs to keep that in mind +NY has so many food options , people could cook, meal delivery service, uber eats door dash ) HH with internet penetration that can"See full answer

Michelle B. - "I would analise it in some macro and micro aspects and then evaluate those, and think abou an release strategy. First considering the macro aspects that are: what is the main business goal and is the product addressing it? what is the user value and how the product is working towards this? And by last, what is the success metric, and how likely the product as it is, is in the way of accomplish it? Then, if those macro aspects are on track, I would go for a second round of analysis, to ev"See full answer

Anonymous Muskox - "Clarification Question what does it mean by the different markets? Emerging market, developing market, or developed market. Technical Front Low bandwidth or network can affect the performance Latency can be high if the server is not placed near to the regions Business Front The average number of people who indulge in corporate or white collar jobs is very less. Jobs in the local market is very less People who don't have smartphone/desktop excess extensively may not be present on the"See full answer