I've currently gone through two technical rounds and am waiting for the next hiring manager round.

There should be a total of three rounds:

• Two technical
• One hiring manager

The first round was pure SQL coding. I went through three SQL questions on HackerRank. The difficulty was at most medium.

The second round was based on my resume experience. We covered streaming processing and Kafka understanding, followed by questions on optimizing Kafka consumer lagging and data skewness issues in Spark.

For the remaining 30 minutes, we went through a simple SQL question, a simple Python question (not even an algorithm question), and a system design question in brief.