Interview Questions

Krish M. - "Situation: I led a critical initiative to re-architect the high volume customer data platform. The system handled over 90 PB of records handling around 70 billion customer records daily and was foundational to customer data capabilities across multiple enterprise products. The existing architecture faced significant challenges around latency, accuracy, and scalability, and any disruption would directly impact global customers and downstream systems. Task: I was responsible for leading t"See full answer

Gloriose H. - "Required output in the solution not the one requested from the question. only customerid, firstname, last_name and years were required. Please this needs to be very clear. Otherwise my answer is with totalorderyear as ( SELECT o.customer_id, c.first_name, c.last_name, EXTRACT(YEAR FROM o.orderdate) AS orderyear, COUNT(o.orderid) AS totalorders FROM orders o LEFT JOIN customers c ON c.customerid = o.customerid GROUP BY o.customerid, c.firstname, c.last"See full answer

theproductguy - "Clarifying Questions and possible responses: both audio and video goals: increase engagement time among groups/communitites and not require another platform to do group call (be one-stop for communication) region-TBD ios/android only available to users in a group to call users within the group who can intitiate these calls?- only admin? or anyone? metrics:NSM: feature engagement (C), number of calls made in a week per user (C). PM: % of people joining the call in a group"See full answer

Coach - "Great question Evan, could you please help me with some context. Do you want me to consider Gsuite & Gmail on consumer or limit it to one or the other segment? Limit to B2C on GMAIL Promotions/ Notifications do you want me to include them? Exclude Would you want to consider only Gmail ecosystem or Gmail to All types of users? Any email recipient I would like to start with US as a geo and extrapolate would you be good with that? That's ok. That helps, than"See full answer

Praveen - "First, I would like to discuss and align what is meaningful social interaction. Given facebook's mission to empower users to build communities and get people closer, it is important that users have "meaningful social interaction" The goal of defining this metric is to use this as a north star or success metric around any efforts to increase engagement. It can also help with ads targeting/monetization by showing ads only during deeper interactions and hence might get better yield. Given faceb"See full answer

Soutrik M. - "Applying the STAR method to explain a time when I had to teach myself certain skills to meet project demands. Situation : I was working for a medical devices company that didn't have CI-CD setup for its embedded software Task : Build the entire CI-CD pipeline from scratch using the tools available within a month Action : I had to learn Docker and other basic DevOps technologies to build this Result : We were able to reduce build time by 70% and create a process for package manage"See full answer

Anonymous Salmon - "Product Bugs can be categorised by severity associated with them. Product Roadmap prioritization happens by MuSCoW technique, or WSJF for big ticket items. Suggestions from Leadership normally fall in expedited bucket. Overall, if there's a Scrum way of executing all priorities, then the PO and Team get together to decide the scope of the sprints for execution."See full answer

Atit P. - "I'd start by clarifying the purpose of the in-flight experience. Get more travelers? (adoption) Reduce customer churn? (retention) Gain additional revenue? (revenue) Lets say we want to offer an in-flight experience that drives revenue. It is intuitive that, customer expectations for an in-flight experience will vary based on the duration of the flights: Short haul flights (1 hour or less): Self-help options are better suited. While seating may be important, a slight inconvenience for"See full answer

Mc L. - "I believe human emotions can't be judged by number and hence I have always made mistakes while judging the outcome of a reaction by data."See full answer

Neeraj K. - "Clarify 10X -> usage or revenue Approach What is Msft Copilot & key capabilities Understand the space in which Copilot operates : Target segments & use-cases serve Competitors (alternatives) Leverage microsoft has : Understand the stack (infra -> application layer) -> leverage Understand Microsoft ecosystem & leverage we have Define : 10X growth strategy (for whom -> & what? -> distribution (acquire & retain)) MSft Copilot & key capabilities Cons"See full answer

P K. - "Redefining the question as: How will you solve the problem of misinformation on FB? Clarifying questions: Are we talking about building a product? (Up to you) What exactly is misinformation? (Fake news, inaccurate facts being shared on social media) Goal: Reduce the amount of misinformation spread on the platform and improve user trust. Key users associated with misinformation: News Accounts (eg CNN) - They may get involved in some controversy about a fake photoshopped artic"See full answer

Dee - "Clarify the question: Is this team for a specific part of JPMC or all of JPMC? Did we already have a DevOps team and we want to introduce the element of security? Steps to build a solution: 1: Define the company and team goals 2: Define the landscape What is the toolchain we want to use? What should the CI/CD lifecycle look like? 3: Define guiding principles for internal builds and third-party software/services which could include: Deployment frequency Traceability/observa"See full answer

Raoul S. - "\# events with meaning participation (monthly). Define meaningful participation by defining thresholds for initial demand signals such as >5 RSVPs, >10 interests. Position in interview that you will work with your data science team to define this depth thresholds."See full answer

Ashima S. - "What do we mean by grow the VC feature? I am assuming the goal to be feature adoption. Goal: Increase VC feature adoption and usage within a timeframe (say, 6 months?) User Segments: I am thinking of the following user segments for this problem - Security conscious users (mostly an overlap with high spending limit card users) Frequent shoppers with multiple online subscriptions (we could quantify this like >5 subscriptions or so) Potential CapitalOne users who have shown interest in the"See full answer

Sneha S. - "Clarifying Questions Candidate : What is the objective we want to achieve? Interviewer : Enhance User Experience, User Engagement and add value Candidate : What platform are we looking at Mobile App or Desktop? Interviewer : Platform independent Candidate : Have we conducted any product discovery experiments at this point? Interviewer : Not yet Candidate : Can we assume the new features will cater to all professionals across different industries? Interviewer : Yes Candidate : A"See full answer

Gunjan B. - "Google flights doesn't have a booking experience. Is this even a real question?"See full answer