Interview Questions

Shanti informatics - "Goals; Customer engagement/ acquisition; Persona: 60-70; User journey: Selecting the right flight → Adding details → Selecting the best coupon for payment; Web-Check in; At the airport: Luggage check-in; Boarding; Flight Travel; Arrival: Collecting the luggage from belt; I would be focusing on the first two steps: Selecting right flight + and web check-in → That seems the most challenging aspect an elderly; Pain Points/ Challenges: Selecting the right flight (Duration/ Pric"See full answer

Anonymous Stork - "You are working on a SaaS product that currently uses Basic Authentication (username/password) for API and application access. The security and compliance teams have mandated moving to a more secure, modern authentication mechanism — OIDC (OpenID Connect). Design the authentication system migration from Basic Authentication to OIDC. Discuss the architecture changes, the migration approach, and the rollout strategy. What are the technical challenges, impacts on customers, backward compatibility"See full answer

Evan R. - "The user table no longer exists as expected - I get an error that user does not contain user_id. Note that querying the table results in only user:swuoevkivrjfta select * FROM user `"See full answer

Snighdha G. - "By showing results that I have achieved by taking that action because seeing is believing. For example, when we had issues with our child's behavior and wanted to understand what as parents we are doing wrong, we went and sought help from a specialist and similarly advised same to others having some form of mental health issues to seek help since we benefitted with it a lot."See full answer

coolkid1 - "wasn't aware of ticketmaster thus asked time from interviewer to glance through the portal, also cross-checked any other value prop from the interviewer that i couldn't infer from website, for ex. providing assurance of confirmed tickets. clarifying questions - who am i? do we want to partner with another player or provide services on our own? any specific goal - monetization, engagement, retention etc. in mind? any particular geo? "See full answer

Manas M. - "I'd ask Clarification questions here before proceeding with designing a CDN. The questions would be. What is the Use Case with multiple questions in it What sort of Content do you want to serve - Static files or Streaming Media or trending content? How many regions do you want to cover Do you want to prioritize speed and the Latest file availability or do you want to prioritize time-based caching per region? Budget constraints(push cdn's can be cheaper). Whether"See full answer

Rahul R. - "I would first call out the two types of Google Doodles that are published. First would be the static doodle which just shows a picture, and users can get more information on it by hovering on it or clicking on it. Second would be the dynamic google doodles which are either short videos or games through which users engage a bit more. My top 3 metrics that covers both would be: Click-through rate and post-click CTR - Although different metrics, I clubbed them since they fall under similar"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

Rev - "Clarify: More about google online tutoring service? - content type, is it recorded/ live, certified/ at own pace/ paid, unpaid, etc.? Objective of this service? Organise world's info & make it accessible & useful, any other objective? What is the revenue model? Competition? Region/ geography? Constraints? Approach: Awareness about the product & job openings: Print & Digital media, ads via google products Accessibility to apply LinkedIn/ Google careers page, post"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

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

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

Anonymous Hare - "Sharing the approach for functional requirements we tool to solve this question. Functional Requirements This is only for the Registered users What is a "For You" page ? Home page where you get suggestions based on people you follow. Interactions like/share/comments (done by user) Interests (shared by the user during registration or onboarding) sports choices/ region choices/ Video sharing platform. So how many videos should we s"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

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

Soumya S. - "In 2019, I was given a very important problem to solve. In a team of 3 we had to build a mobility assist device. The customer segment we would go for was something we could decide. The project was very close to me as I had lost someone I loved because of cancer and I saw how reduced mobility was a huge pain point in not being able to do physical activities. My team could only think of elderly people as the main target market. As the Head of Product what I did was: 1) I helped them dive even d"See full answer