What I Learned From 100+ Data Engineering Interviews - Interview Tips

preview_player
Показать описание
Data engineering interviews are tough.

Interviewing for any technical position generally requires preparing, studying, and long, all-day interviews.

Data engineering interviews, like other technical interviews, require plenty of preparation. There are a number of subjects that need to be covered in order to ensure you are ready for back-to-back questions.

Some positions require Hadoop, others SQL. Some roles require understanding statistics, while still others require heavy amounts of system design.

We have gathered many of the resources that we have used to study and get jobs at companies in the FAANG family as well as other major tech companies. We have yet to find one that requires you to know anything about Hadoop during the interview, so that has not been included in this study guide.

What I Wish I Knew Before I Became A Data Engineer

How I Got My First Data Engineering Job

If you want to help support the channel and you were going to sign up for Udemy or Datacamp anyways, then consider checking out the courses below.

Data Engineering Bootcamp - Datacamp

Data Warehousing Basics - Udemy

If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here.

Or check out my blog

Tags: Data engineering projects, Data engineer project ideas, data project sources, data analytics project sources, data project portfolio

_____________________________________________________________
_____________________________________________________________
About me:
I have spent my career focused on all forms of data. I have focused on developing algorithms to detect fraud, reduce patient readmission and redesign insurance provider policy to help reduce the overall cost of healthcare. I have also helped develop analytics for marketing and IT operations in order to optimize limited resources such as employees and budget. I privately consults on data science and engineering problems both solo as well as with a company called Acheron Analytics. I have experience both working hands-on with technical problems as well as helping leadership teams develop strategies to maximize their data.

*I do participate in affiliate programs, if a link has an "*" by it, then I may receive a small portion of the proceeds at no extra cost to you.
Рекомендации по теме
Комментарии
Автор

Interviews in general are just stressful AF, thanks for sharing these tips to help, Ben!

LukeBarousse
Автор

Great to hear your interviewing style is to be more like a fellow team collaborator rather than a pure interviewer/interviewee relationship. I remember an interview which was like this in that the interviewer even threw out the template interview questions and just asked me questions he had off the top of his head, the interview was really much more like a conversation with a lot of back and forth, comments on what I said, further clarifying questions based on a point I raised, etc.

And we're always glad to receive a video from you continuing to raise more insight into the data engineering interview, thanks a mil!

BJTangerine
Автор

dude you are such a nice guy. appreciate it!

suneilgoel
Автор

This was so motivating, I was feeling so low since just couple days back I had amazon phone screen and I wasn’t able to clear it, I thought it went well overall, but today got an email saying they aren’t moving forward and they do not provide feedback as per their policy🙄, but I will prep hard and try again

day
Автор

Incredible video - This is super helpful in understanding the paradigm in modern data engineering interviews!! Thank you for the post :)

miguelalcorta
Автор

I have a data engineering interview tomorrow thanks for the tips video!

matthewhoang
Автор

I think you are only referring to the product analytics DE role when you say at the end that there are no algorithm based leetcode questions. The DE role with infra team/org is all about leetcode questions with algorithmic implementation of binary search, bubble sort etc

mayankminawat
Автор

If I ever run into you in a Starbucks, I will come and say hi, and thank you for all the amazing videos in person.

lingxu
Автор

thanks. having a hm interview for a DE position at Expedia tmr. I'm a MS business analytics new grad & this would be my first time interviewing for DE.

ryandavis
Автор

11:28 Why do they ask you not to do that??
12:05 what is an operational question? Can you give an example?

Retrosenescent
Автор

Great Video! Can you please elaborate on how to solve sql questions without using lag/lead functions. It would be helpful, if you could provide one sql question ( or share few links) and solve it without using lag/lead (or without any aggregated functions).

Thanks for such Incredible contents!

kshitijpathak
Автор

Should we build an endpoint product to seeking for position in FAANG> ? as ( Data Engineer )

marknguyen
Автор

Another great video. With your consulting work, do people still want you to code in an interview? I don't think I've had an interview like that in 10 years. Now, it's a discussion of whatever problems they're having and I come up with a proposal.

georgejetson
Автор

Must Python really be the main language for Data Engineering? My main tools for data engineering/data analysis is SQL for doing data pulls, Java and Pentaho for ETL and metadata injection stuff, and R for data analysis. I currently work as an entry-level data engineer/data analyst and I love the tools I'm currently working with. But if Python really is the main language for this kinds of stuff for big tech companies, then I should switch to Python, right?

carlitos
Автор

Can you please give some example of data modeling you have face in your interview?

mirli
Автор

I believe this is a general aspect, this will always be relevant unless they hire candidates based off of their personality and driven along with the skills, wether your intermediate or amateur

Quantumvp
Автор

You should still know about stacks, priority queues, etc in python

Oliver-tkii
Автор

"companies want to hire you." how times have changed...

xmnemonic
Автор

Great video! What do you mean by "operational" questions (as opposed to algo questions)?

gideonblinick
Автор

where can I get that 'in data we trust' poster? :D

xtremeNarutoPK