Interview Questions

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

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

Darpan D. - "Clarifying and assumption When we say financial security, are we talking about authentication, fraud detection or money laundering? Assumption: Fraud detection. Focusing specifically on transaction-level fraud. Is this an internal AI implementation or an external third-party service we provide to multiple financial businesses? Assumption: External Third-party AI financial security product. Requirements Need to detect when fraudulent transactions happen. **Detection stra"See full answer

Agni W. - "Interesting questions. Thank you for asking it. S: Suppose I want to add notifications service to an app that provides user directed content, that is is dependent on user's past preferences T: if you ask me for a prototype, then I would use API gateway/ LB, Lambda, storage in SQL and No SQL both, have caches. later we could use CDN, have EC2 instances to run the app. We could deploy Kafka pipeline also. Create notification service on the existing app. - that will be a micro service A: Since"See full answer

Aman G. - "Was given 90 minutes with an exhaustive set of requirements to be implemented as a full-stack coding exercise. It was supposed to have a UX, a server and a database to store and retrieve data. The IDE was supposed to be self-setup before the interview. The panel asked questions on top of the implementation around decision making from a technical perspective"See full answer

Manoj K. - "I fumbled but my answer was along these lines Clarification: Are we talking about ChatGPT page or other ways to use it like API Ans: page When you say improve did you mean usage or monetization Ans: you pick We should pick user experience and usage since better product will enable easier monetization. Assume they monetize based on premium users subscription. Lets talk about users Business users Individual users Focus on business since traffic generated by individuals will not be as mu"See full answer

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

Firdous A. - "Approach (BFS + Horizontal Distance) Assign a horizontal distance (HD) to each node. Root → HD = 0 Left child → HD = parent HD - 1 Right child → HD = parent HD + 1 Do a BFS (level order traversal). If a node with a given HD is seen for the first time, add it to the result. Ignore later nodes with the same HD (because only the top one is visible). After traversal, sort by HD and print nodes left to righ"See full answer

Clayton P. - "The interviewer hinted that a two-tower recommender system might be a suitable approach, using user history to embed users and pages separately and train on view or interaction data. Instead, I proposed a different approach that I felt was more aligned with how knowledge is structured in Confluence: I designed a system using a graph database to model the relationships between Confluence pages. Each page is a node, and edges represent content-based references. For example, when one article"See full answer

Exponent - "This is a Technical question. It tests your ability to understand high level technical concepts. Even though your job won't have any coding involved, you'll still need to understand these concepts. Being able to cover all these topics with clarity communicates confidence in your interviewer. Unfortunately, there's no formula for technical questions, but some general tips are: Use analogies when you can Break your solution into clear, bite-size steps Don't be afraid to use examples to b"See full answer

Anonymous Muskox - "Clarification Question what does it mean by the different markets? Emerging market, developing market, or developed market. Technical Front Low bandwidth or network can affect the performance Latency can be high if the server is not placed near to the regions Business Front The average number of people who indulge in corporate or white collar jobs is very less. Jobs in the local market is very less People who don't have smartphone/desktop excess extensively may not be present on the"See full answer

Sean L. - "hi"See full answer

Tes d H. - "Here is my first shot at it. Please excuse formatting. To find the maximum depth of the dependencies given a list of nodes, each having a unique string id and a list of subnodes it depends on, you can perform a depth-first search (DFS) to traverse the dependency graph. Here's how you can implement this: Represent the nodes and their dependencies using a dictionary. Perform a DFS on each node to find the maximum depth of the dependencies. Keep track of the maximum depth encountered dur"See full answer

Rudra pratap S. - "Spotify is platform which allows users to listen a variety of song from singers all over the world. It’s mission is to unlock the potential of human creativity by giving a million creative artists the opportunity to live off their art and billions of fans the opportunity to enjoy and be inspired by it. Goal: As we are entering in a new market goal could be acquisition followed by monetization. Pre-launch activities: · Understanding the competition. · Understanding the music taste of af"See full answer

Anonymous Spider - "1) Start by clarifying your constraints - which side of the marketplace am I focusing on and what are they solving for? (e.g., minimize cost for hoster, maximize comfort for renter indoor etc.). Assuming this is a "dealer's choice" type response then proceed to step 2 2) Where to focus: which customer segment, which job-to-be-done, and why I'd start by laying out segments on 2 dimensions: urban (think big cities, downtowns) and suburban (think suburbs, beach towns, mountains) areas focused on e"See full answer

Henry H. - "Overall, a successful Netflix viewing session requires that the user was able to find a piece of content that they loved watching. Now, to break this down, how we might define this: -Time browsing (from app open to content played) -Satisfaction --> inferred satisfaction: did user complete watching the piece of content? --> explicit: did the user rank that they loved the content (2 thumbs up)? The way I would evaluate a new Top Picks ML feature would be to implement an A/B test as follows: Te"See full answer