Interview Questions

Kedar W. - "with login_data as ( select * from useractivitylog where activity_type = 'LOGIN' ) ,cte as ( select userid, timestamp as currentlogin ,lag(timestamp,1,timestamp) over (partition by user_id order by timestamp asc) as previous_login, round((julianday(timestamp) - julianday(lag(timestamp,1,timestamp) over (partition by user_id order by timestamp asc))) * 24 * 60) as minutes_elapsed from login_data ) select * from cte where currentlogin  previouslogin;"See full answer

Anhul C. - "I would take the following approach: Define what acquisition of a merchant means - It could be a few of these actions - 1. Merchant provides their email/phone number to shopify, 2. They create a store 3. they sign up for a subscription Second we need to establish the method we are using to acquire new merchants Assumption - it is paid advertising on IG and FB given that's one of the ways of acquiring audience on these platforms and is easy to track. Other approach could be social"See full answer

Hmm T. - "Understand what is the business objective behind the ask ? We should not be adopting trends just because everyone is adopting, it has to be tied to business objective Once objective is clear - we need to determine feasibility and cost\benefit assessment by deciding on pilot candidates - since its bank, do we want to integrate this with mobile banking only ? Once we decide on candidate - we will also need to decide on buy vs build decision ? If there are any fintech offerings (like Zell"See full answer

Veronica S. - " CQ: 1. Understanding of Google search and the way ads are being displayed today. What kind of subscription model are we thinking of: same as youtube I talked about Google search as a flagship product of google. % of revenue generated from ads. Other search engines and there % share in the market. Other players such as Facebook whose 99% revenue is from ads. Talked about Google Mission and alignment of the ads with Google mission Pro Con list of subscription versus ads User exp. 2."See full answer

Ben G. - "Problem & Users What is the primary problem the App is trying to solve? Who is the primary user for the App? What is the core value proposition and what business model does it employ to serve the value? What are the business goals the app is trying to achieve and how effective is their strategy Structure Is the purpose of the app clearly conveyed? How is the overall use of space? Is there enough negative space? How does the Information Architecture help users accomplish de"See full answer

Vinit K. - "I have often experienced my manager believing in something while I don't. The situation largely arises when the manager is under pressure of taking decision and has not spent enough time on researching about the decision. While I on the other hand have always spent time learning about issues right since we feel this is going to be a challenge in the near future. In such scenarios, I would believe something else base on my research while the manager would have some other belief based on his exper"See full answer

Sunny G. - "https://en.wikipedia.org/wiki/Operational_transformation"See full answer

Jayveer S. - "WITH suspicious_transactions AS ( SELECT c.first_name, c.last_name, t.receipt_number, COUNT(t.receiptnumber) OVER (PARTITION BY c.customerid) AS noofoffences FROM customers c JOIN transactions t ON c.customerid = t.customerid WHERE t.receipt_number LIKE '%999%' OR t.receipt_number LIKE '%1234%' OR t.receipt_number LIKE '%XYZ%' ) SELECT first_name, last_name, receipt_number, noofoffences FROM suspicious_transactions WHERE noofoffences >= 2;"See full answer

Exponent - "This is one of the core behavioral questions that you should expect to cover in any interview. In particular, it asks you to justify why you want to work at a specific company that you've applied for. There's no right answer for this, however we do recommend you list at least three distinct reasons. Here's an example of what you might say: > Great question! There's so many reasons, but I'll keep it to my top three.I love how intricate and delicate the payments space is and I want to work in this"See full answer

Anonymous Dove - "Improving the parking experience as a Google Maps PM is a challenging and interesting task that requires understanding the user needs, pain points, and goals. Here are some of my ideas for how to improve the parking experience on Google Maps: Provide real-time parking availability and prices: One of the main challenges for drivers is finding a parking spot that is available, convenient, and affordable. Google Maps could use data from various sources, such as sensors, cameras, or crowdsourc"See full answer

P K. - "Clarifying questions: What are open homes and how does this model work? Open homes cater to provide free shelter for refugees; hosts list the property and partner NGOs based on the requirement book an appropriate property for the refugees. How long does a refugee stay at a property? Minimum 2 weeks Does the host provide meals? Up to the host, some do and some don't What does improve Open Homes mean? There is an imbalance in hosts - we need more hosts"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

Swetha C. - " Questions: Is there any specific user pain point we are trying to solve ? Is this for engagement or retention or revenue Is there any specific Geo you want me to focus ? Is there any specifc user segment you want to focus ? Structure: Company Mission: Easy access to vehicle no matter when and where you are. Product Mission: Quick and easy delivery of food delivered at your door step User Segments: Sellers : Restaurant, Catering, F"See full answer