I applied job through hacker rank careers page. I got a email for solving the problem in hackerrank. Problem has three parts SQL,programming,Data Structures. After completion of the problem I got email after two days from hiring manager for next round o interview. Second round is on developing ETL pipeline through spark. Interviewer was very nice and explained all the problems clearly. I have solved executed pyspark code on jupyter notebook. Complexity is medium. After completion of second round hiring manager scheduled for third roun of interview through video conference. It covered areas on system design for building full blown click stream data processing pipeline for analytics. Third round is medium complexit. Interviewer is very nice and explained all problem statements clearly. Hiring manager informed me that I have cleared the interview and scheduled for onsite interview in hackerrank HQ. Onsite interview was very good. All the interviewers are very helpful and kind. Onsite interview has multiple rounds focusing on building data pipelines, system design and culture fit. Overall process is very clear and good.