Data Engineering Interview in product based companies

This is a mock interview for the Data Engineering role. Here I have connected with one excellent mind named Akash Dhal who recently started working in the Data Engineering domain. This first round of Data Engineering interviews consists of SQL and basic Data Structure. I hope this 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  

Aakash Dhal's LinkedIn profile
🔅   / aakash-dhal-8a0648140  

Chapters
00:00 - Intro
05:06 - 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.
15:17 - SQL Question 2 - Write an SQL query to find all weights that appears at least three times consecutively.
28:05 - 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.
46:09 - Use of different file formats like row and column-based formats. What is the difference b/w row-based file formats like AVRO, CSV etc and column-based file formats like Parquet, ORC etc?


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