Multiple rounds with many people, several information sessions, constantly ignored by HR who seemed overworked. In the end, I got a rejection email addressed to {CANDIDATE NAME] after the final round. They couldn't even bother to get my name populated in the email after spending 20+ hours on this opportunity between interview time & case study work.

Brush up on SQL concepts. Leetcode is a good resource (including window functions). Prepare stories in the star format on leadership principles. Prepare 2-3 stories each. Interviews tend to go jn detail so make sure you have the depth