The Hiring Manager contacted me via LinkedIn and provided a link to apply for a role.

Initial phone interview: I answered a couple of SQL questions (average).

Final Round with 4 + 1 Hiring Manager:

Round 1 was with a skip-level manager for this role. They had some audio and video issues initially. Once settled, they asked me one SQL question (average) and a couple of LPs.

Break for an hour.

Round 2 was with the Bar Raiser, sometime in the afternoon, likely after lunch. They focused on LPs only and were yawning throughout the interview. It ended in 35 minutes.

Round 3 was a SQL interview. They asked three questions, ranging from average to difficult, and it was interesting. I found their knowledge to be at my level, so it was engaging.

Round 4 was a Data Architect interview. They gave me a case study to model the database. It was interactive and engaging.

Round 5 was with the Hiring Manager on ETL Design. They gave me a case study to design. It was a little difficult after a couple of follow-up questions, and then they moved on to LPs. They asked similar questions to those from my Bar Raiser.

Typical Behavioral Questions:

Tell me about when you took on something significant outside of your area of responsibility.

Tell me when you worked through tight deadlines.

Tell me a time when you had a conflict with your peer.