Bloomberg BNEF Analyst interview questions

One of the worst interview experiences I've ever had. Extremely long drawn and no transparency on what the process will be like - just wait and follow instructions. I had 3 initial interviews over 1 month - with the recruiter, the HOD and an associate, and then two other HODs. The 4th step was an excel-based assessment, after which I was scheduled to have another 30-minute interview with the same HODs (which also took 4 weeks to schedule after 2 last-minute cancellations on their end). I was given no context on how this conversation would be structured. On joining the call, they began to quiz me about my responses to the assessment, after which they quickly realized that the recruiter had sent me the wrong data and so it wasn't the work they were looking for. After a few moments of silence and sighing, they decided to handle that by surprising me with a live excel exercise on Zoom. They didn't even send me the data, I had to see the data on screen-share on their computer, so I couldn't search the data or scan all the rows - only see the 3 rows visible to me on his screen share. Obviously that meant that I missed some data anomalies in the table, which skewed the charts. What was meant to be a 30-minute call was already an hour long and they asked if I could stay even longer, for an exercise I hadn't been told about, with data I couldn't even touch or see myself. It did not seem like an exercise they do with all candidates, given this was meant to be a short call. I feel unfairly and unreasonably treated because their recruiter messed up by sending me the wrong dataset. Shockingly, after that call, I had a chillingly cold final interview, where it was clear they had already given up on me based on the previous interaction. After 2 weeks of silence, I got an automated rejection and there goes 8+ hours of my time and a 2+ month long recruiting process.

The interview process was fine at the beginning, I progressed through two rounds and one written assignment, and then the HR ghosted me. After reaching out multiple times - with no updates - they invited me for a 2-hour interview, which went really well. After 3 weeks, I asked for updates, and I got an automatic message saying that they went for another candidate. Probably the worst interview experience I have had so far.