I have interviewed with them multiple times. The interviews were okay. But, the HR ghosted in the middle of the interview process every time without any automated rejection replies or any kind of feedback.

Describe a project that you have done. Discuss the overall flow of how it works. The problem is given time series data which is a clickstream of user activity stored in Hive. The ask is to enrich the data with a session ID using Spark. The session definition is that a session expires after inactivity of 1 hour. The data consists of click_time and user_id, with examples such as 2018-01-01 11:00:00,u1, u1s1 2018-01-01 12:10:00,u1, u1s2 2018-01-01 13:00:00,u1, u1s2 2018-01-01 13:50:00,u1 2018-01-01 14:40:00,u1 2018-01-01 15:30:00,u1 2018-01-01 16:20:00,u1 2018-01-01 16:50:00,u1 2018-01-01 11:00:00,u2 2018-01-02 11:05:00,u2.