Data Engineering Interview | First Round | Solutions to First Mock Data Engineering Interview.

This is the solution video of the problems that I had asked in my first mock interview for the Data Engineering role. One can find the link to that mock interview below.

Link of Mock Interview -    • Data Engineering Interview in product...  

This round of Data Engineering interviews consists of SQL, DSA and Basic Big Data Questions. Here I have tried to mock the typical first round of Data Engineering interviews at product-based companies like Walmart, Amazon, Intuit, Meta, MongoDB etc.

I hope this solution video of the mock interview will help someone who is preparing for Data Engineering or Big Data interviews.

🔅 To book a Mock interview - https://topmate.io/ankur_ranjan/15155

𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:
🔅 Topmate - (Book 1:1 or other sessions)
https://topmate.io/ankur_ranjan
🔅 LinkedIn -   / thebigdatashow  
🔅 Instagram -   / ranjan_anku  

Chapters
00:00 - Intro & Thanks for making it to 2K subscribers
01:40 - SQL Question 1 - Write a SQL query for a report that provides the pairs (actor_id, director_id) where the actor has cooperated with the director at least three times.
13:20 - SQL Question 2 - Write an SQL query to find all weights that appears at least three times consecutively.
27:33 - Given an integer array nums sorted in non-decreasing order, remove the duplicates in place such that each unique element appears only once. The relative order of the elements should be kept the same.

#DataEngineering #interview #bigdata #apachespark #dataengineerjob #careerswitch #job