Data Engineering Interview at top product based company | First Round

Data Engineering Mock Interview
In top product-based companies like #meta #amazon #google #netflix etc, the first round of Data Engineering Interviews checks problem-solving skills.
It mostly consists of screen-sharing sessions, where candidates are expected to solve multiple SQL and DSA problems, particularly in #python . We have tried to replicate the same things by asking multiple good SQL and DSA problems to check the candidate's problem-solving skills.
If you're preparing for a Data Engineering interview, this is the perfect opportunity to enhance your skills and increase your chances of success.
The mock interview simulates a real-life scenario and provides valuable insights and guidance. It aslo include some questions on #apachespark
You'll get to see how professionals tackle technical questions and problem-solving challenges in a structured and efficient manner.
By watching this mock interview, you'll learn effective strategies to approach technical questions and problem-solving scenarios, gain familiarity with the data engineering interview process and format, enhance your communication skills and ability to articulate your thoughts clearly, identify areas of improvement, receive expert feedback on your performance, boost your confidence, and reduce nervousness for future interviews.
This mock interview suits all levels of experience, whether you're a fresh graduate, a career changer, or a seasoned professional looking to improve your interview skills. 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.
Subscribe now and be the first to watch the Data Engineering Mock Interview.
🔅 To book a Mock interview - topmate.io/ank...
🔅 LinkedIn - / thebigdatashow
🔅 Instagram - / ranjan_anku
🔅 Ankur(Organiser) 's LinkedIn profile - / thebigdatashow
🔅 Manoj(Interviewer) 's LinkedIn profile -
/ manoj-t-dataengineer
Chapters:
#sql #dataengineering #interview interview #interviewquestions #bigdata #mockinterview

[@yashiyengar7366]

Completely hands on knowledge packed interview, learnt a lot. These interviews are helping me get a reality check for my own interview preparations. Thank you for uploading them on to KZbin.

[@manojt3164]

Thanks for the kind words @yash. Glad to hear that it helped you!

[@soumyodeepmukherjee555]

Another great one!! Well done!! Just a quick comment on the 1st question - extract month logic will return data for that month across all years if we have multi year data. It’s better to use something like to_char(, ‘YYYY-MM’) to take the year into consideration as well. Not a criticism at all, these type of things happen on an interview setting. Great content, well done!!

[@venukumargadiparthy8233]

Thanks for conducting these kind of mock interviews, very useful.

[@TheBigDataShow]

Thank you for your kind words. Keep supporting and encouraging us.

[@gauravmaheshwari1807]

Hi, for the 2nd problem where we are supposed to select top 3 brands in the top 1 category for the last month. While selecting the category, we applied the date condition for the last 1 month, which gives us the top category. But then while selecting the brands, we are not putting a date condition, because of which we are looking at the life time revenue of the brands in the category, which can give false results. So, along with the category condition, we should also be putting a date condition again to limit the revenue to the last month. In terms of business sense, one can understand it like this: suppose there are 2 brands in category, one brand has been around for 4 years and the other one been around for a year or so, so the probability of brand 1 having higher life time revenue is more, although in reality, the brand 2 might have outperformed in the last 1 year.

[@sharankarthick3364]

Informative

[@user-xy1pc5rl3w]

very useful information

[@TheBigDataShow]

We are also creating multiple Data Engineering Interview questions to practice in the community section of our KZbin channel. Visit our channel and then go to the community tab to find all the questions for practice. Nd Do watch our other Data Engineering Mock interview by following the Mock Interview playlist too. We have more than 25 Data Engineering Mock interviews.

[@zeeshanaziz3512]

Hello team, I have a question that do we really need to use 3rd cte in 2nd question where we need to find to three brands? we can just put order by 3 in the end of 2nd cte will that give us wrong OP?

[@manojt3164]

Hello, maybe ordering it based on the column and get the three limit could have solved the problem. But what if I'm interesting in brands even gives me same number of revenue? So it depends on the use case either to limit or to use rank and filter. Thanks for the question. Hope it clears your doubt. If not do add a comment, so I can put more clarity

[@nishabansal2978]

So the thing is in case we have more than 1 brand competing for 3rd place then using limit 3 will only select 3 rows excluding the other potential brand row scoring 3rd place based on revenue, in case of window function it will give same same rank to the brand which have same revenue thus including that in ans

[@zeeshanaziz3512]

Thank you for clarification

[@abstract_machine]

Are you allowed to use like pandas and numpy functions for the pything questions ? Like for ezample for python question number 2) could i have used the pandas .unique() function ?

[@TheBigDataShow]

Mostly in this type of questions, the interviewer tries to understand your problem solving skills. Here input is not a pandas DataFrame, so they will expect you to write raw python code and show your problem solving skills, not some framework which works behind the scenes for computation and logic.

[@user-zb1oe3uf3z]

And what about using raw Python set() function? My original thought for the 2nd Python question in to simply return set(nums). Or list(set(nums)) if we care about data types

[@Aman-lv2ee]

is this interview for freshers ? or the experienced person?

[@TheBigDataShow]

This is for someone who is going for an interview at a good product based company. All product based companies for experienced or freshers in the first round of Data Engineering remain the same. It tests your problem solving skills.

[@OmkarPatil-r9r]

hi , does order by works inside cte , because it generally gives the error stating it is invalid in cte , views and derived tables.

[@manojt3164]

Hello, definitely order by should work within the cte and views. We are using the existing defined columns to order by