Interview Questions

Rishi G. - "Problem Statement: The Fibonacci sequence is defined as F(n) = F(n-1) + F(n-2) with F(0) = 1 and F(1) = 1. The solution is given in the problem statement itself. If the value of n = 0, return 1. If the value of n = 1, return 1. Otherwise, return the sum of data at (n - 1) and (n - 2). Explanation: The Fibonacci sequence is a series of numbers where each number is the sum of the two preceding ones, typically starting with 0 and 1. Java Solution: public static int fib(int n"See full answer

Bryan L. - "with var1 as (select players.playerid as playerid, player_name, team_id, score_id, max(scores.gamescore) as gamescore from players join scores on players.playerid = scores.playerid group by players.player_id) select teamid, playername, max_score from (select team_id, player_name, gamescore as maxscore, denserank() over (partition by teamid order by gamescore desc) as scorerank from var1) where score_rank <= 2 order by teamid, scorerank asc `"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

Exponent - "This is another Diagnosis problem. To answer this question, we suggest you use our framework (along with the TROPIC method) to be as thorough as possible. The framework is as follows: Ask clarifying questions List potential high level reasons Gather Context (TROPIC)Time Region Other features / products (internal) Platform Industry / Competition Cannibalization Establish a theory of probable cause Test theories Propose solutions Summarize "See full answer

Shankhadip M. - "My least favorite product is a desktop software solution called Marg, which is used frequently at our family business. Its an inventory, bookkeeping, and accounting software for small businesses in India and integrates with the official government tax portal. The general journey to accomplish any task, say adding a new product type, is very unintuitive and requires someone to be hands-on and familiar with the product to actually do this. Getting there is pure hit and trial. Like most desktop sof"See full answer

Anonymous Caribou - "Sales and Delivery app: Ask Clarifying questions: What all parts of the user journey does this app play a role in? All delivery notifications go through this app. Tesla while completing sales does ask its customer to download this app. Sales can be completely done through the app. Sales person at Tesla could be reached through app. App can be used to buy other peripherals for Tesla. Success Metrics: Revenue: \# of car sales completed through the delivery app. \# of peripheral"See full answer

Shahrukh K. - "During my initial days as a Product Manager, I faced challenges working with our central design team. The team received requests from multiple Product Managers, and prioritization was often influenced by the rapport each PM had built with them. Since I was new, I struggled to convey the importance of my tasks effectively, leading to delays in my projects. This was a significant learning moment for me. I realized that to succeed, I needed to earn the trust of the design team and demonstra"See full answer

Ruth J. - "Provided an overview of IG Search and the value it provides for users Gave 3 metrics that I would consider when determining success Shared the metric that I would use as the north star Got a follow up question. If users were clicking on irrelevant results from their search would that affect your metrics and how would you deal with that Do you think it is a bad thing if users use search to search for something, get irrelevant results and perform an action based on that?"See full answer

Mohit C. - "-- LTV = Sum of all purchases made by that user -- order the results by desc on LTV select u.user_id, sum(a.purchase_value) as LTV from user_sessions u join attribution a on u.sessionid = a.sessionid group by u.user_id order by sum(a.purchase_value) desc"See full answer

Hans - "Described a bug I found on an app designed for a specific make of tablet. In this sequence I described: The app the bug was found in The priority and severity of the bug That it was a regression to an existing working piece of functionality The hardware and the firmware on the device the bug occurred on The steps that led to me finding the bug and how it manifested itself Talked about how we debugged from the point of view of: Code Component Deployed application Comparison to"See full answer

Mitchell K. - "How technical and specific do you have to go when describing your past projects?"See full answer

Aimable - "."See full answer