Drive | ALM Org | 4 YOE

Round 1 (tech):
/*

Problem Statement — Active Users in a Sliding Time Window

#---------------------------------------------------------------------------#

Context

You are building an analytics component that processes a continuous stream of application logs in real time. Each log record represents a user activity event within the system.

#---------------------------------------------------------------------------#

Input

You receive a stream of log entries, each represented as a tuple: (timestamp, userId, eventType)

where:

timestamp — an integer representing the event time in seconds (increasing over time).

userId — a string or integer identifying the user who performed the event.

eventType — a string describing the type of event (e.g., "login", "view", "click", etc.).

#---------------------------------------------------------------------------#

Task

Implement a function that processes this event stream and, at any given point in time, reports the number of unique users active in the last 5 minutes

A user is considered active if they have generated at least one event within the past 5 minutes relative to the current event’s timestamp.

Round 2 (tech):

https://leetcode.com/problems/most-stones-removed-with-same-row-or-column/description/

Questions on java

multiple threads trying to modify same data structure - list/array/map
what to do in that case

shallow and deep copy of object with examples

Questions in deep of SQL architecture

ways of establishing connection to sql server

how will you identify if sql query is running slow, what will you do to improve

details about jdbc, write code how have you used it

is sql db consistent

discussion on master slave architecture, consistency

data isolation

Round 3:

Most complex project, draw HLD, some questions on it

conflict in design with senior sde

what do you look for when designing an approach

why adobe

why looking for change

Detailed schema design of book my show, with navigating entire flow of finding a movie ticket and step by step table schema you will need to move to next step