Walmart | SDE II | Bengaluru | September 2024 [Offer]
Summary
I successfully interviewed for the SDE II role at Walmart Global Tech in Bengaluru. The process included an online assessment with coding and MCQs, followed by three technical rounds covering DSA, core CS concepts like DBMS and Networking, and project discussions, ultimately leading to an offer.
Full Experience
I recently interviewed for the Software Development Engineer role at Walmart Global Tech in Bengaluru. The process kicked off with a CGPA-based shortlisting, leading to an Online Assessment on the HirePro platform. This was followed by three intense technical interview rounds. I'm thrilled to share that I successfully received a full-time offer!
Online Assessment
The Online Assessment, held on September 2nd, was 1 hour and 15 minutes long. It comprised 22 technical MCQs covering OOPS, OS, DBMS, Networks, and SQL, which I had 35 minutes to complete. Following that, I tackled two easy-to-medium level coding questions in 40 minutes. I managed to pass all test cases for both problems, which helped me advance to the next round.Round 1 (Technical Interview 1)
This round lasted about 1 to 1.5 hours and was conducted physically on campus. The interviewer, an SDE 3 with 9 years of experience, started with an introduction, and then I introduced myself. The discussion then moved into a deep dive on my resume, specifically my projects. I felt confident answering all questions related to them. We then moved to DBMS, where I explained different types of SQL queries with examples. The interviewer also provided two simple SQL tables and asked me to perform various joins on paper, explaining the output. Next, we discussed Computer Networks; I was asked to explain what happens when I message a friend on WhatsApp, which I detailed by walking through the entire OSI layer on paper. Time ran out before we could discuss OS concepts, though others were asked about virtualization, segmentation, fragmentation, and cache.Round 2 (Technical Interview 2)
Immediately after Round 1, I received a call for Round 2. This interviewer was a very senior engineer with 18 years of experience at Walmart. After my detailed self-introduction and project explanation, she was impressed and didn't delve much into my projects. She then presented a classic DSA problem: Print Matrix in Spiral Order. Although I was familiar with it, I approached it methodically, explaining my thought process from scratch and performing a dry run of my code. She seemed quite pleased with my explanation. Towards the end, I asked her about her daily responsibilities and what areas I should focus on for improvement.Round 3 (Technical Interview 3)
This round, which was originally supposed to be an HR round but was converted into a technical discussion due to a single HR, lasted 1.5 hours, despite being slated for 20 minutes. I was one of 10 candidates selected for this round and had to wait about two hours after Round 2. The entire discussion revolved around my projects and internship experience. I was challenged with various situational questions related to my projects and managed to answer them all effectively. Much of the time was spent discussing problem-solving approaches and finding optimal solutions. My approach and solutions clearly impressed the interviewer. I concluded by asking him about Walmart's work culture and his job details.The results were announced quickly after all interviews concluded, and I was among the 6 people who received a full-time offer. I was ecstatic to get the good news from the HR.
Interview Questions (5)
Given an array of integers, for each number in the array, find and return the count of its factors. The provided solution iterates up to the square root of the number to find factors efficiently.
Given a string, perform the following operations: 1. Remove all special characters (e.g., @, !, #, [, ]) and spaces. 2. After removal, iterate through the modified string and swap characters whenever a vowel is immediately followed by a consonant. Other character pairs (consonant-vowel, consonant-consonant, vowel-vowel) should remain unchanged.
Given a 2D matrix, print its elements in spiral order.
Given two simple SQL tables, demonstrate all types of SQL joins (INNER, LEFT, RIGHT, FULL OUTER) and explain their respective outputs on paper.
Explain the end-to-end process of sending a message to a friend on WhatsApp, detailing what happens at each layer of the OSI model.
Preparation Tips
My preparation primarily focused on being very clear with fundamental CSE concepts. I ensured I knew everything in great depth about what I had listed on my resume. I practiced explaining all my projects and work experience in detail, as this helps demonstrate genuine involvement and understanding.