Applied for the role initially and received my invitation to interview for round 1 nearly two months later. I scheduled the first interview and got ghosted because no one decided to show up. I emailed the recruiter asking to reschedule, they apologized saying “an emergency happened”, and rescheduled me for the following week. The first round was mostly behavioral, a couple minor case study type questions that were meant to observe how you think. It was not super intensive, I passed and received a second round interview. Once again, I scheduled it and was ghosted again, being told that an emergency came up. I rescheduled for the following week. The second round interview was half analytical/decomp and half learning/coding. The decomp problem was pretty difficult, they say they do not judge you on SQL knowledge but make sure you know as much SQL syntax and theory as possible. I answered it to the best of my ability, I feel decently well. The coding question they taught a made-up language that was basically SQL. Just practice Leetcode or other problem-solving tools to improve your SQL knowledge, that’s the best way to go about it. I was rejected after the second round, I do think it was a fair rejection and I didn’t perform super well in the coding interview. But super unprofessional company overall and the ghosting process was really frustrating as I took time off work to interview.