I applied online. The process took 3 weeks.

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 questions involving data manipulation using 2 dataframes/csv.

SQL:

• Find avg of top merchant where mode is online (given 2 tables, merchant, payment)
• Find average & sum of each merchant category for the last quarter.

PySpark:

• Have 3 CSVs - movie (rating, box office, genre, etc.), actor (id, name, etc.), movieActorMap. Find the total box office of actorA, whose film is in GenreA and having rating > 5.
• Get top 3 actors, by sum of box office, acted more than 6 films, rating > 5.
• PySpark internals question, coalesce() vs repartition() - when does shuffle happen?

Unix: Basic file commands, grep, zip, etc. Find the latest 3 files starting with "Latest" and zip it to this location.