Interview Questions

Yashasvi V. - "WITH RECURSIVE fibonacci_series AS ( SELECT 1 AS n, 0 AS fib1, 1 AS fib2 UNION ALL SELECT n + 1 AS n, fib2 AS fib1, fib1 + fib2 AS fib2 FROM fibonacci_series WHERE n < 20 -- Limit the series to 20 numbers ) SELECT n, fib1 AS fib FROM fibonacci_series ORDER BY n; `"See full answer

Deepak S. - "I would understand the real cause of it. Is it really a time issue or motivation issue or skill issue. If we know the actual root cause, we can better deal with it accordingly. If it is a time issue, I would understand the work done by the team and related impact. Influence them to work on high impact work. If their work is also equally important, I would offer help from my team to heavy lift and they can just guide my team. I would partner with respective team owner to get more resources for f"See full answer

Adib M. - "(1) Discovery: Get to know the stakeholders, PM, Engg team via 1-1. Attend project status meeting where either you are introduced to the stakeholders or actually run it with the goal being to introduce yourself and that you will be catching up on the state of the project in time of the next meeting Understand the Goals of the project and its impact on team and enterprise (2) Planning: Based on current velocity/ burn-rate, estimate what % of the project would be complete at 100% resource uti"See full answer

Malvika S. - "Top three most important variables Uber could use to estimate the ETA for passenger pickup, beyond the ETA on Google Maps can be: Driver related - sometimes driver cancel rides after they are assigned or agree to pickup, especially at odd hours. Sometimes, they can also cancel midway through their journeys. Other factor can be that they drive slower or faster than google maps ETA. Car related - The car may be old or not maintained well than other cars. It can be CNG, Diesel, petrol or elec"See full answer

Nikita B. - "Mission for TikTok shop is to increase brand growth and sales. TikTok gives platform to these brands/advertiser to market their products via influencers/creators to be able to sell their products faster and users on tiktok platform(mainly Gen-z) are motivated to make inspirational based discovery of products and purchase them So main objective for TikTok shop could be Increase sales for diverse brands So, some of the metrics to consider would be: no of orders placed per week"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

Lavanya S. - "To enhance customer adoption of JPMorgan Chase's Payments Developer Portal, I propose a feature called "Guided Onboarding and Custom Integration Paths." Feature Overview Guided Onboarding: A step-by-step onboarding process for new users that includes interactive tutorials, video walkthroughs, and a personalized dashboard based on their needs and use cases. Users can select their business type and goals (e.g., e-commerce, retail, fintech) to receive tailored content and API recomm"See full answer

Jack F. - "What is our goal during onboarding? e.x. Site-visits, add-to-cart, completed checkout etc? After asking clarifying questions we learn that our north-star goal is to get more customers to complete a checkout, therefore our goal is to increase our conversion rate. Are we looking to sell more of a particular product or increase conversion rate holistically? Segmentation: Do we have a particular market or demographic in mind? Commercial/business vs. individuals One time buyers vs. repeat purch"See full answer

Scott S. - " A couple of years ago, we were working on a project to integrate a new third-party data feed into our existing data processing pipeline. This data feed was critical for enhancing our trading algorithms with more comprehensive market data. Given the tight timeline and high stakes, I decided to push for a rapid implementation. In my eagerness to meet the deadline, I underestimated the complexity of integrating this new data feed. I did not allocate sufficient time for thorough testing and valida"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

Amparo L. - "One Accomplishment I'm most proud of is that I graduated from Schaumburg High School In May of 2021 and I was able to get up the stage and collect my diploma. This was a HUGE Impact in regards of passing all of my classes and earning all of my credits in order to be apart of the NOW Arena graduation."See full answer

Anonymous Gazelle - "Post Booking Journey – Starts from making the payment for the ticket & ends at collecting the baggage at the belt Different Steps, which are involved and could go wrong: Payment gateway is not responding and the last Payment made but booking not confirmed Ticket gets cancelled but money is not refunded / money is debited but ticket is not refunded Flight gets rescheduled / Cancelled / Delayed Huge Qs at check in counter / Security Want to purchase a service onboard but currency not"See full answer

Anonymous Crab - "Clarify: IG shops is the marketplace on IG, where users can view items listed for sale by creators/businesses and also search for specific items or categories. Users can actually buy through shops instead of getting navigated to the original business website. Correct? Clarify: Can only sellers/businesses which own their inventory have a "shop"? Or can a social media influencer (different IG account) sell on behalf of a business? Structure: In order to figure out what success looks like, I'd fi"See full answer

Anu S. - "what is a task rabbit? marketplace connecting users with freelance labor with local demand, allowing consumers to find help with everyday tasks, including furniture assembly, moving, delivery, and handy person work Explain the User Flow in short: User logs in, searches for the services, sorts, picks and books the service the gig worker gets 24 hours to pick the request, accepted or declined In case it is accepted then it is considered a "BOOKed"gig what is the post booking experience? -"See full answer

Adarsh S. - "Hey, Thanks for the question - it’s a fantastic challenge with real-world impact. Cool so this is the rough backbone structure that we can follow and ofcourse we can add meat later on to it and pivot if required. So here it goes: First would like to lay out the broader mission as to why we are doing this and then some clarification questions and then probably try to segment users via single or different approaches, then will pick which permutation makes sense as the target segment, then ge"See full answer