I first saw this role on LinkedIn. I applied for it and got a call from a recruiter after a week or two.

She was nice and asked about my background and some basic questions. After that, she set up a coding interview with the hiring manager.

TBH, I was not very well prepared for it, and the hiring manager was very nice and patient. There were two sections:

1. SQL
2. Python

SQL questions were easy, like questions using RANK, DENSE_RANK, LEAD, LAG window functions.

In Python, he asked a simple question, and I made a mistake there.