Walmart | SDE 3 | | Offer

Current Years of Experience : 4.6 Position : Senior Data Engineer Location:

Round 1 Data Structures and Algorithms Round: Two Leetcode Medium questions were asked. Q1: Given a linked list, arrange all odd numbers in the beginning and even numbers in the end. This is similar to the Leetcode problem "Odd Even Linked List". Q2: Once odd and even are arranged, sort odd and even numbers. This is similar to the Leetcode problem "Insertion Sort List".

There were some project related questions and some questions on Spark.

Round 2 Domain Round. SQL : The interviewer started with some DBMS questions(Indexing, Co-related queries). Later, he asked to write three SQL queries involving groupBy, self join and subqueries followed by some questions on Airflow. Spark: Discussed statistics in Spark, use of statistics, how the Cost Based Optimizer works, partitioning schemes in Spark(hash, range and round-robin). Scenario based questions on performance tuning. Tools used for Spark profiling, etc. Spark ACL.

Star vs snowflake schema, questions on security in distributed systems, Authorization vs authentication, Kerberos and its working principal, etc.

Round 3 Hiring Manager Round Discussed my current project design in detail, questions related to current project design and why we took certain decisions while designing. Questions about my tech stack. Some behavioral questions.

All the interviewers were polite, calm and provided enough time to come up with the solutions.