Interview Questions

Praful B. - "The company culture is very supportive and collaborative. Googlers are encouraged to be creative and innovative, and there is a lot of freedom to explore new ideas. The work is challenging and rewarding. Googlers have the opportunity to work on cutting-edge projects that have a real impact on the world. The company is committed to diversity and inclusion. Google is a great place to work for people from all backgrounds and with all different perspectives. I am confident that I would b"See full answer

Anonymous Grasshopper - "I'd like to start by understanding the basic scope of the change we've observed. Who is the user? Lyft is a two-sided marketplace so it could be the driver or rider. -Driver When did the change happen? Was it slow or a sharp drop-off? - sharp, 2 weeks ago Was there a specific geographic region? Urban v suburban? - no trends Cancelling can happen at several points in ride acceptance, is there a particular point where we see most cancellations? - just after accepting a ride"See full answer

John F. - "Currently, I do a lot of data analysis using Azure Databricks and PowerBI. In Databricks, I write some basic SQL queries to retrieve the data and then pull that data into PowerBI for analysis. While this is sufficient, I believe there is room to make this skill set stronger. One way that I mitigate this currently is to maintain a strong relationship with our data analytics team. Whenever I have issues massaging or querying the data, I will reach out to one of those team members to help me get to"See full answer

Hari priya K. - "Netflix is a OTT platform that streams content , TV shows, movies documentaries, to the subscriber's of Netflix. Netflix has approximately 90 million subscribers in USA alone and Netflix's revenue is generated based on their subscriptions. The user buys Netflix subscription, logs in , opens profile and opens the home page of Netflix. 1. Confirmation of the Assumptions Homepage Definition: The homepage is the screen users see after logging into their profile, showing tailored recom"See full answer

Daniel L. - "As a leader of team, I manage projects and teammates. Above of all, I have to move all people's mind. PM should be good at many technologies and stacks. I work on schedule which is made by meeting and discussing of all team members. Everyday, Every week, I check the result of working and reorganize process of project. Thank you."See full answer

Anonymous Fox - "In what terms we need to improve the quality? Is there any focus on any particular host/customer experience? - Let’s consider that we need to improve the customer engagement on Airbnb platform. Airbnb has both - web interface as well as mobile interface. So, I am assuming the experience on both the platforms. I will brief about Airbnb - Airbnb provides homeowners to rent their spare rooms/properties to travelers/visitors and at the same time, travelers/visitors can get accommodation at budget"See full answer

Ama M. - "Answering only estimation portion for practice (for some reason after submitting the formatting is unorganized) clarification and assumptions can I assume this grocery store location is called Greens can I assume that self-checkout means that customers checks out without assistance? can I assume that cashier checkout means that cashier assists customers with checkout? can I assume that ratio means how man self-checkouts should be place at this grocery store compare"See full answer

P K. - "Clarifying/Assumptions: Assuming improvement refers to lift in engagement in this case. Youtube refers to the WWW and mobile platforms. Key User Segments: Creators Influencers/Celebrities Video bloggers Regular users Viewers Power watchers Casual watchers Churned watchers Selecting the Influencer segment from the above list since it is a smaller volume of users and will have a big impact on viewers. Also, it is easier to understand"See full answer

Rishabh L. - "with empbysalary as ( select id, firstname, lastname, salary, department_id, rank() over (partition by department_id order by salary desc) as rnk from employees ) select d.name as department_name, e.id as employee_id, e.firstname, e.lastname, e.salary from empbysalary e join departments d on e.department_id=d.id where e.rnk=1 order by 1; `"See full answer

EssGee - "I think i would start by asking what's driving the strategy for testing new ad formats? Possible options could be Increase monetization? Improve ad effectiveness? Any other objectives? Assuming that its both 1&2 - we want to test new ad formats to gauge if these are more effective and lead to higher monetization Ground the conversation into current scenario Instagram Reels is aa short form video platform that users use to showoff their creativity Reels is a relatively new addition to"See full answer

Dinar M. - " Thanks a lot for showing us how a recommender system can be build. I see it was proposed to use Collaborative filtering which is user - item matrix having dimension N * M (where N - number os users and M - number of songs). Though, it was explained how it gonna be built, it is still unclear how all users and songs features are going to be used. In that matrix we have values in cell (lets say i, j) like 1 - a specific user (i) clicked on song (j) when it was recommended or it is 0 when the user"See full answer

Preetham m P. - "Clarifying Questions Is the product a digital or physical marketplace? (Digital) Are we building an educational platform, freelance platform, or marketplace? (Freelance platform) Are we focusing on a specific geographical location? (India) Will the platform involve online transactions? (Yes) User Personas Individual Gardeners: Self-employed gardeners offering their services. Gardening Agencies: Organizations providing gardening services. **Educational Institutio"See full answer

Anonymous Goat - "Batch Packing Problem In Amazon’s massive warehouse inventory, there are different types of products. You are given an array products of size n, where products[i] represents the number of items of product type i. These products need to be packed into batches for shipping. The batch packing must adhere to the following conditions: No two items in the same batch can be of the same product type. The number of items packed in the current batch must be strictly greater than the number pack"See full answer

Danyal R. - "Start with OpenTable's goal: making reservations easier for customers. If user's are having bad experiences then that impacts the key metrics ( # of bookings), create a negative brand perception with the potential to lose customers. Focus on ecosystem: customers making reservations & merchants/businesses each have different pain points. For the sake of time, focus on customer's experience. Post Booking User Flow User receives a post booking confirmation (date/time"See full answer

Kiran M. - "I started off with developing microservices for the game and then incorporating kafka to make it scalable"See full answer

Aayush S. - "With $1 billion to invest in generative AI, my focus would be on addressing unmet needs in everyday life. Here's my vision: Identify User Pain Points: I would start by understanding the specific challenges a segment of users face daily. Many people are integrating AI into their routines to simplify tasks, yet there are gaps that need to be filled. Learn from ChatGPT’s Success: ChatGPT's rapid growth to 200 million users demonstrates the demand for AI solutions that genuinely solve"See full answer

Yashasvi C. - "I would first like to clarify the requirements and assumptions for the system. I am assuming that the system should support basic file operations such as uploading, downloading, deleting, renaming files, and viewing directory structures along with file permissions. The file size can range from around 1MB to 1GB, and the system is expected to be read heavy, meaning downloads will be more frequent than uploads. The system should support a large scale, for example around 10 million total users with"See full answer