Photon Interactive Lead Data Engineer Interview Questions and Answers

Interview preparation tips for other job seekers - I had read through the various experiences from people who interviewed with Tiger Analytics(TA) on many platforms, so i was hesitant to apply for roles that used to popup in my professional social media page.
However, there was this requirement for a role in TA, for which i recieved so many calls from different external consulting recruiters that i decided to keep an open mind, and submit to the interview porocess.
I was told that there would be 3 rounds of technical interviews and one HR round.
Usually,recruiting HR has a bad rep,but I would like to make the point here that the members of the HR tem in TA who interacted with me throughout this experience were utterly professional,kind and excellent communicators.
I had my first interview with a person,who i understood subsequently, was performing a role similar to the one I was interviewing for.At the end, I got the impression that I was cleared to attend the next round.
In the next round, the person I talked to was the Head of the Technical group ,to whom this role would report to.While the first round went deep down into technical aspects of the role, this round covered the breadth of my experience.
The feedback fom the HR after the second round was positive, and this is where the script started changing.
The HR informed that the third round would be a case study.I was given a case study by email, and asked to prepare a presentation.I read through the case study , and replied the same day,that 95% of the case study requirement was outside the bounds of the technical skills that I brought to the table, and were completely irrelevant for the role I had applied for.
I was re-assured by the HR representative , and the second round interviewer, that this was required to test my non-tech skills and asked me to prepare whatever i can.The case study docket even included documents on how to create a presentation.
The case study round was a horrible experience, where I found the interviewers to be
- dismissive
- exhibiting no respect for the candidate
-no respect for the time the candidate put in to prepare the presentation(while employed elsewhere)
-not aware whether the role I had applied for , and the case study had anything in common.
It was a bizzare experience, where I was summarily told that my presentation was not technically releavant to the case setudy.
Exactly my point!!!
They did not feel a common courtesy to switch on their video even once during this one hour discussion(I was talking to a black screen with unknown people) ,whereas , in every round of interview with TA, I was expected to switch on my video and hold my identity card by the side of my face on video, for them to take a snapshot(which I feel is reasonable given the instances of fraud that happens in recruitment circles).
Anyhow, after a week, first i received an automated mail, and then the HR rep was kind enough to personally call me , and inform that my profile would not be take forward.
Now I feel, I should have just trusted my instincts, and not wasted a singel moment of my life,on this experience with Tiger Analytics.