Round 1 - Online Assessment (90 Minutes On Hackerrank)

🔹 2 coding questions which I had to solve using python, first question was related to simple lists and other questions was related to regex

🔹 There were couple of datasets along with table schemas then I had to solve 4-5 SQL questions around that which were related to Group By, Joins, Correlated Queries

Round 2 - Technical Telephonic

🔹 Questions about my past background and projects

🔹 Fundamental questions of Apache Spark

🔹 Fundamentals questions about NoSQL databases, specifically Cassandra

🔹 Difference between Row_Number, Rank and Dense_Rank window functions

🔹 SQL question which was related to running sum

Round 3 - Machine Coding (2 Hours)

🔹 They provided me their laptop and had their own cloud setup

🔹 It was a huge problem statement related to F1 data and broken into multiple questions which I had to solve using PySpark

🔹 They provided multiple CSV files as datasets and I had to code for those 7-8 questions related to data processing

🔹 Interviewers allowed me to refer official documentation page of Apache Spark for any kind of help

Round 4 - Technical

🔹 Discussion related to machine code round and approaches which I used to solve those questions

🔹 Difference between Row_Number, Rank and Dense_Rank window functions

🔹 Given 1 table of wynk music data with sample rows, interviewer asked adhoc SQL questions around that which were related to window functions, aggregations, joins

🔹 DSA Question - Given a singly linked list and detect a loop in it

🔹 DSA Question - Given a sorted array of numbers, write code to create Binary Search Tree out of it

Round 5 - Aptitude (With Analytics Manager)

🔹 General discussion about my past experience

🔹 Very basic puzzle

🔹 Basic aptitude questions related to time & work

Round 6 - Hiring Manager

🔹 Question related to my previous work experience and projects

🔹 What kind of challenges i faced in different projects and how did i solve those

🔹 Design data warehouse for 7-11 or 24x7 kind of stores

He received the offer letter after the final HR round..😊