Interview Questions

Lisa F. - "I see my role as a servant-leader. It is my job to make sure my team has the tools they need to be successful and that I am providing support directly to them but also communicating with my peers and leadership about the work we are doing and the obstacles we are facing. I want to understand my team's strengths and optimize those so that as a team we can operate at a high level."See full answer

Amparo L. - "I would improve the Walmart search function by being more specific on what I’m searching like for example if I’m searching for potato chips I would just type Lays Potato Chips and then click the search button and It will appear a lot of options instead of all other brands."See full answer

Bryan L. - "with var1 as (select *, rank() over(order by score desc) as srank from players) select player_name, score, srank as ranking from var1 where srank in (4, 6, 11) `"See full answer

Rishabh R. - "sum of continuous subarray and keep checking if arr[i]==arr[j]. if true increase count;"See full answer

Sai ganapathy S. - "Estimation - Estimate Lyft revenue Modes of Income Revenue through Ads Revenue earned from drivers and ride bookings Premium Subscriptions (Lyft Pink) and Other + subscriptions. Considering US as Lyft's primary market and hence estimating revenue for this market for Lyft Total Population of US : 330 Million Among this 330M, there are Low income families - Families who earn just to make their ends meet. So they won’t be able to afford cabs since it is a bit expensive. Assuming"See full answer

Chermaine Y. - "Zero in on the problem, the expectations of user are to find a restaurant but their feed is uninspired so they may bounce out of Yelp. Identify the impact size of user feeling like discovery is not personalised enough by seeing % of users that selected a restaurant from the homepage If large enough, I will look at who is likely the ones that want personalisation and why? Do they feel like they want to try new restaurants or are they finding it difficult to find restaurants they have been"See full answer

Himanshu G. - "First, I would start by defining what growth means in the context of this new feature whether it's user acquisition, engagement, retention, or revenue. Next, I’d identify clear KPIs that directly align with that growth goal. For example, if the feature aims to improve engagement, I’d track metrics like daily active users, session duration, or feature adoption rate. Once the KPIs are in place, I’d run an A/B test comparing user behavior with and without the feature. This would be followed by de"See full answer

Farhan -. - "Sorting is a technique to arrange data in either increasing order or decreasing order, and, the function that implements this functionality is called sort function"See full answer

Kunal S. - "Would prioritize the feature that moves the needle the most on the KPI outlined as the initiative's primary goal. For example, if the overall initiative is aimed at moving the number of bookings, prioritize the feature that moves the number of bookings the most."See full answer

David P. - "delete"See full answer

Riku H. - "Great question. Before I start can I start asking some clarifying qs? By video I am assuming this is FB videos where it's selectively fed unto the newsfeed correct? Yes For FB events should the user be fed with their events, their friends, events or also events in their network? Good Q. I would say yes for the purpose of this question that that's all in scope. Is videos the same as reels? No in this case they are similar but different products where FB videos do not have the 90 sec t"See full answer

E L. - "WITH CTE AS ( SELECT *, ROWNUMBER()OVER(PARTITION BY utxoid ORDER BY transactionid) AS trxrk FROM transactions JOIN transaction_inputs USING (transaction_id) JOIN utxo USING (utxo_id) ) SELECT transaction_id AS InvalidTransactionId FROM CTE WHERE sender!=address OR trx_rk > 1 `"See full answer

Erjan G. - "a process can include many threads. good for concurrent and parallel task execution"See full answer