I applied through a staffing agency. The process took 2 months. I interviewed at Levi Strauss (Bengaluru) in Jun 2021
Interview
The interview covered topics related to Big Data, Machine Learning, and Cloud. The complexity level was medium, and I was given some hands-on scenarios to solve. Overall, it was a positive experience.
Two rounds of interviews. The first one is a phone call from an HR asking general questions (like why Levi's, why are you interested in your selected jobs)
The second round is a technical interview, not too hard only a few database-related questions
Interview questions [1]
Question 1
Suppose you are managing a student database, one table has test scores, and one table has student information. The key to both table is student id.
1: how to obtain all information of students who have average scores over 90%? 2. What is the time complexity of q1 if all tables are not partitioned? 3. Explain the retreival process if tables are partitioned.