Interview Questions

Bella R. - "Approach Clarify the question Define deaf --> unable to hear, but can communicate via sign language, lip read and use all other senses Define fire alarm --> for residential use, it notifies occupants of smoke and potential fires and alerts fire department to check in and/or come over Define constraints --> budgetary constraint, design should be user-friendly and convenient Define goals --> get folks out of harm's way quickly and notify fire department to c"See full answer

Salome L. - "SELECT MIN(id) AS id, TRIM(LOWER(email)) AS cleaned_email FROM users GROUP BY cleaned_email ORDER BY id `"See full answer

B. T. - "The interviewer was interested how the system design would be for files, directories, symbolic links. After proposing my idea, I was asked to print all files for a given path."See full answer

Anonymous I. - "Great question, first some clarifying questions: I assume that we're talking about meta disrupting the travel industry? Or generally When we say travel industry, this could include modes of transportation, scheduling transportation, what to do when you're there etc.? Are we focused on business travel? Leisure travel? I'm going to assume for the sake of scoping down that we're going to be focused on Leisure travel because business does not have as much pain, and on the flip-side o"See full answer

Jagat mohan B. - "Found bug will not impact on the new requirements, if the engineering team aware of the source of the bug and the severity, than it can easily be handled and regression test to perform for a quality check. The new requirement should be equally prioritize for groom and start creating task and team to work on it. Finally based on the severity of the bug you can shuffle the resources between these items."See full answer

Dhruv S. - "Before proceeding, I just wanted to clarify we wanted to check for the impact of showing content from non-friends in users’ feeds, and here non-friends I would assume could be anyone, but mainly like content creators, and I am not including ads here. But I wanted to ask if there is any current logic as to what posts to show based on users' affinity to those posts, maybe basis the user engagement to Insta feed. now objective of this would be to improve the engagement of the platform, as if users"See full answer

Adi S. - "Addressed the duality of the feature - each user is a consumer and provider Addressed pain points such as cleaning, security "See full answer

Books' B. - "Please Review. Thanks In advance! Situation: ABC Product Planners asked me to help them to migrate their one Excel-based Macro into the web application. After having a few rounds of interviews with Product Planners, I realized that the macro was not able to solve their current problem due to its limitation and business teams were convinced that it couldn't be resolved completely. The key challenges they had with their current macro-based solutions were: It was able to compute all bui"See full answer

Patrick B. - "Why do we have FB dating? How does it fit within FB's mission of connecting people and building community? Research shows that lonely people have worse health outcomes, get sick more easily, die faster, etc. There are many ways to solve for loneliness. FB already has Groups which connect people based on shared interests/hobbies. FB also has Messengers and other apps that help you connect with people you already know. Dating is an important way FB can help people form more intimate connections a"See full answer

Daniel P. - "Gotcha, so I understand that our goal is to improve Google Docs and identify key metrics. Questions Is the purpose of these metrics to quantify the performance specifically of the features we suggest? Or Docs as a broader product and its impact on the Google ecosystem? Let's assume the former. Is there any goal we are trying to improve for Google Docs? Let's assume we want to increase usage, and have Docs also drive productivity suite subscriptions. Are there any specific"See full answer

Anonymous Sparrow - "Clarifying question: why would Google consider sunsetting Gmail? Is there an opportunity to make a case against sunsetting or has the executive decision already been made and we're truly looking for a flawless sunset? If decision has already been made - why? Is this a global decision or country-specific? If the answer from interviewer is that the decision is open to debate, pivot case toward identifying the problem that causes leadership to even consider sunset. Then analyze and propose ways to"See full answer

Ayinde B. - "I was working for my friend building streams at venues across the Chicago land area for FGC (fighting game tournaments), I adjusted and engineered his equipment to be set up permanently that's until covid came around at least. I used OBS to give visual appearances to stream watchers. So we're talking about subscribe, follow, and donation notifications and things of that nature for viewers to know they contributed in one of those ways. I set up proper sign-up scheduling for participants to lock t"See full answer

S P. - "I was working for an Insurance company and I was the lead PM responsible for delivering HIPAA 5010 835 (statement of bill claims received vs paid) transactions to healthcare providers/hospitals For this initiative as a PM, I was responsible to create and prioritize features around file creation. I collaborated with cross-functional teams, engineers, DevOps. First I conducted sessions with claims adjudication, SFTP file transfer, security, and privacy, clearinghouse, third-party vendors and ensu"See full answer

Ram - "Clarification Are we focusing on building the product on a specific Meta platform (Facebook, Instagram, WhatsApp), or is this a standalone effort? Is the product digital or physical? Are we targeting internal (employees) or external (customers) users? Are there any specific constraints like funding, resourcing, or geography? 1. Narrowing Down the Problem Awareness and Education: Create tools to increase understanding of climate change and its effects. -"See full answer

Malay K. - "For any project based questions, it is important to structure your response clearly, showcasing your thought process, technical skills, problem-solving abilities, and how your work added value. Besides the STAR method, you can also use this kind of framework: 1. Start by selecting a relevant project (related to the role) Give the project background and what specific problem it solved. 2. Align the project's objective and your role Be specific about your role: were you the le"See full answer

R S. - "My main task was to improve our recommendation system. I worked closely with the business and data teams to understand how recommendations were made in the past. After discussions, I found out that the system had fixed recommendations and didn't consider customer preferences. Our goal was to identify potential customers better, boost conversion rates with personalized recommendations, and increase cross-selling of products. After analyzing a lot of data, we focused on customers with accounts an"See full answer

Hams A. - "When evaluating different high-end brands of products manufactured in China, how can one determine if a "new" product meets high-quality standards?"See full answer

Brandy L. - "Restaurant Types High-end Fast-food Regular User Types Restaurants – seeking operational efficiency and increased revenue. Customers – categorized by group size and dining intent: 2–4 Friends/Family – casual dining. Solo Diners – convenience and quick service. Groups > 4 – shared orders and split bills. Goal Design a tablet solution to achieve product-market fit by addressing key pain points and driving high ad"See full answer

Karthik T. - "Our application has millions of users and significant load on file upload feature. Situation : In our legacy application we had a particular page which was accepting file uploads and it had the legacy way of selecting file uploads and page would redirect you to the next page or show an error message on failure. Task : I had regular calls with the customer who had reported issue multiple times on this application area. In my calls my I also understood that client was expecting some inno"See full answer

Sreeram reddy B. - "select employeename, employeeid, salary, department, DR from ( select employeename, employeeid, salary, dense_rank() over (partition by department order by salary desc) DR, department from employee ) where DR <=3 order by department, DR"See full answer