Interview Questions

Kena K. - "Lyft’s mission: To become the world’s best transportation company CQ: · Region: USA · Metrics to improve: Engagement User persona: · Passengers · Drivers Will consider passengers persona for this case. Use case / pain points: Exact pick up location is not visible on the map Not able to communicate exact location to the driver due to unknown location How to change the pick-up location in case passenger has to move around Features: Passenger can share a pictur"See full answer

Kiran R. - "Automated Reimbursement System 1. Clarifying Questions Scope: Will the system be applicable to all employees or only specific grades/levels? Ownership: Are we building this product internally for our own use, or is it intended for external/outsourced usage? MVP Requirements: Besides automation, what additional features or problem statements should the Minimum Viable Product (MVP) address? 2. User Segmentation Commute Expenses: e.g., m"See full answer

K v K. - "Not my response, just the Points noted, : Show passion for the work - certifications, competitions, etc., Show the contribution to the Org Has relevant work experience Has the resume been crafted for the job opening and aligns with the job opening Resumes typically get 15-20 seconds for review "See full answer

Bulent K. - "I said we could always revert the production issues. Solve it at DEV environment and then publish again. Interviewer gave me an example of it like a database schema change that may not be possible to revert. I said that we always used SQL scripts to upgrade and downgrade the database schema for each production deployment. So it would not be a problem for us. I guess my answer was not accepted."See full answer

Jaime A. - "I might be missing something but the solution, seems to be incorrect. ... , post_pairings AS ( SELECT ps.user_id, ps.postseqid AS failpostid, ps.postseqid + 1 AS nextpostid FROM post_seq AS ps WHERE ps.issuccessfulpost IS TRUE ) -- here ps.issuccessfulpost IS TRUE the condition should be FALSE -- in that way ps.postseqid is the actual failed post(failpostid) -- Additionally, at the end the join is assumming that the sequence id is going to match the post_id, wh"See full answer

Bravin V. - "I aim to utilize hands-on activities to apply the knowledge I've acquired, safeguard the organization from threat actors, and contribute to its growth."See full answer

Mahesh M. - "Clarification questions Is this a new app or an existing one? - new Is this going to be part of fb or stand-alone - fb app or web - app geo - any/US consider pre covid or covid - covid Grocery store - physical or online store? - physical store FB mission - connect people together The goal of the grocery store - help local stores to connect with users and drive more revenue Users Shoppers 13 - 21 - limited shopping power 21 to 50 - tech-savvy, a fb account already. 50+ - not"See full answer

Alemayehu m G. - "I would try to understand their perspective, focus on the issue, find common ground, brainstorm solutions, and agree on a course of action."See full answer

Ven E. - "I saw this question in one of my interviews."See full answer

Manu S. - " Attributes of a good Product strategy: Good product strategy builds upon the company’s existing advantages (companion products, distribution channels, partner relationships, etc.). Good product strategy clearly identifies target customer segments and non-target segments. Good product strategy identifies leading and lagging indicators of success, whether they are metrics or milestones. Take both top down and bottom-up approach to formulate your strategy. Use top down to bring alignme"See full answer

Karthik M. - "I would always pick a specific product and make a case. Answering this question without a specific product in mind makes the answer unstructured in my opinion. For instance, I would pick Gmail as an example to answer this and structure my response. Clarifications & Assumptions Let us pick a specific product and structure our response - for instance - let us pick Gmail as the product that you want to analyse and make a Go / No Recommendation to Sunset the Product. Overall Google Revenu"See full answer

Kunal M. - "I would apply the CIRCLES framework to this problem. Context: The mortgage industry is based on front to broken back-office operational processes, fragmented data, rates war, non-clarity on appraisal. The coming age of digital savvy Millenials who wants a one-stop shop for all their banking needs in a techno-savy way will pave the way for mortgage disruption. Goal: Metrics to optimize - increase market share in Loan origination, increase revue and increase customer stickiness on the plat"See full answer

Alina G. - "-- Write your query here WITH high_value AS( SELECT user_id FROM user_sessions JOIN attribution ON usersessions.sessionid = attribution.session_id GROUP BY user_id HAVING SUM(purchase_value) > 100 ORDER BY SUM(purchase_value) DESC ) SELECT usersessions.userid, marketing_channel FROM user_sessions JOIN high_value ON usersessions.userid = highvalue.userid JOIN attribution ON usersessions.sessionid = attribution.session_id GROUP BY usersessions.userid H"See full answer

Googlepm 1. - "Getting things done. Since the job is all about leading without authority, it is important to always have the north star in mind. When all in the team do not agree or see a potential solution: Data based evidence : Provide testing results/ Analysis results/ PoC on showing why a potential solution might be better than others, Bring in a trusted stakeholder : Have a conversation with the trusted stakeholder who first believes in the solution, then vouches for the solution to the team "See full answer