Sharing HWI L3 interview experiences
Below are rhe experience for the interviews that happened in my college.
Interview depends on your resume, if they ask you normal simple questions that means they will not be hiring you most probably.
Those who get in depth questions and interview revolves around advanced topics like system design then that is good.
: Round -1 physical
Dsa question
Partition sum into two equal subset
Maximal rectangle
Super ugly number
Have to solve on leetcode
SQL query
All students even if they don't have subject (left join)
Student have more that two subjects
3rd highest Salary
3rd highest if it has duplicate dense_rank
Resume related
Dependency injection
5 annotation of spring boot
SQL vs noSQL
Round 2 virtual
Singleton design
Asked me to implement it on notepad
Java vs python
: Role:l3
Offline screening round
Dsa:lis,number of islands,subset sum skipping the adjacent elements.
DBMS:return the employee who has recently joined the organization,
Then,2 tables were given we have to return names of the students along with their courses including null values too .
Others: atomicity scenario based question,polymorphism, acid properties, about ml if you have done any project .
Then why composite key is used when primary key is already there .
[12/05, 1:30 pm] +91 83187 83239: Role-L3
In the offline round, the interviewer asked one DSA problem: finding the next minimum greater number by rearranging the digits (Next Greater Permutation).
In the virtual round, the discussion was mainly around Core Java and backend concepts. Questions included:
- Internal working of HashMap
- Comparable vs Comparator
- Spring Boot basics
- Monolithic vs Microservices architecture
- SOLID principles
Interestingly, no SQL questions were asked. The interview was focused more on Java fundamentals, OOP concepts, and backend development knowledge rather than database-related topics.
: Role. L3
OFFLINE ~50min
In DSA: 25min both
1.N queens approach + pseudo code
- Coin change (brute force + optimised)
In sql: 2 queries one query is simple subqueries and another one is combination of aggregate and window function
In OOPS + language specific:
multi threading, process vs thread, exception handling, types of typecasting in java, types of exception, polimorphism
ONLINE ~30 min
In project:
Complete depth if solo project based on your project introduction...
Each connection of backend and database and how it is rendering in frontend
Moreover indepth tech stack questions
Difference and modification from old to new resume
Latest features you have implemented
USP of your project
How is it different from a million dollar company
Inspiration behind this project
HR questions:
What is your career aspiration
Where do you see yourself in next 4 years
Are you looking for further studies after btech
: Role : L3
35 min online interview round
20 min dsa round
At first there was online round
In which they first asked to introduce myself
Then these questions
- what is static keyword , what happened if we make a main function without static keyword
- differentiate between throw and throws
- differentiate between hashmap and linked hashmap and deep dive in hashmap working
- shallow copy and deep copy difference
- then in detail discussion on SOLID principles
- differentiate between delete() , truncate() and ,drop() in DBMS
- Ask about 2nf and 3nf
- difference between sql and nosql
PROJECT
- Explain in detail about project
- what step u make to make it scalable lets say around 1M users
- and deep dive into scalability
- Api integration
- async api call using promise.all()
Dsa round
Lis printing and talk deeply into its working and also gave variations questions around lis which i have to explain
Sql - A table is given for matches between two teams — write a query to identify the number of times each team played and the number of wins for each team (use GROUP BY on multiple attributes)
: OFFLINE ROUND
SELF INTRODUCTION
SQL
Write an SQL query to group patients according to weight ranges of 10 and display the total number of patients in each range. The ranges should be formed like 0–9, 10–19, 20–29, and so on, and the result should be displayed in ascending order of weight range.
Write an SQL query to retrieve the first name and last name of patients who do not have any allergies.
DSA
Coin Change
N-Queen Problem (Explain Question )
Median of Two Sorted Arrays
DBMS
Transaction
ACID Properties
Inheritance
ONLINE ROUND
Introduction
(Course, Semester & Strengths Only)
Deep Dive Into Project
SQL vs NoSQL
ACID Properties
Synchronous Communication vs Asynchronous Communication
Deadlock
Inheritance
Multiple Inheritance
SOLID Principles
L3 Role:
SQL Question print employee_id where employees salary> avg salary.
Print Spiral Matix
Abstraction, interface vs abstract,
Html elements, div, span
Cloud instances, services
Also I had given virtual interview:
He asked,
Logistics Regression, random forest, Decision tree, virtualization in cloud, types of cloud etc.
Suggestion: Please remove all the topics, tech stacks in which you are not confident and also don't mention your branch in your resume as he can ask topics related to branch academics.
Thanks!!
: L3 Role:
SQL Question print employee_id where employees salary> avg salary.
Print Spiral Matix
Abstraction, interface vs abstract,
Html elements, div, span
Cloud instances, services
Also I had given virtual interview:
He asked,
Logistics Regression, random forest, Decision tree, virtualization in cloud, types of cloud etc.
Suggestion: Please remove all the topics, tech stacks in which you are not confident and also don't mention your branch in your resume as he can ask topics related to branch academics.
Thanks!!
: L3 role: Detailed
I had given 2 rounds
First I had done with physical interview along with 4 people where he only asked 1 dsa problem
The problem
There is a string of size n
You have to count the longest non repeating subsequence in the string and return the answer
So I had solved this question in 10 min and after that the interviewer discussed my solution.
He also gave some test cases to run and analyze.
After that he asked that can you solve it in optimised approach.
I tried but failed to do so.
Btw all code on pen and paper only
Then he refers me to the online interviewer over call.
Basic questions
Introduce yourself
Dsa solution discussion
Diffrence between truncate, delete, drop
Acid property
Diff between encapsulation and abstraction
One question related to my ML project
What's diffrence between precision and recall
With that he ended the interview
: L3
Two DSA problems
1.A tree is given - print Top view and bottom view
Coin change
A table is given for match between two teams - write a query to identify the number of times each teams play and number of wins for each team
In virtual
Only asked questions from my project
system design questions asked based on my project
: For L3
Two dsa problems
Print lis
String Processing Problem (First or Last Occurrence)
You are given a string s consisting of lowercase English letters and a mode of operation:
If the mode is "FIRST", print each character of the string only the first time it appears, maintaining the original order.
If the mode is "LAST", print each character of the string only at its last occurrence in the string
3 . Sql query
A table is given for match between two teams - write a query to identify the number of times each teams play and number of wins for each team
( Group by was used on multiple attributes )
-> In virtual round
There was a deep technical discussion in the interview where I was asked several concept-based and problem-solving questions related to my project
: L3
Two DSA problems
1.A tree is given - print Top view and bottom view
Coin change
A table is given for match between two teams - write a query to identify the number of times each teams play and number of wins for each team
In virtual
Only asked questions from my project
system design questions asked based on my project
: *L3 Experience*
L3 have two rounds
Offline
Online
Sum of perfect square
Partition DP
Given two tabled find district row/column or anything
Solid Pricipals in depth
Design pattern -Singelton
: For L3 .
First there was an offline round in which he gave two questions.
1st = print the bottom view of the tree.
2nd = maximum sum in a circular subarray (optimized code ).
Then he asked to write a SQL query
A table was given containing:
Team ID
Team 1
Team 2
Winning Team
Here, Team 1 and Team 2 columns contained the names of teams that played against each other, and the Winning Team column contained the name of the team that won the match.
The task was to create an output table containing:
Team Name
Number of matches played by each team
Number of matches won by each team.
Then the second round was virtual.
First he asked me to introduce myself and to explain my project.
Then he took 5 min break in that break he was just reading my resume. And then he started with project and ended with database of project....
That's all.....
For the L3 interview, there will be 2 rounds:
First Round – Offline
Second Round – Online
### First Round Focus Areas
* DSA (Data Structures & Algorithms)
* DBMS
* SQL
* Tech stack mentioned in your resume
### Second Round Focus Areas
* In-depth project discussion
* How you scale your project
* System Design
* SOLID Principles
* Singleton Design Pattern
* Scenario-based questions
### Final Interview Tips
#### For DSA
* Write optimized code as much as possible.
* Clearly mention Time Complexity and Space Complexity.
* Explain your approach properly .
* Dry run your solution with test cases.
* Handle edge cases carefully.
#### For SQL
* Prepare easy to medium-level SQL queries.
* Focus mainly on:
* Joins
* Subqueries
* GROUP BY
* Aggregate functions
#### Resume Tips
* Remove unnecessary points from your resume.
* Whatever you mention should be backed by strong fundamental knowledge.
* If you mention cloud technologies, be prepared for practical implementation-related questions as well.
#### During Explanations
* Try to give real-world examples for every concept you explain.
* Give detailed answers instead of waiting for follow-up questions from the interviewer.
#### For Project Discussion
* If the interview is offline, use pen and paper to explain:
* Complete architecture
* Workflow/pipelining
* End-to-end project flow
* Be ready to discuss your project in depth.
#### Tech Stack Preparation
* Have detailed knowledge of every technology mentioned in your resume.
* Be prepared for “why this technology?” and “how does it work internally?” type questions.
Overall, the interview mainly checks:
* Problem-solving ability
* Depth of technical knowledge
* Practical understanding
* Communication and explanation skills