Data Engineering Mock Interview | Round one

Data Engineering Mock Interview

This exciting new video presents a mock interview with a skilled and experienced Data Engineer. Through insightful questions, we explore the techniques, tools, and technologies that the interviewee has employed in their work, gaining valuable insights into the complex and ever-evolving world of data engineering.

From designing and implementing scalable, high-performance batch processing architectures to working with cutting-edge data processing frameworks like Spark, Airflow, AWS etc.

Our expert guest interviewer Nisha shared her hard-won knowledge and expertise, offering valuable advice and insights for aspiring data engineers and seasoned professionals.

Whether you're just starting out in your career or looking to take your skills to the next level, this interview is an essential resource for anyone interested in the fascinating world of real-time data processing and engineering. So don't miss out - tune in now and discover the secrets of success in this dynamic and exciting field!

𝗝𝗼𝗶𝗻 𝗺𝗲 𝗼𝗻 𝗦𝗼𝗰𝗶𝗮𝗹 𝗠𝗲𝗱𝗶𝗮:
🔅 Topmate - (Book 1:1 or other sessions)

Nisha Bansal (Interviewer) 's LinkedIn profile

Shweta Jaiswal (Interviewee)'s LinkedIn profile

TimeStamp
01:24 Shweta's Introduction & Production on which she has worked on
05:54 Basic fundamental questions on #airflow, #database
15:21 First SQL problem solving based on joining in Databases
26:45 Second SQL problem based on Windows functions
34:30 Questions based on AWS, Spark, Airflow etc

#interview #dataengineering #bigdata #apachespark #careerswitch #job #mockinterview

[classybeats]

The SQL part in your interviews are more usefull.Those will improve analytical skills .thank you so much for giving us these interviews

[pavanagarwal]

I believe they should put corrected answers as well

[dnyaneshwarshelke]

In inner join it will have on 3 ones, 2 twos as matching so it will have only 5 rows

[yashbhavsar-pg]

you were telling about delete, we use truncate to delete hole rows data from table and it is quick and for delete we can delete individual row. the drop will be used to triggers, indexes, constraints, and other dependencies. if you are making the interview session please sure the answer are correct because people are watching your videos, slight mistake can put them into confusion
rest all is good keep it up

[prateek]

Can you please add right answers at the end

[adib_shaikh]

in this project ma'am said that is, they used postgresql sql, which type of data it was ? structured or unstructured??? and if unstructured then why postgresql? according to non sql databases?

[prajwald]

I felt the questions asked in interview were easy and straight forward for 2.3 years experience, can we expect these level of questions if we are switching from an analyst role to data engineering role
I'm just too afraid to sit for an interview because i feel the interview questions would be difficult

[Tarasankarpaul]

Most of the answers are incorrect, could you please upload the video with right answers

[shivambansal]

Can we expect this level of questions for 2 years of experience candidate

[rahuljain]

how much years of experience interview is being held?

[WesternRegionHistory]

Junior level? Sql knowledge is very basic

[ShivamGupta_]

If you need I can volunteer for a Big Data Engineer mock interview. I have 2.1 years of experience and will not charge anything.

[dinakarreddy]

Many are wrong answers kindly provide correct interview videos