Great video! I’m currently preparing myself for jump from database support engineer at Oracle to Data Engineer and sincerely have found a guideline in your content to achieve that! Thanks for your amazing content!
Finally the wait is over 💯. Thanks for your suggestions and resource recommendations. Really appreciate your guidance. Looking forward to more such informative videos from you.
As someone who got an offer from a FAANG company (for a data engineer position), I can say that the most important variable was whether or not the person conducting the interview wants you as a person on their team. I sucked at the coding portion, have no formal education and I was not coming from an impressive data company. Apparently, that was not the priority. On the flip side, non-FAANG companies typically made a hard pass on the missing formal education.
Interesting. I can tell you, as someone who has done 100+ interviews at facebook is that it's very systematic. Generally the person interviewing you has no connection to what team you will join. But that's also because at facebook you likely are just interviewing for a general DE position. After 1 month of bootcamp you get to pick your team
I do think that some system design is always useful. If you're doing a pure data engineer then your design questions tend to be more focused on data warehouse and ETL design.
Thanks for the resources, as well as recommending other individuals to follow. Do you recommend any leaders to follow as well to track the broader trends in data engineering?
@@SeattleDataGuy I agree with the other youtuber that both creators and execs would be a good idea. I myself I think haven't found a creator yet that helps me understand the intersection of technology, processes, practices, people, and culture as it relates to DE.
@@matthewnigh Yeah its a tough nut to crack for sure. Especially where there are so many decisions to make. Both technically and business process wise.
Hi and thanks for compiling the sheet (huge work), I stumbled across it many months ago bc it was referred as smthng like an essential guide for DE interviews, glad that now it's been updated. I'm about to interview for DE1 @ Amazon, do you think there's a lot of difference between DE1 and DE2 in the interview process or the preparation should be almost the same? For instance will I need to understand all the concepts you listed in the doc?
You are correct in that assertion. In general you often only need to design ETls, or data warehouses. But I think there are a lot of similarities in how you approach both problems. They are different but both require you to understand the requirements and think through the use cases.
Hey Ben, Thanks for this extremely helpful video. I have my second round of DE1 interview at Amazon coming up. Can you please suggest some good resources for ETL design?
@@hubbiemid6209 Yeah I would say just focus on SWE. Get an internship, try it out, and maybe if you still have time, try to get a DE or DS internship. There is no rush! You have so much time to try these roles and they all pay well so there is no financial risk in picking the wrong one really. I thought I wanted data science and focused a lot of energy there and then became a data engineer.
If you enjoyed this video, then sign up for my newsletter! seattledataguy.substack.com/
The people asked, and you sir, have delivered!!!
Yes sir! All the secrets to cracking the faang interview....JK...there is no secret.
Great video! I’m currently preparing myself for jump from database support engineer at Oracle to Data Engineer and sincerely have found a guideline in your content to achieve that! Thanks for your amazing content!
It is really going to help me to prepare for big companies. Thanks for sharing this knowledge with us.
Glad you found this helpful!
You are creating great content day by day! Keep up the good work and thank you for this video!
Thank you! You're too kind!
thank you so much...exactly what I was looking for!...I love engineers..no bs straight to point love it!
Thank you! I do feel like i occasionally ramble. But I try not to!
Finally the wait is over 💯. Thanks for your suggestions and resource recommendations. Really appreciate your guidance. Looking forward to more such informative videos from you.
Glad you enjoyed the video on cracking the Faang interview. Feel free to share with your friends!!
@@SeattleDataGuy Sure.
Thank you!
Thanks!
This was a huge help!! Thank you.
Wow, no thank you for the extra special thanks!! Where did you get a job at?
As someone who got an offer from a FAANG company (for a data engineer position), I can say that the most important variable was whether or not the person conducting the interview wants you as a person on their team. I sucked at the coding portion, have no formal education and I was not coming from an impressive data company. Apparently, that was not the priority. On the flip side, non-FAANG companies typically made a hard pass on the missing formal education.
Interesting. I can tell you, as someone who has done 100+ interviews at facebook is that it's very systematic. Generally the person interviewing you has no connection to what team you will join. But that's also because at facebook you likely are just interviewing for a general DE position. After 1 month of bootcamp you get to pick your team
wow thank you for study guide, i really need these sources
Glad to hear that this interview study guide will be helpful!
Great content, thanks. Tips for getting an interview ?
Thank you for the guide!
I hope this will help you in your data engineering interviews!
Thanks very informative
Glad you enjoyed it!
Hey! Can you also share the data science study guide link? It seems extremely useful and comprehensive!
Do System Design knowledge is required for Data Engineer role for FAANG ? I feel it is more for software developer. Please correct my thoughts
I do think that some system design is always useful. If you're doing a pure data engineer then your design questions tend to be more focused on data warehouse and ETL design.
Thanks for the resources, as well as recommending other individuals to follow. Do you recommend any leaders to follow as well to track the broader trends in data engineering?
That's an interesting question. Are you looking for possible executive level youtubers or content creators in data engineering?
It's an interesting topic ...please make a video on both creators and executive level people to follow on ...thanks
@@bemanojkumar722 Thats a great idea!
@@SeattleDataGuy I agree with the other youtuber that both creators and execs would be a good idea. I myself I think haven't found a creator yet that helps me understand the intersection of technology, processes, practices, people, and culture as it relates to DE.
@@matthewnigh Yeah its a tough nut to crack for sure. Especially where there are so many decisions to make. Both technically and business process wise.
How likely is it that undergrad internship interviews will get asked system design questions?
They might not ask you about system design for data engineering, but they will for software
Hi and thanks for compiling the sheet (huge work), I stumbled across it many months ago bc it was referred as smthng like an essential guide for DE interviews, glad that now it's been updated.
I'm about to interview for DE1 @ Amazon, do you think there's a lot of difference between DE1 and DE2 in the interview process or the preparation should be almost the same? For instance will I need to understand all the concepts you listed in the doc?
I can tell you for amazon DE1 you should be able to do SQL, database design and possible ETL design. From my experience. I didn't get any coding.
@@SeattleDataGuy thanks!
@@96merluzzo Good luck!
Do you think your old video about ETL design could be enough to pass the ETL section?
@@96merluzzo I think i need to remake them. I have a lot to add
facebook and amazon don't have system design for data engineers right? seemed like it was data modeling or etl design instead
You are correct in that assertion. In general you often only need to design ETls, or data warehouses. But I think there are a lot of similarities in how you approach both problems. They are different but both require you to understand the requirements and think through the use cases.
Hey Ben, Thanks for this extremely helpful video.
I have my second round of DE1 interview at Amazon coming up. Can you please suggest some good resources for ETL design?
Sorry just getting back to this. How did things go?
@@SeattleDataGuy Done with 2 rounds, preparing for 3rd. Still a little unsure about ETL designing.😅
I've been doing SWE interview questions for the past month, what should I add on so that my preparation applies to DE and DS
Why do you want to prep for more than just SWE? Isn't preparing for SWE hard enough ahhahahaa...
@@SeattleDataGuy I'm a 3rd year in college really confused about what I want to pursue :/
@@SeattleDataGuy plus DE and DS roles are so hard to find. typically you'd have to apply to SWE roles and ask for a data focused team/project
@@hubbiemid6209 Yeah I would say just focus on SWE. Get an internship, try it out, and maybe if you still have time, try to get a DE or DS internship. There is no rush! You have so much time to try these roles and they all pay well so there is no financial risk in picking the wrong one really. I thought I wanted data science and focused a lot of energy there and then became a data engineer.
@@SeattleDataGuy SWE is definitely my "Catch-All" right now, so I've been practicing sql slowly on the side. thanks :)