I applied through university. The process took 1 day. I interviewed at ZS Associates (New Delhi) in Mar 2022
Interview
ZS conducted a Campus Beats program in march 2022. It was for students graduating in 2023. Students can take part individually or in a team. There were two challenges. Case challenge Tech challenge I participated in a team and took the tech challenge. It was a 6 hours test and only one team member can give the test. The Tech challenge consists of 3 sections. The first consists of 2 coding questions and the difficulty level are easy-medium. The next section is in the frontend and there were 2 questions (HTML/CSS/Javascript). The last section is DBMS and has 3 SQL questions. The results were declared in April and we cleared the tech challenge. We were given 3 roles and we have to choose one from them. I opted for the BTSA- Business Technology Solution Associate role. Technical Interview: I was a simple 30 mins interview conducted on the Monjin platform comprising of questions from the profile, resume Human Resource(HR), DBMS, SQL queries, and puzzles.
Interview questions [1]
Question 1
ntroduce yourselves. Explain any one project written in the resume. Difference between delete, truncate and drop. What are DDL and DML? Explain joins and their types. What is indexing and its types? What is a trigger? what are the primary key, foreign key, and candidate key? SQL query: find the 4th highest salary in the table. SQL query: join tables. Puzzle: find the age of mother and daughter. Puzzle: find the speed of the train according to car speed. Puzzle: 8 balls puzzle.
OA -> Technical coding rounds -> Tech interview -> HR Round -> selected. The Tech Round was on medium level SQL and project related.
It went pretty smoothly, I was asked some guessimates and puzzles in the HR round.
Interview questions [1]
Question 1
What will i do if i do not get the offer? (In HR round)
I have give 2 rounds of interview. one is SQL and another one behavioral and Gen AI. then they asked about case study based question and my project and experience.
The interview was average, with more focus on SQL and the resume. I was asked SQL in both the interviews. The questions were asked on resume too so prepare it thoroughly