Ho presentato la mia candidatura online. La procedura ha richiesto 5 giorni. Ho sostenuto un colloquio presso Zypp Electric (Gurgaon, Haryana) nel mese di gen 2026
Colloquio
It was a good interview with interesting excel and sql questions. He asked the questions related to my current role, my day to day work, My background and my past experience. It was a virtual round.
Domande di colloquio [5]
Domanda 1
Can you provide an overview of your background and experience? What are your responsibilities as a Data Analyst in your current organization?
Gave An excel question - column a has numbers like 1 1 1 2 2 2 2 3 3 Expected output is - 1 2 3 1 2 3 4 1 2, write a formula in excel to get the expected output, basically the solution is to give ranking using formula - countif($a$2:a2,a2)
Second excel question - id date status 101 01-01-2025 Active 101 13-01-2025 Inactive 102 17-01-2025 Active 102 21-01-2025 Inactive So fiter the date to only show the row for each id having the highest date for each id.
One sql question - You are given a table called seats, which represents seat allocations in a movie theatre. Each row represents a seat and whether it is currently booked or empty. sample data seat_id status 1 booked 2 empty 3 empty 4 booked 5 booked 6 empty 7 empty 8 empty 9 booked 10 booked write an sql query to find all consecutive sequences of empty seats. For each sequence return - the starting seat_id, the ending seat_id and total count of consecutive empty seats. expected output - starting_seat_id ending_seat_id count_empty_seats 2 3 2 6 8 3