I had an technical interview out of HR and technical , The asked to code a medium level question on the same platform the OT was held on. While i was solving the problem, they were asking some core subjects, at the end they asked about the workflow and architecture of my project.

3 rounds, first- questions on SQL and dataframes, business case, second round- questions on SQL, third round- business case and SQL, mostly focusing on joins, window functions and repeat rate questions and checking business intuition