Interview Questions

Shriganesh K. - "not sure what's wrong here> select a.marketing_channel, avg(purchasevalue) as avgpurchase_value, sum(case when a.purchasevalue > 0 then 1 else 0 end) * 1.0 /count(a.sessionid) as conversion_rate from attribution a left join usersessions u on a.sessionid = u.session_id group by a.marketing_channel order by conversion_rate desc `"See full answer

Laura U. - "productssold = set(transactions['productid']) unsoldproducts = products.loc[~products['id'].isin(productssold)] return unsold_products[["id", "name", "stock"]] `"See full answer

Michael B. - "Problem: Given an input string txt consisting of alphanumeric characters and the parentheses characters '(' & ')', write a function which removes the minimum number of characters to return a version of the string with properly balanced parenthesis. Answer: You can do this with a counter. Psuedo-Python Start with counter = 0 output = [] Iterate through the string, every time you encounter a '(', increment the counter. Add the character to the output. If you encounter a ')', decrement the coun"See full answer

Jiin S. - "I would use A/B testing to see if the new feature would be incrementally beneficial. To begin the testing, we should define what's the goal of this testing. Let's say the new feature would increase the average number of trade by X. Then randomly assign the clients to two groups, control and test group. Control group doesn't see the new feature and the test group see the new feature. We could also stratified sampling if we want to make sure cover different customer segmentation. During this desig"See full answer

Balasubramanian R. - "Inorder traversal of the tree should be the solution for this problem."See full answer

Ayush S. - "1"See full answer

Kritarth L. - "i would understand if this is role specific, team specific, geography specific, at a specific time of the year maybe after appraisals i would also understand the goal - how much reduction in attrition in what time frame then we can look at reasons reasons why someone quits - personal or work related - ill probably try to have a constructive session for the personal ones while for work related il split it into - pay/payhike, impact created, growth stagnation, bad team culture, flexibility in"See full answer

Kartikeya N. - "Clarifying questions What do we mean by bookings? Is it nights booked or transactions?: Nights booked Are there any constraints like platform or anything else while calculating the nights booked? : No If a user books a night but does not show up, do we still count him? : Yes If a user cancels before turning up, do we not count him? : Yes Expedia operates globally. Its major markets are Europe, USA, Asia, Africa etc. We will take the following high level approach **Total population →"See full answer

Anonymous Mollusk - "My weakness was stage fright and talking in front of a large audience. This TPM role does offer me an opportunity to do both but not at the scale at which impacts my day to day role. Also over many years I have taken remedial action e.g. joined a Toast Masters club to overcome my weakness."See full answer