Walmart | Software Engineer-3 (IN3) | | May [Offer]
[ OK ]sLo1XHab7T — full writeup
[ INFO ]category: Behavioral · Onsite difficulty: difficult freq: first seen: 2022-06-03
[DIFFICULT][ONSITE]OnsiteSWE III (Senior)Accepted
$catproblem.md
Background:
Current Company: Product based fintech company
YOE: 4.7 Years
Round -1: Technical (1 hour 20 minutes)
The interview started with a discussion on projects I worked on in my current company. Then I was asked two DSA questions and some questions related to Java.
Move Zeros to the end: Move Zeroes (Leetcode)
Maximum Subarray Sum: Maximum Subarray (Leetcode)
You are given a list of countries, count the number of occurrences of each country and print them in ascending order of names.
You are given a list of names, print the names which don't start from 'a' using Java Stream APIs.
Difference between wait and sleep methods.
You are given two tables: project and employee, Write a query to list down names of employees who are not assigned any project. Do not use a nested query to solve this.
What is dependency injection? Discussion on different Spring bean scopes.
Use of @Qualifier annotation.
How you will define a step scope bean.
What is the difference between @Component, @Controller and @Repository annotation
Why were static and default methods in interfaces introduced in Java 8
Given two interfaces which have the same default method, there is one class implementing both the interfaces. Which default method will be part of this class.
What is a Binary Search Tree.
Difference between BFS and DFS.
When you will use LinkedList over ArrayList.
Discussion on Method Overloading, Overriding, Abstract class and Interfaces.
How to map database tables in Hibernate. @Entity, @Table, @Column annotations.
Write a REST API for saving employees' details in the database. Discussion on the MVC pattern.
TreeMap vs LinkedHashMap vs HashMap.
What is IAM in AWS? (AWS was in my CV, so this question was asked).
Comparable vs Comparator Interface and when to use which one.
Round 2: Technical (1 hour)
Design Twitter Search Engine.
Some questions on Elastic Search as I used it for designing the Twitter Search Engine.
Discussion on vertical vs horizontal scaling, consistent hashing, database partitioning and load balancing.
What is Parent POM and why do we use it.
How does a jar file reference other jar files.
You are getting ClassNotFoundException. You see that the class is present in the jar file you are referencing. How will you debug it.
Jar vs WAR file.
Synchronization in Java.
What modification will you make to HashMap to make it an O(N) time complexity.
Spring vs Spring boot.
Benefits of using hibernate.
Discussion on my current Project Architecture.
Round 3: Hiring Manager (45 Minutes)
The interview started with a brief introduction and discussion about the projects I have worked on and my roles and responsibilities in my current organization. Then the interviewer described the team I will be working with and the projects I will be working on if selected.
Some situation-based behavioral questions were asked. I can remember some of them.
How will you handle the requirements that came at the very last moment and need to be delivered quickly.
The team is very new and you are one of the founding members of the team where you also need to be involved in building the team. How will you approach this.
Round 4: HR (20 minutes)
In this round, some HR questions like why you want to change the job, why Walmart etc. were asked. Then HR discussed the salary structure and perks at the company and some other company policies.
I got the offer after two weeks of the interview process.