I applied for a job through the HackerRank careers page and received an email to solve problems on HackerRank. The problem set included three parts: SQL, programming, and data structures.

After completing the problems, I received an email from the hiring manager two days later inviting me to the next round of interviews. The second round focused on developing an ETL pipeline using Spark. The interviewer was very nice and explained all the problems clearly. I executed PySpark code on a Jupyter notebook. The complexity was medium.

Upon completion of the second round, the hiring manager scheduled a third round of interviews via video conference. This round covered system design for building a full-blown clickstream data processing pipeline for analytics. The third round was of medium complexity. The interviewer was very nice and explained all problem statements clearly.

The hiring manager informed me that I had cleared the interviews and scheduled an onsite interview at HackerRank HQ. The onsite interview was very good. All the interviewers were very helpful and kind. The onsite interview consisted of multiple rounds focusing on building data pipelines, system design, and culture fit. Overall, the process was very clear and good.

Basic programming data structures.

SQL distributed data computing using Spark.