Round 1: HR Screening Phone call focused on salary expectations, current role overview, notice period, and relocation willingness. Straightforward screening. Round 2: Technical Discussion Video call diving deep into current work experience. What kind of work I did in current organisation, about team work, ownership, impact, etc Round 3: Pair Programming + Technical Deep Dive Live coding round - codesignal platform SQL Coding : Two medium-hard problems involving window functions, date filtering, ranking, CTEs, and complex multi-table joins. Unix Commands : Three practical questions testing hands-on command knowledge (file finding by modification date, pattern matching, archiving). PySpark Coding: 2 question involving data manipulation using 2 databrames/csv

A hackerrank test is told to solve while the interviewer asks you to share you screen. The interviewer asked to open the hackerrank link attached in the jd and afterwards gave questions one by one. The questions were on sql , whiteboarding that is to create visualization and what's wrong with viz means what is wrong with power bi chart shown and we had to tell it and explain the solution. Time frame for each question was very less