Telegram Web Link
Now you can subscribe to our Instagram channel for the exclusive content

www.instagram.com/dataspoof
https://www.instagram.com/p/C5zlrxPy0Dw/?igsh=cXc1cjNrbTA2MjJy

Tiger analytics data engineering interview questions
Here's what the average data engineering interview looks like in 2024:

- 1 hour algorithms in Python
Here you will be asked irrelevant questions about dynamic programming, linked lists, and inverting trees

- 1 hour SQL
Here you will be asked niche questions about recursive CTEs that you've used once in your ten year career

- 1 hour data architecture
Here you will be asked about CAP theorem, lambda vs kappa, and a bunch of other things that ChatGPT probably could answer in a heartbeat

- 1 hour behavioral
Here you will be asked about how to play nicely with your coworkers. This is the most relevant interview in my opinion

- 1 hour project deep dive
Here you will be asked to make up a story about something you did or did not do in the past that was a technical marvel

- 4 hour take home assignment
Here you will be asked to build their entire data engineering stack from scratch over a weekend because why hire data engineers when you can submit them to tests?
DataSpoof pinned «Here's what the average data engineering interview looks like in 2024: - 1 hour algorithms in Python Here you will be asked irrelevant questions about dynamic programming, linked lists, and inverting trees - 1 hour SQL Here you will be asked niche questions…»
𝗣𝗪𝗖 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗘𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲 (𝗗𝗮𝘁𝗮 𝐄𝐧𝐠𝐢𝐧𝐞𝐞𝐫)

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.
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.
Cicd notes
This media is not supported in your browser
VIEW IN TELEGRAM
Education is shifting. Teachers beware.

Kids are going to get great tutoring going forward.

The future is so, so bright.

#OpenAI #gpt4o #ai #gpt #llms
Gpt4o
2025/07/07 06:57:15
Back to Top
HTML Embed Code: