Reflecting on a memorable interview experience with Kotak Mahindra Bank for the SDE-2 (Data Engineering) role! 🌟 It comprised four stimulating rounds, featuring two bar raiser and two internal rounds.

Round 1: Delved deep into DS & Algo, SQL data modeling, and Data Warehousing, setting the stage for a robust discussion.

Round 2: Focused on Pipeline designing and Spark, challenging me to showcase my skills in designing efficient data pipelines.

Round 3: Dived into SQL and Spark optimization, where I had the opportunity to demonstrate my expertise in enhancing performance.

Round 4: A dynamic mix of everything, including streaming and writing ETL for various scenarios, truly putting my skills to the test.