Interview Questions

Alvin P. - "SELECT e1.empid AS manageremployee_id, e1.empname AS managername, COUNT(e2.empid) AS numberofdirectreports FROM employees AS e1 INNER JOIN employees AS e2 ON e2.managerid = e1.empid GROUP BY e1.emp_id HAVING COUNT(e2.emp_id) >= 2 ORDER BY numberofdirectreports DESC, managername ASC `"See full answer

Sam M. - "The design review has three stages; In-draft, Review and Complete. I consider a design review completed when the problem statement has been clearly addressed via a feature or a solution and signed off on by all the key stakeholders along with engineerings."See full answer

Rev - "Clarify: Physical car garage or some app? 1 garage or a chain? Where is it located? (if highway then user seg to be focussed would change) (rn consider a residential area) Objective/ constraints? - majorly revenue i.e. #users * rev/user (acquire more users) Is there some issue and we are trying to address that via features or we just need features to improve the overall user experience? basic idea of garage: Car issue - drop it to garage/ sometimes pickup service - repair time -"See full answer

Anonymous Koala - "Goal: Google goal is to organize world information and make is it universally accessible Most of google business are focused on building platforms that facilitate one or more of the three below Provide data/information Search, Youtube, Generates user data⇒ Maps, Photos, Earn from advertising==> Adsense, Google Shopping, Search GOAL of Alarm clock is to show time and set/play Alarm If google wants to get into the alarm clock business the goal should be if it can facilitate one of"See full answer

Promise S. - "Submitted before deadline and described the creativity behind the new website"See full answer

Kumaresh K. - "Provide me SAP ATTP consultant interview questions and answers"See full answer

Allison C. - "If I were to design a smartwatch app for Uber, I'd sort my work into two buckets: modifications fro the mobile-native app and new features that would be considered for the Uber experience on a smartwatch. As for modifications - you'd really have to think through the customer journey of ordering an Uber from your watch. For the purposes of this question, the only use case to use Uber would be to order and complete a ride from one point to another, not to look at ride history or get help on a pr"See full answer

Carlos L. - "There are many companies I’m excited about, but none captures my heart and imagination more than Lego. I have great memories of playing with Lego. I remember the thrill and happiness after completing a set and the excitement to show it to my family, relatives and friends. From a product standpoint, Lego offers a myriad of opportunities for growth in today’s context in which technology is ubiquitous. **Lego has faced several challenges over the years from expanding their user base, tradi"See full answer

Marwan O. - "My company was acquired and I was responsible for planning and managing a transition & integration of custom real-time time-series data and event capture software. I worked with lab scientists (who were running the instruments from which the data would be captured) to understand their unique needs compared to the use cases the software was originally written and deployed for. I wrote proposals for integrating specific components of the software and abandoning others, receiving review and a"See full answer

Chermaine Y. - "Zero in on the problem, the expectations of user are to find a restaurant but their feed is uninspired so they may bounce out of Yelp. Identify the impact size of user feeling like discovery is not personalised enough by seeing % of users that selected a restaurant from the homepage If large enough, I will look at who is likely the ones that want personalisation and why? Do they feel like they want to try new restaurants or are they finding it difficult to find restaurants they have been"See full answer

Palak A. - "By looking at QPS prolly! I mean that's the success metric for it after all, right? Maybe not, love to know your thoughts down below."See full answer

Sahil A. - "Clarifying question: By high-tech, we mean internet enabled refrigerator which uses technology and assists us in our decision making or takes decisions for us Users: Working women Homemakers Bachelors and Spinsters living alone Other family members (Elderly, Kids etc) Prioritized users: Working women, Bachelors and Spinsters living alone Problems: Food left in the refrigerator gets rotten as it goes out of notice I am at the supermarket and I dont know the inven"See full answer

Darpan D. - "Clarifying and Assumptions When we say New York City, does this mean just Downtown New York or also the suburbs? Assumption: It means Downtown New York only. Is the bike-sharing service like Uber, where people share their own bikes, or is it a service run by a company with bike stands on street corners? Assumption: It’s run by a private company with bike stands on street corners. Will the bike-sharing service start as free, or will we charge people from the beginning?"See full answer

Anonymous Owl - "def flatten_dictionary(dictionary): \# return a flattened dictionary - int/string/another dictionary values \# if the key is empty, exclude from the output \# concat using a "." btwn them \# add to res which is { "key.a.b.etc": "value" } \# iterate through the key value pairs \# while there is a key value pair in the value \# continue going through that, until the value is an int/string flatDic = {} flatDicHelper("", dictionary, flatDic) print(flatDic) return flatDic def flatDicHelper(initialKey"See full answer

Areeba M. - "create a queue push all cells with 0 into queue Mark all 1s as unvisited (-1 or large value) Run BFS for each cell, explore 4 directions If neighbor is unvisited:distance = current + 1 push into queue "See full answer