If you want to keep up with data technologies and get advice on how to set up your data stack, then sign up for my newsletter - seattledataguy.substack.com/
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!
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
Amazon is a hard one! I have also failed an amazon interview. It's a great interview process to go through and helps you realize how much you need to study.
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
You know what, thinking back about 3 years ago when I did interview myself at facebook I interviewed for both types of DE roles and I would agree with this.
1. its almost like using a .sort() in python. It's great that you know it but it doesn't show you understand it. 2. This would be a question like, "If we have a dictionary with user as the key and a value that has a country field and a field that represents the visits over the last thirty days in a array of 1s and 0s representing days they visited([0,0,0,1,1,1,0,0....]), how would you calculate the average visits per user by country"
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!
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.
As a data engineer, do you mean like build a project? It may or may not help. What I have noticed is there tends to be certain trends in hiring based on experience, school and work background.
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?
It really does depend. Zack has a great video about Scala for example. But obviously every company has different tool sets. In general, most people know more than just python. Like I have programmed in Java, Python, C# and Scala (to name a few). So I never really understand picking one language.
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.
It's more like operational data structures questions. Like there is no trick to the question. No specific know how that you have to have pulled from some random chapter in data structures and algorithms. Just understand how you would normally work with a dictionary and an array.
I have been asked to model a college with students, courses, classes, professors, also a parking lot(kind of like the classic programming question), an airport/flight data warehouse, uber, for interviews of course.
Interviewing is a skill that requires practice. The best way to practice is to interview then take notes. Iterate & refine your questions/answers. Speaking of interview questions, I have found making a spreadsheet--yes, a spreadsheet!--of questions (containing a worksheet relevant to each person/phase of the interview process that I am in) that I want to have answers to before I accept an offer from a prospective employer.
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
Hello, I really enjoy your videos. I am starting as a career path Data Engineer AWS and wanted to ask whats the best laptop( Macbookpro, Dell, Lenovo etc) and laptop configuration ( RAM, SSD etc) to buy that is also future proof. Thank you 😊
Hahaha that is a question. I am having issues with my new mac book pro with the M1 chip. There are a bunch of technologies that are not built to run off of the chip....K8s has some issues, confluent etc etc..
I think there might be two reasons. One, for a while there, some systems didn't provide that functionality and the other is just to see if you can figure it out
Having lost my teaching job after 40 years (Engineering Physics), I am looking at jumping back into industry as someone who, in one capacity or other, will write code. My skills are ancient (assembly language after building computers around the Motorola 6800, BASIC, then later C++, Visual BASIC, HTML-- I have even operated a Univax that took up a whole gymnasium sized room), and now I am learning Javascript and Python. I get the sense industry is looking for young people, not an old guy like me. How do you think I should approach this, if at all?
Hey man, may i ask a question? I have an ETL experiences with 2 etl tools and multiple RDBMS (on premise), and i wanted to shift into Data Engineering roles that works usually combining ETL Tools+Python and its libraries/frameworks, am i considered as new graduates or industry professionals? Since i don't have any experiences with Python ? And does it usually means i have to take "paycut"? let's say i make $500 a month as ETL Developer, and i wanted to shift to Data Engineer roles , does it means i will be getting paid like $300 a month since i don't have DE experiences? I really need some guidance... Thankyou :)
Hopefully you don't have to take a paycut. I would try to dove tail your experience into a higher position. For python experience, I would start working with it and use it for a few projects at your current company.
@@SeattleDataGuy Thankyou for the guidance, i've already interviewed by some of the companies, they sent me a "test" to make a pipeline in python pandas, and i created a "crappy one" but hey it works and makes me pass through the "test" section lol I was just doing procedural style, without OOP or def function. Then when i said to them i don't have any python exeperiences, and tell them how i work with the test with "how to do this to do that in python pandas" after that i don't hear anything from them again . But yeah, still it's an achievement for me that i can even pass through the test :)
@@SeattleDataGuy Haha.. Now even I have to think why!? Think I commented as soon as I started watching.. It's like irrespective of the content.. Now it can be changed to 'too' :)
Generally yes. But the next question is, which companies will you need to use scala at. Linkedin, Netflix and Airbnb yes, Amazon, Facebook and Google, no. I believe Zach wilson covers scala vs python in one of his videos. I believe at this point python+SQL is still the more popular language for DEs to use