This is Bloomberg's round one, if qualified there would be 3 more rounds (1 coding/ 1 systems design and 1 HR round).
The interviewer structured the 1-hour interview into four segments:
- Discussion about my previous projects
- SQL assessment
- Data Structures and Algorithms (DSA)
- Spring Boot knowledge (this role required strong Spring Boot experience)
SQL:
The SQL question was straightforward.
Given two tables:
Employee(id, department_id, salary)Departments(id, name)
Find the department(s) with the highest average salary.
Constraints:
- Return only the department(s) with the maximum average salary
- If multiple departments share the same maximum average salary, return all of them in any order
DSA:
The DSA question was a leetcode hard question:
Sliding Window Maximum
https://leetcode.com/problems/sliding-window-maximum/description/
Spring Boot:
I was asked to write a sample REST API using Spring Boot annotations.
Comments (11)


