Story of getting no offer after getting positive feedback in all rounds (strong yeses in technical rounds).
As seen in past reviews here, they did take a lot of time to process/respond between each round. Definitely, they don't have a defined process or skills for hiring.
The first round was a screening round; they postponed the first round after a week, all of a sudden. Next week, the interviewer again didn't join for 10 minutes because he wasn't aware of it!! But they joined after following up with HR.
Then had two technical rounds (coding and system design). In the coding round, they asked for Python code on DSA (simple one using a stack). Then a few SQL questions (window functions-based) and then a little bit on Spark technicals.
The system design round was about architecting a pipeline as per a given requirement.
Last was the behavioral round. When I joined, he said he was not supposed to take this round, but he still took 30 minutes and told me it would get rescheduled!!
Later, this round was rescheduled. Again, the interviewer didn't join on time, but he made it post a few minutes.
Questions were normal ones, like what are your negatives/positives, and a few scenarios based on my earlier projects and challenging tasks.
Post this, they ghosted!
After a week of reviewing, I was told even though all rounds were positive, they were not going ahead because I didn't answer one question in the behavioral round to their expectation!
I respect the decision, but the interview process also had so many flaws that they couldn't fix, but they expected the candidate to be flawless. Crazy!
Stack-based Python question regarding finding the k nearest neighbors.
SQL questions around window functions.
The following metrics were computed from 1 interview experience for the Apollo.io Senior Data Engineer role in Bengaluru, Karnataka.
Apollo.io's interview process for their Senior Data Engineer roles in Bengaluru, Karnataka is extremely selective, failing the vast majority of engineers.
Candidates reported having very negative feelings for Apollo.io's Senior Data Engineer interview process in Bengaluru, Karnataka.