Big Data Interview

Data Engineering Mock Interview with Shakti and Shweta! 🎥

Join us for an exciting and informative Data Engineering mock interview session featuring Shakti Naik who has more than 8 years of experience in the Data Engineering domain.

Are you preparing for a Data Engineering interview? Do you want to enhance your interview skills and boost your chances of success? Then this is the perfect opportunity for you!

In this mock interview, We have tried to simulate a real-life interview scenario, providing you with valuable insights and guidance. They will cover a wide range of topics, including Apache Spark, SQL, Airflow, File Formats, ETL pipelines, data modelling, database technologies, cloud platforms, and more. You'll get a chance to see how professionals tackle technical questions and problem-solving challenges in a structured and efficient manner.

By watching this mock interview, you will:

🔹 Gain familiarity with the data engineering interview process and format.
🔹 Learn effective strategies to approach technical questions and problem-solving scenarios.
🔹 Enhance your communication skills and ability to articulate your thoughts clearly.
🔹 Identify areas of improvement and receive expert feedback on your performance.
🔹 Boost your confidence and reduce nervousness for future interviews.
🔹 Acquire valuable tips and insights from experienced data engineering professionals.

Whether you're a fresh graduate, a career changer, or a seasoned professional looking to brush up on your interview skills, this mock interview is suitable for all levels of experience. It's the perfect opportunity to fine-tune your preparation and increase your chances of acing your next data engineering interview.

Don't miss out on this invaluable learning experience! Subscribe to our channel and hit the notification bell to be notified when the mock interview is released. Stay tuned for a deep dive into the world of data engineering. Get ready to boost your confidence and excel in your upcoming interviews!

🔔 Subscribe now and be the first to watch the Data Engineering Mock Interview with Shakti & Shweta! 🔔

#dataengineering #interview #interviewquestions #bigdata #mockinterview #apachespark

[SujeetKumarMehta-kkkw]

It's very useful, kindly upload more & more video on round 2 also. 🎉🎉

[AtifImamAatuif]

Hey, I have 5 years of experience as a Data Engineer. Would love to have a mock interview .

[Speed--meter]

Very useful information provided. Can you guide some projects for someone wants transition from 10 years SDE journey having few Aws certification?

[rohankhoja]

41:18 A suggestion at the end would be to provide feedback from the interviewers perspective. It could be improvements, clarification on answers etc. I think that would help all the viewers. Appreciate the candid interview experience and at no point it felt scripted.

[aravind]

Your Round1 interview videos are really insighful. Could you please do some Round 2 videos atleast few. It will really help.

[KnuKnuu]

Please complete the data engineering roadmap series ...

[kingsite]

In 2nd SQL quest what if the customer table has duplicate record then the query will fail

[ಅನಾಮಿಕರಾಗ]

If this is the level of 1st round, what about 2nd round, can any experienced guys explain what kind of questions will be asked in 2nd round

[sarahkhan-hgfo]

This is the second time she is giving mock interview. Please tell how I can get the opportunity to give mock interview?

[prof.mangabhai]

Hello Sir, I'm new to data engineering, I'm a 2023 btech it passout, and currently I have got a job in a fintech for data engineer profile, but all these years in engineering I have heard only about data scientist and Software developers, these two are high in demand and can easily earn 15-20 lakhs with 1-2 years of experience, but I am in dilemma that do data engineers have such demand or not? can they earn somewhat similar if nor equal or more than software developers? . Can you help me with these 2 questions

[swagatikatripathy]

Can you explain what was the problem with the first query, why did you reverse it ?

[laxmikantadas]

what is DDC filer? Can elaborate? "DDC"

[SujeetKumarMehta-kkkw]

May I participate in this mock interview ?

[VeaceslavCiudin]

The last solution is correct for the current dataset, but what if the customer 3 would have bought 2 times the same product, let's say 6.
The result of the SQL would be the same (customers 1 and 3), which is false.
An alternate solution would be to use the below having clause (to check if any datatype casts are needed) :
<< having count(distinct c.customer_id || c.product_key) = (select count(distinct product_key) from Products) >>

[avinash]

SELECT Customer_ID FROM Customer GROUP BY Customer_ID HAVING COUNT(DISTINCT Product_key) = (SELECT COUNT(DISTINCT Product_key) FROM Product);