Interview Questions

Karthik R. - "This is yet another classic case of evolution of data landscape to account for diversities in the data formats sacrificing restrictive but key components at first and added later to make the solution more effective. Data warehouse -> Data Lake -> Data Lakehouse (Data Lake + Data Warehouse) Data warehouse - A solution to store data in central place (analytics (read) heavy) with stringent schema (structured). Very useful for historical queries and analytics. Schema on write check. Only used for"See full answer

Anna H. - "Great. I'm going to get started by asking clarification questions for (1) understanding of the gap by assessing current product features for bookings via platform?, (2) brainstorming possible solutions, (3) how to implement solutions, and (4) suggesting metrics to validate solutions towards an increase of bookings Clarification questions & Assumptions: What is customer segment (family/ group/ individual)? In which market? (individual & US market) Should I specifically focus on one of use ca"See full answer

Hayatu H. - "How do you find consecutive days for login (MySQL, SQL, date, subquery, MySQL 5.7, development)? 1 Follow Request Answer More All related (34) Recommended 📷 Trausti Thor Johannsson · Follow Been using MySQL for more than 16 yearsDec 27 There are functions like DATEDIFF but there are also BETWE"See full answer

Sridhar K. - "Back in 2019, I had to take a decision of firing an engineer as he was rude and abusive to one of my customers"See full answer

Sammy R. - "In python def find_duplicates(arr1: List[int], arr2: List[int]) -> List[int]: result = list(set(arr1) & set(arr2)) return result "See full answer

Riku H. - "Before I start, can I ask some clarifying questions? Is Facebook Reels the same as Facebook Watch where a user can go to Watch and consume short clips, react, comment and share them? In terms of measuring success, are you looking at a segment of users like the reel creators or viewers, or is that up to me? (Assume interviewer will say it's totally up to me) Can I also assume that I am looking at the product across platforms as well? Android, iOS, desktop (Assume answer is yes) Thanks fo"See full answer

Shasleen I. - "Clarifying Questions Who are we? Traditional elevator company or a new age tech startup Assumption: New age tech based elevator company Any constraints: Budget, etc. Assumption: No What kind of a skyscraper building: Assumption: Commercial. Includes office spaces as well as others Any particular goal with respect to building this elevator? Design best in class elevator providing the best user experience for passengers User needs - Users have the following needs when"See full answer

Taheia S. - "at first I want to know number of cluster I will put random number if I don't know and I will use method called Elbow method or Silhouette Score ,Gap Statistic and Davies–Bouldin Index to know the best number of cluster and I will use scikit-learn library to import kmeans from sklearn.cluster import KMeans kmeans = KMeans(nclusters=2, randomstate=0) kmeans.fit(X) and X this my data "See full answer

Rani Y. - "I would start with clarifying questions : Are we building this feature on existing meta apps like Facebook / Instagram ? Yes AM I building this in Meta suite of products or a standalone app ? Inbuilt app with in Meta product like Fb/Instagram Timeline - 1 year Geography - USA Structure : Why -> Meta Mission -> Business objective -> User segmentation -Need ( Prioritization) -> Painpoints ( Prioritization)-> Solutions ( RICE prioritization) -> Metrics / NSM -> Risks - Summary Why : WIth multiple"See full answer

Greg L. - "From chatGPT: If Coinbase's net income is 10% less than it was last month, several actions can be considered to address the decrease in profitability. Here are some steps that might be taken: Conduct a Detailed Analysis:Investigate the reasons behind the decrease in net income. Analyze key financial metrics, transaction volumes, fee structures, market conditions, and any external factors impacting revenue. Expense Review:Review and analyze operating expenses. Identify areas where"See full answer

Praveen D. - "Let me try to explain it with simple life analogy You're cooking dinner in the kitchen. Multithreading is when you've got a bunch of friends helping out. Each friend does a different job—like one chops veggies while another stirs a sauce. Everyone focuses on their task, and together, you all make the meal faster. In a computer, it's like different jobs happening all at once, making stuff happen quicker, just like having lots of friends helping makes dinner ready faster."See full answer

Preetham m P. - "1. Clarify the problem Are we building a digital or physical product?- We are offering it as an application on mobile. Are we building a complete new product or as a new feature for existing airline booking apps (Goibibo/Makemytrip, etc.)? - New feature for existing booking apps. We can consider Goibibo as an example. What do you mean by improving experience?- Reduce wait times or optimize the time spent. What is the goal? Engagement or Revenue? - Engagement. Which is t"See full answer

Janakiram P. - "goal of whatsapp: to connect people at no cost associated to it, over internet, with complete privacy and 100% encryption clarify improve means? increase # of users increase revenues? increase # of countries its used in ? increase features ? who are the customer personas of whatsapp: students working professionals families individuals SMEs current features of whatsapp : communication: video/audio calls, messages document sh"See full answer

Abhijit B. - "I would start with the User feedback- both explicit (from surveys) and implicit(from Product insights on app usage/drop offs). Then understand the business direction/priorities that Paypal wants to take with Venmo and come up with a Iteration plan that starts with "low hanging fruit" first and then builds to more ambitious products. The goal is to find features that are at the intersection of "valuable(to users), feasible(for dev) and usable(to users) . Once we prioritize these features, I would"See full answer

Anonymous Muskox - "Okay so the objective is to describe a product which I think is poorly designed despite of what market sentiments are around this and how the product is performing currently. Okay understood, so the way I would like to go about it is first I will state what are the factors which I look in a product to tell it is a good product. Then will see how a particular product doesn’t follow this and that's why I called it a poorly designed product. For me a product is great if it is having these qualities"See full answer

Mrigang S. - "Starting with Clarifications Before jumping in, a few things I'd want to nail down: What are we actually optimizing for here — is it Retention, Engagement, or something like Average Order Value? Are we talking about the app or the website? Any specific geography in mind? For this answer, I'm going to assume we're focused on improving Retention and Engagement on the mobile app in India. That's where I think the most interesting problem space lives. The User Journey I'm Working Wi"See full answer

Curly T. - "One thing is not clear to me, We encoded the length of the word to a character, but the max number which can be converted to char ascii is 255. How will it work for length till 65535?"See full answer

Aniruddha N. - "To determine which features go into a Minimum Viable Product (MVP), I focus on balancing user needs with business goals, while keeping technical feasibility in mind. My approach usually includes these key steps: 1. Understand the problem deeply: I start by identifying the core user problem we’re solving—whether that’s through user interviews, support tickets, usage data, or stakeholder input. The goal is to figure out what success looks like for the user in the most basic but valuable form."See full answer