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.
The whole interview process had 3 rounds of 1 hour each.
🔸 The first round was an extensive discussion about the projects I was handling and a few coding questions on SQL & Python.
There were questions like the following: → Optimisation techniques used in projects; Issues faced in the project; Hadoop questions.
🔸 After clearing this round, I moved on to the next round, which was a Case-Study based round.
I was asked scenario-based questions & the interviewer asked multiple questions on Spark, like: → Spark job process; Optimizations of spark; Sqoop interview questions.
After this, I was asked a few Coding questions & SQL coding questions, which I successfully answered.
🔸 Lastly, there was a Managerial Round where I was asked a lot of technical and advanced questions like: → Architecture of spark, hive, Hadoop; Overview of MapReduce job process; Joins to use in spark; Broadcast join & lastly Different joins available.