The interview had two rounds total. First round is a SQL coding interview, and the second round is 2 back-to-back case/technical interviews. Be prepared to answer statistics/AB testing and eCommerce related metrics questions. Very well structured interview process. Took about 4 weeks to go through the process and got results.
Interview questions [1]
Question 1
based on given data sets/structures, writing SQL queries to answer questions asked.
I applied through a recruiter. The process took 1 day. I interviewed at Walmart (Bengaluru) in June 2018
Interview
Interviewed at Bangalore Office in Marathahalli on 2nd June 2018. Three rounds. 2 technical 1 manager. 1 st round : 2 programs.
2nd round : Resume based. Mostly concentrating on ElasticSearch because they were working on that.
Manger Round : 2 coding and one design problem.
Overall interview went well. The HR said we will get back to you in one day. But didn't get any response for one week. After that I use to call/mail them once in every week. They kept saying give us some more time as we are still deciding. The last time called was 20 days after the interview when the HR apologized for the delay and said give us two more days, we will definitely get back to you. But still no reply. Then after 5 days (25 days after interview) I mailed the HR to which she replied we can't proceed with your candidature.
They are not transparent when it comes to the interview process.
Interview questions [3]
Question 1
Manager round question: Height of binary tree with and without recursion. Desing a booking system (basically propose a design with all possible tables in the database)