Interview Questions

Sayee M. - "depending on project phase, apply various methodologies. scrum for app dev, waterfall for data migration, Testing (TDD for dev, FUT FiT for manual, UAT) , OCM has it own methodology ."See full answer

Gowtami K. - "select DISTINCT p.product_id, p.product_name , CASE when sale_date is null then 'Not Sold' else 'Sold' END as sale_status from products p left join sales s on p.productid= s.productid `"See full answer

Kiley S. - "Improve facebook’s feed. Clarifying questions: Do we want to look at desktop or mobile specifically? – Mobile Is there a specific goal we have in mind that we are trying to meet or just general improvements? — General improvements, innovation Clarify Product: The Facebook newsfeed is the content feed that users see when landing on the app. The feed shows content posted by people users follow Within the feed the user is offered updates on people they follow - friends, family, celebrities"See full answer

Surekha G. - "In one of the projects I managed, one team member was slipping each of his task's ETAs several times, citing different reasons, and communicating the delay after it already happened. The delay seemed disproportional to the reasons thereof. I first collected sufficient historical data to confirm that this was a pattern, and similar circumstances were faced by other team members, but they were managing to still keep their ETAs. Then I had a talk with the person, and showed him the data. I also ex"See full answer

Namrata L. - "Measure the success of SnapMap Clarifying question Snap is the feature which is visible on right swipe on snap chat showing map and location of your friends right? Do we have any specific goal in mind or we want to decide the overall success of the feature? Mission - Help users be connected with their friends and family and be updated about them. That is why the main medium of exchange is photos or videos in Snapchat which keeps people updated which actually putting things in words. Goal"See full answer

Exponent - "You should be able to easily identify this as a Measure Success question. These kinds of questions are used to test your analytical skills, as well as your ability to track project progress post-launch. Recall the strategy for tackling them methodically and thoroughly: Ask clarifying questions State the goal of the feature / product Behavior Mapping / UX Flow Mapping Provide criteria to prioritize metrics Prioritize metrics Summarize Let's begin! "See full answer

Angela - "Clarifying Qs: What are we building the Google campus for on the moon? We are the Google X team and always want to move people forward and want to be the first private entity on the moon Are we trying to build for astronauts or our employees or someone else? This will be for employees Do we already have a location on the moon and we're expanding or will this be the first one ever? This is the first one ever. For us to answer this question, we'll want to discuss Google's mission, us"See full answer

Michael B. - "Problem: Given a modified binary tree, where each node also has a pointer to it's parent, find the first common ancestor of two nodes. Answer: As it happens, the structure that we're looking at is actually a linked list (one pointer up), so the problem is identical to trying to find if two linked lists share a common node. How this works is by stacking the two chains of nodes together so they're the same length. chain1 = node1 chain2= node2 while True: chain1 = chain1.next chain2=chain"See full answer

IamaPM - "Number of visits to the site had increased, so total reservations infact went up, but conversion was down due to more users visiting, due to a promotion offered by the company or may be due to more ad entry points, social media, friend recommendations etc."See full answer

Exponent - "This is a Diagnosis problem. We've gone over diagnosis problems in the past, but most are centered around usage. Even though this is about retention - do not be alarmed. We can still follow the TROPIC method to create a plan to thoroughly diagnose the issue: 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 proba"See full answer

Praful B. - "It could make Gmail less accessible to people who cannot afford to pay for it. It could lead to users switching to other email providers. It could damage Google's reputation as a company that provides free services."See full answer

Tanu M. - "When it comes to Metrics, I always think of one thing " What cannot be measured cannot be done". The product that I am managing goal is on enabling the products for our partners so that our partners can have a seamless experience of doing business with us which in turn will increase the revenue. The user segment for my product is mainly resellers who can resell the product to another customer so that the reach of the customers is more. The metrics which I am tracking are revenue, referrals, an"See full answer