Deloitte

I was searching for a job and preparing myself for the desired role. In that search, I applied to an open position at Deloitte, which really was a great move for me to have my first company switch.

It was an online interview. They mainly focused on SQL, PySpark, and warehousing. They asked about these topics, specifically SQL joins and queries, and in PySpark, DataFrame operations and merge logic for SCD Type 2.

First interview with HR to pass a preliminary screening. Second with the team leader you'll be assigned to. Among several candidates, they choose the best in both interviews, with the team interview carrying a bit more weight.