Data Engineering Road Map - How To Learn Data Engineering Quickly( By A FAANG Data Engineer)

แชร์
ฝัง
  • เผยแพร่เมื่อ 14 ต.ค. 2024
  • How do you go from 0 to data engineer?
    What is the road map to data engineering?
    These are all valid questions that I will walk you through over the next 15 minutes.
    The purpose of this video is to help you break down all the various skills we seem to need to know as data engineers in 2021 into manageable bites.
    So you don’t feel overwhelmed, but instead have a clear path from where you are and where you need to go as a data engineer.
    Also, here is a link to the data engineering roadmap I reference in the video. With links and everything!
    drive.google.c...
    Wherever you are in your data engineering journey. Good luck!
    So good luck with your DE career. And here are some more resources you may enjoy:
    What Skills Do Data Engineers Need?
    • What Skills Do Data En...
    Data Engineering Project Ideas
    • 5 Data Sources for You...
    If you want to learn more about data engineering, check out Google's Data Engineering Course
    coursera.pxf.io/rn1rGv
    If you'd like to read up on my updates about the data field, then you can sign up for our newsletter here.
    seattledataguy...
    Or check out my blog
    www.theseattle...
    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.

ความคิดเห็น • 360

  • @SeattleDataGuy
    @SeattleDataGuy  2 ปีที่แล้ว +27

    If you want to learn more about what is going on in the data space, then sign up for my newsletter! seattledataguy.substack.com/

    • @joshokello52
      @joshokello52 2 ปีที่แล้ว +1

      sir what about the microsoft certified: Azure Data engineer associate certificate, would you also recommend it

    • @socialmediademigod1496
      @socialmediademigod1496 2 ปีที่แล้ว

      What is the highest paid tech salary?

    • @Zappabain
      @Zappabain ปีที่แล้ว

      God bless you for the info on that Data Engineering Road Map about documentation and Courses.

  • @Symmetryful
    @Symmetryful 2 ปีที่แล้ว +76

    I find it interesting that so many of these roadmaps focus so acutely on technical skills. Frankly, I’m not sure how valuable it is to learn AWS to ‘get into’ data engineering. You’ll learn this skill on the job when you get to it. Also this type of technology is highly dependent on what field you end up in. Lots of companies in the finance and insurance sector are nowhere near ramping up to AWS.
    I think learning the concepts of data storage, ETL pipelines and data warehousing - as well as having a general ability to write code in, say, Python - ought to suffice as a starting point.
    The hard part about technical roles like data engineering isn’t really writing the programs. The hard part is the softer skills involved and understanding the domain you’re working in.

    • @deathbombs
      @deathbombs 2 ปีที่แล้ว +1

      Agree but some tools are more general, like Kafka, Spark may help with initial getting job offers.

    • @prof.mangabhai
      @prof.mangabhai ปีที่แล้ว +1

      bro I like to code , is data engineering for me ? because I have heard that DE mostly write sql when it comes to programming , and have they might some automation scripts for aws with python but that's not very often and is not a large part

    • @atwertsdfgsdfaasdfa
      @atwertsdfgsdfaasdfa ปีที่แล้ว +1

      @@prof.mangabhai There's such a wide range. SQL is a given. There are DEs that just do SQL and use low code tools. But also lots of DE positions focused on all of the other topics listed in this vid where SQL is a minimal part of the job.

    • @atwertsdfgsdfaasdfa
      @atwertsdfgsdfaasdfa ปีที่แล้ว +3

      I moved from DS to DE. My main tool is Python and I really work more as a backend engineer, but with a focus on automating data analytics and some machine learning stuff.

    • @ExecutionMods
      @ExecutionMods 10 หลายเดือนก่อน +1

      ​@@atwertsdfgsdfaasdfa I am a cs new grad with some full stack experience. I see a lot of backend engineer jobs desiring desiring kafka, airflow, Cassandra, and even some ML familiarity. It seems like DE skills are the way to go regardless of specific role. Taking the IBM DE course on Coursera and then maybe an AWS specific one if needed; hopefully it'll help me in this entry job rat race.

  • @0x007A
    @0x007A 3 ปีที่แล้ว +80

    Learning about containerization from the outset is an important skill. Start by packaging an application such as an API and then perhaps containerize other components or processes such as data acquisition, cleaning, and loading into a database from which your API draws its data. Persistent data storage containers as early as possible will be useful.

    • @nickarrigo5540
      @nickarrigo5540 3 ปีที่แล้ว +1

      great idea! sounds like you know your stuff

    • @SD-ko4tz
      @SD-ko4tz 2 ปีที่แล้ว

      Huh? Never used API s in my 30 ywars

    • @0x007A
      @0x007A 2 ปีที่แล้ว +4

      @@SD-ko4tz APIs have become the primary access mechanism for external data sources, at least for mobile / web apps and a lot of websites. There are other use cases but I won't enumerate them here.

    • @prof.mangabhai
      @prof.mangabhai ปีที่แล้ว

      bro I like to code , is data engineering for me ? because I have heard that DE mostly write sql when it comes to programming , and have they might some automation scripts for aws with python but that's not very often and is not a large part

  • @kalydrae
    @kalydrae 2 ปีที่แล้ว +3

    Don't worry... 15 years into my it career I still write hello world projects for new technologies and languages!
    Great video thanks.

  • @LukeBarousse
    @LukeBarousse 3 ปีที่แล้ว +92

    Loved this road map that you shared! Also liked how it integrated learning, projects, and then building further. Solid! 🙌🏼

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +8

      Yeah! I am really hoping it helps people take time after learning to really apply things. Otherwise that information disappears into some weird part of our brain that seems locked up.

    • @NP_Omar
      @NP_Omar 2 ปีที่แล้ว +6

      I just want to thank both of you for paving a roadmap for me into Data Analytics and Data Engineering with your content. You guys rock!

    • @LukeBarousse
      @LukeBarousse 2 ปีที่แล้ว +1

      @@NP_Omar Aww thanks for this Omar!!

    • @axeld.santacruz4659
      @axeld.santacruz4659 2 ปีที่แล้ว +1

      @@LukeBarousse I agree with Omar, you and Ben are both amazing (long time follower here :D).

    • @prof.mangabhai
      @prof.mangabhai ปีที่แล้ว

      bro I like to code , is data engineering for me ? because I have heard that DE mostly write sql when it comes to programming , and have they might some automation scripts for aws with python but that's not very often and is not a large part

  • @DeezSkates
    @DeezSkates 2 ปีที่แล้ว +16

    Excellent video. The hardest thing about working in IT has been that every time I make a move to further my career, I find I have to build my own road map. Problem is, it’s impossible to know what all exists because there is so much. And every person you ask will give you some different list of things you need to learn, with no real concept of how it all fits together. As the technology expands, the need for roadmaps becomes so much more important than in previous years.

  • @user-fi5oi9vy3s
    @user-fi5oi9vy3s 2 ปีที่แล้ว +4

    Thanks for the roadmap, im working as a developer for five years. Juz turn my mind to focus more on data engineering stuff starting 2022. It will be a good start to come across with the items mentioned in the map. Hope I can be a better man after the effort made. 2022 Wishes

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว

      Glad this could be helpful! Good luck on your DE journey!

  • @kinarapandya2988
    @kinarapandya2988 3 ปีที่แล้ว +3

    Please continue making videos on Data Engineering. They are very helpful !

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +2

      I will keep making data engineering videos!

  • @CarlosMorenoV
    @CarlosMorenoV ปีที่แล้ว +5

    Amazing!. I am a Python software developer, so I have a background in making APIs and Unit Testing as well as some skills using Docker. But definitively I need to understand how to model Data Warehouses, and some cloud tools and play with Luigi or Airflow. I felt happy watching your video because I realized that I am on the correct path. I have a nice number of tools in my bag, but I have to keep working to get the other ones.
    Thank you for this great video and excellent road map, mate.

    • @SeattleDataGuy
      @SeattleDataGuy  ปีที่แล้ว

      Glad you found this helpful! It sounds like you're on the right path!

  • @LayaWhite
    @LayaWhite 3 ปีที่แล้ว +19

    Thank you for this - it's exactly what I was looking for. I have some SQL skills and I work with relational databases, but I want to make a career shift into Data Engineering. I was starting to get overwhelmed by all the options!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +3

      Glad this could help! Who knew that more knowledge and access to it..would make it more difficult. Hopefully this roadmap helps make the path clearer. good luck on your data engineering journey.

    • @ModernPeopleAreEvil
      @ModernPeopleAreEvil 2 ปีที่แล้ว

      Have you been learning how to be a DE?

  • @harveymitchell2113
    @harveymitchell2113 3 ปีที่แล้ว +28

    Thank you for this roadmap. I have a background in IT and I’m trying to make a lateral move into a jr data engineer role. I’ve been studying for 5 months now with UDACITY, and up until this video I still had no idea how to correctly maneuver into a DE role without feeling overwhelmed. Thanks 🙏🏽

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +5

      I do hope this helps you move into a data engineering role! Good luck

    • @olajuwonokunubi1869
      @olajuwonokunubi1869 3 ปีที่แล้ว +1

      Hey Harvey how are you finding the udacity de course , I'm thinking I would like to do it

  • @SeattleDataGuy
    @SeattleDataGuy  3 ปีที่แล้ว +20

    If you enjoyed this video, then sign up for my substack seattledataguy.substack.com/

    • @stream2learn
      @stream2learn 3 ปีที่แล้ว +2

      Hey Seattle Data Guy,
      th-cam.com/video/E-x8v2KU0Lo/w-d-xo.html
      I have tried to explain stuff that's needed to become a data engineer in 2021 in the above link. Try checking that out as well. Hope it helps.

  • @knightsavage647
    @knightsavage647 3 ปีที่แล้ว +15

    This is awesome, I'm currently a data analyst and I have been searching for a way to make the switch to data engineering. Thank you for compiling and breaking down the tons of information that is out there.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      I am glad you found this helpful! Good luck on your data engineering journey.

  • @MahmoudElaskare
    @MahmoudElaskare 2 ปีที่แล้ว +2

    Thank you so much ,I was desperate navigating the diagram shown in the beginning (actually it was hanging on my wall giving me anxiety about actually being able to finish it)👍

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว

      Hopefully it doesn't stress you out too much!

  • @moagarwal1999
    @moagarwal1999 3 ปีที่แล้ว +5

    Was really looking forward to this. Great work man!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Thank you! I am glad you enjoyed it!

  • @viswajitnayak1665
    @viswajitnayak1665 2 ปีที่แล้ว +1

    Thanks ... i have been working towards transition to a data engineering role and I see this is the most concise path...
    Thanks seattle-guy

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว

      Good luck, let me know how it goes!

  • @anthonyphan1922
    @anthonyphan1922 3 ปีที่แล้ว +1

    This guy posted this for 6 days with nearly 400 likes and not a single disliked. That make me definitely give him a subscription

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      Thank you so much! I appreciate every like, subscription, etc. I really want to help build the data engineering and data community so I will keep trying to put out great content.

  • @DemolaOkesola
    @DemolaOkesola 3 ปีที่แล้ว +2

    Best guide I have gotten so far. Helps to clear up the confusion

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      Glad this data engineer guide helped clear up some of the noise!

  • @carlobisda
    @carlobisda ปีที่แล้ว

    love this kinda videos, still relevant in 2023. i started a data science course but it wasn't really my jam and i tend to lean towards backend stuff anyways.

  • @kocermehmet
    @kocermehmet 3 ปีที่แล้ว +7

    Hi! I started a data engineer internship that week and I find myself here. Your video is great as I think It should help me. I didn't know where to start and how to use my time efficiently so a huge thanks for the video and the roadmap!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      Yeah! I am glad I could provide some signal in all the noise.

  • @matthewgin4836
    @matthewgin4836 ปีที่แล้ว +2

    Very informative. I'm taking udacity's data engineering nanodegree and we're doing a similar roadmap. Good job!

  • @kanimozhimurugesan966
    @kanimozhimurugesan966 2 ปีที่แล้ว

    I like the way you encourage your viewers in final part of your videos.

  • @PaulMisner
    @PaulMisner ปีที่แล้ว

    Thanks. I got thrown into a data engineering role because of a unfilled vacancy. I'm trying to skill up for the position. This was a real help.

  • @DataProfessor
    @DataProfessor 3 ปีที่แล้ว +4

    Wow, this is golden! I think I'm at stage 4. Starting to learn about CI/CD. Yes indeed, writing a blog is a great way to learn!
    Like number 170 :)

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      I am glad you found it helpful! CI/CD is so complex, there are so many layers. Are you focused a lot on deploying models?

    • @DataProfessor
      @DataProfessor 3 ปีที่แล้ว +1

      @@SeattleDataGuy At the moment, it’s for updating a website’s content via GitHub. And yes also looking into model deployment as well.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      @@DataProfessor Awesome, for model deployment, are you looking into mlops tools?

    • @DataProfessor
      @DataProfessor 3 ปีที่แล้ว +1

      @@SeattleDataGuy Yes definitely, but a newbie at it, learning a lot from your videos Ben 😆

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      Thank you! I look forward to making more and learning a lot along the way.

  • @shaleenarora3006
    @shaleenarora3006 3 ปีที่แล้ว +1

    One of the best video on data engineering I've come across. Great Work !!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      I am glad you enjoyed this data engineering video!

  • @tushensu
    @tushensu 3 ปีที่แล้ว +2

    Thank you for this breakdown, I will update you when I get that Data Engineering job!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Awesome! Good luck on your data engineering journey. #dataengineering

  • @ridge_413
    @ridge_413 3 ปีที่แล้ว +4

    Thanks man! I'm a HRIS and Reporting Specialist looking to make a switch to the other Data scene. I found a lot of your videos very down-to-earth and concise to learn more about Data Engineering.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      I am glad you are finding these videos helpful! Good luck on your data journey!

  • @0x007A
    @0x007A 3 ปีที่แล้ว +1

    Adding those projects to the roadmap is much appreciated.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      For sure! I think its always great to stop and actually apply knowledge. Of course its a struggle to sometimes stop for projects since you will often feel like your learning rate will decreasing but you're picking up so many skills!

    • @0x007A
      @0x007A 3 ปีที่แล้ว +1

      @@SeattleDataGuy I spent the last few days learning how to containerize and deploy a private git repository service using git and gitolite. It was the first time that I learned how to use volumes (not host file system volumes) but self-contained volumes independent of the host file system.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      That's awesome. Do you feel comfortable with them now?

    • @0x007A
      @0x007A 3 ปีที่แล้ว +1

      @@SeattleDataGuy definitely. I am now converting the Docker configuration for use with Docker Compose to simplify the deployment of the 3 components. This experience should be useful for data engineering implementations too, but I won't know until I give it a try.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Yeah it will be! There is a ton of DevOps style work we sometimes have to take on. So that should be helpful.

  • @strategy_gal
    @strategy_gal 3 ปีที่แล้ว +3

    Wow this is awesome! You've clearly explained each step on the road map. Great video!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      I am glad it was clear! I need to check out your channel as well!

    • @strategy_gal
      @strategy_gal 3 ปีที่แล้ว

      @@SeattleDataGuy Of course! See you in there :)

  • @sebastianalvarez4239
    @sebastianalvarez4239 3 ปีที่แล้ว +11

    Great video Ben! I am definitely sure I want to pursue a career in Data Engineering but felt like I was all over the place when trying to learn the skills. This is definitely helpful, thank you!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +2

      Thanks for the comment Sebastian! Yeah, it can feel super overwhelming. Luckily when I first started I didn't know as much about the entire field so I just learned things slowly without being overwhelmed. Now with all the courses, articles and tutorials its crazy.
      Hopefully this helps silence some of the noise.

  • @ramprksh555
    @ramprksh555 2 ปีที่แล้ว +1

    its a very informative. Also links given for other technologies to prepare is also much commendable. Thank you so much for sharing all those.

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว

      I am glad you are enjoying the content!

  • @vb_294
    @vb_294 3 ปีที่แล้ว +13

    Thanks Ben! This is gonna help someone like me whose between step 1 and 2 a lot and I appreciate all your work 🙌🏻🙌🏻

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Glad to hear it was helpful. Good luck on your data engineering journey!

  • @LearnAvecAmeen
    @LearnAvecAmeen ปีที่แล้ว +2

    Thank you very much Ben, I learned that my ftp/tftp projects will serve for something,
    Anyway, great video, keep up the good work insh'Allah

  • @panasrat457
    @panasrat457 3 ปีที่แล้ว +1

    Thank you so much! I just graduated and now I'm very interested in data engineering field. This is definitely the channel that I'm looking for. Keep uploading!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Awesome! I appreciate all the support. I have plenty more videos coming

  • @elimgarak3597
    @elimgarak3597 3 ปีที่แล้ว +1

    Learning DE is like being trapped in vendor tool hell. There are so many tools it is really overwhelming. Thanks for this vid.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      It really is. Just build a strong foundation and then learn how to learn just enough of a tool when you need it.
      Or...
      Pick a tool that is not going anywhere soon and master it. Become a specific consultant and charge like $800 an hour. Kind of a joke.

    • @essakhan1575
      @essakhan1575 3 ปีที่แล้ว

      @@SeattleDataGuy "Pick a tool that is not going anywhere soon and master it. Become a specific consultant and charge like $800 an hour. Kind of a joke." genuine question is this sarcastic?
      Could you kindly suggest which tool isn't going anywhere soon and to master? Damn I would be happy with $50 dollar an hour nevermind $800.

  • @JCGarcia1
    @JCGarcia1 2 ปีที่แล้ว +2

    Thanks for sharing this with everyone, super helpful as I go through this career transition!

  • @muriloarruda
    @muriloarruda ปีที่แล้ว +1

    Well detailed roadmap.
    I have 10 years of experience in modeling using Ralph Kimball's techniques and ETL (Sagent, Oracle ODI), where I stopped (2012) completely and moved on to the commercial area, selling technology with spin selling techniques (ERPs, BI, low-code...). Today I want to go back to my initial area, which is now something part of Data Engineering.
    Watching many of your videos, to understand how to get back to this area that I love so much (or once loved).

  • @nickarrigo5540
    @nickarrigo5540 3 ปีที่แล้ว +1

    awesome content! your channel is such a great resource. really thoughtful comment section too!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Yeah we have a great community! Welcome to all. Data engineers, analysts, scientists and everyone else

  • @SeattleDataGuy
    @SeattleDataGuy  3 ปีที่แล้ว +63

    EDIT: Wow...100 likes before 24 hours..thats a first

    • @LukeBarousse
      @LukeBarousse 3 ปีที่แล้ว +2

      Before 12 hours!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +2

      @@LukeBarousse I can't wait until the day I am trying to get 10k before 24 hours....but for now...this is exciting!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +2

      @@LukeBarousse Add to that...1k views before 12 hours! just barely. Also a first!!!

    • @tanayk02
      @tanayk02 ปีที่แล้ว +1

      @@SeattleDataGuy look at u now!

  • @iamsuzit96
    @iamsuzit96 3 ปีที่แล้ว +2

    please more emphasis on the projects. I think it would truly help new learners. thank you!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      I am going to finally try to film the data engineering project video. I am mentally stuck and need to just do it.

  • @kphorce
    @kphorce 3 ปีที่แล้ว +2

    Finally...you have come back with a.........plan *the rock voice*

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      Hahaha! That sounds about right. Gotta alway approach things with a plan

  • @42data
    @42data 7 หลายเดือนก่อน +1

    00:02 Data engineering roadmap is overwhelming with too many skills and tools to learn at once.
    01:46 Follow a structured roadmap for learning data engineering
    03:24 Build a Flask API to learn how to utilize different skills
    04:51 Focus on different paths within data engineering
    06:28 Build a project to scrape and store data
    07:57 Data engineers build data infrastructure for future use.
    09:32 Learning about unit tests, integration tests, and workflow tools is important for data engineering.
    11:01 Focus on learning cloud and NoSQL databases early on
    12:27 Focus on learning basic databases before delving into streaming and distributed systems
    14:04 Prepare for interviews and build a project
    15:32 Focus on building a third project and document it.
    16:57 Focus on building a solid base for interviews and the first job

  • @anglamthenhan6579
    @anglamthenhan6579 2 ปีที่แล้ว +1

    Thanks for the roadmap! It helps me a lot. 🤧

  • @christopheraustin2828
    @christopheraustin2828 3 ปีที่แล้ว +3

    This is the best and most detailed roadmap for DE that I've yet seen. My question is:
    Is this roadmap aiming to make you an absolute shoo-in candidate? Is it possible to apply for a job and get one before the end of the roadmap? I'm asking because it seems that the demand for engineer is high and the labor pool is smaller.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      I would say if you do everything on this roadmap you will have a good high level understand of most data engineering concepts.
      For most interviews I have found that a general understanding of technology(Programming, design, SQL, testing, and maybe a few other odds and ends) will be good enough. Especially if you are going for a more junior position. So You can probably get halfway through this roadmap and start putting out resumes.

  • @peekguyy3194
    @peekguyy3194 2 ปีที่แล้ว +1

    Fantastically concise video, thank you.

  • @nimish2568
    @nimish2568 2 ปีที่แล้ว +1

    Wonderful content .Crisp, Clear & to the point. Thank you

  • @tech-n-data
    @tech-n-data 3 ปีที่แล้ว +1

    Really enjoying your channel!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Thank you! I appreciate all your comments and support. Got to feed the YT algo.

  • @__berichh5375
    @__berichh5375 2 ปีที่แล้ว +1

    Yes, I transitioned to cloud engineering and sooo overwhelming. I appreciate all maps lol

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว

      It can be overwhelming. You just have to take it one step at a time.

  • @BBDoesTheThing
    @BBDoesTheThing 2 ปีที่แล้ว +1

    Starting from near zero today!

  • @Kicsa
    @Kicsa 2 ปีที่แล้ว +2

    Funny you referenced the first road maps since I saw those and those discouraged me, but your road map is very realistic and I'm excited to finally see something I want to do, thank you!

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว +3

      Yeah! You don't need to learn everything. Just one step at a time. Good luck!

  • @Presssent
    @Presssent 2 ปีที่แล้ว +1

    Im a Data Analyst and considering Udemy's course but didn't know about Googles Cloud! Thank you. I applied for a local company and the only Data Engineer is leaving soon :(

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว +1

      Sounds like a great opportunity to move into being a DE if you wan that.

  • @AK-Star007
    @AK-Star007 2 ปีที่แล้ว +1

    I know most of the "things" , but it just that nothing is in order. Let me bring it in order. THANX for detailed video.

  • @DeejayManiaNYC
    @DeejayManiaNYC 2 ปีที่แล้ว +1

    Great Roadmap!

  • @rhythmcity2006
    @rhythmcity2006 10 หลายเดือนก่อน +1

    Side note, I see The Alchemist on the side. Great book!

  • @Viper-sn5cx
    @Viper-sn5cx ปีที่แล้ว

    Awesome video man thanks!! Do you have a specialization in any of those skills/tools?

  • @gabyabed
    @gabyabed 3 ปีที่แล้ว +1

    Thanks! I'm an experienced SQL DBA, but looking to progress my skills and talents, not necessarily change companies yet, but at least find a way to wrangle the data we handle at my current company.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Thats interesting! Are you looking for specific tools or skills?

    • @gabyabed
      @gabyabed 3 ปีที่แล้ว +1

      @@SeattleDataGuy I guess to keep things specific to my company, we're an Azure shop mostly, and simple data flows to something that can be used by powerBI for example. I knew SSIS, so that's a big piece. I'm thinking the other major thing to learn is data warehousing, that's my missing piece it looks like.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Makes sense. Yeah, data warehousing is generally that other component. Its funny how you can use tools like SSIS and not even realize they are connected to data engineering or data warehousing.

    • @gabyabed
      @gabyabed 3 ปีที่แล้ว +1

      @@SeattleDataGuy ETL is one of those in-between "glue" products that is not sexy, but when push comes to shove, is powerful. SSIS has a LOT of legs left in it, although I do know the writing is on the wall with Python and T-SQL combined.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      @@gabyabed Forget Python and T-SQL...Snowflake just has tasks that are basically just stored procedures you can put on a schedule + have dependencies...its tech..there is always new but there will always be companies that never switch.

  • @gagangulati7417
    @gagangulati7417 3 ปีที่แล้ว +3

    Thanks for sharing the roadmap!!..I have been thinking of moving to data science realm and this roadmap will definitely help. I watched some of your videos where you provided courses/resources for SQL, ETL, Data warehouse, Cloud etc..Could you please provide some courses for Python from Data Engineering perspective (not Data scientist)?

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +4

      I will put together a python focused video. I was recently checking out a few courses on sites like data quest and Udemy for data engineers. So I will try to see how these are and report back.

  • @MohamedTarek-vt4lb
    @MohamedTarek-vt4lb ปีที่แล้ว +1

    Great outline!

    • @SeattleDataGuy
      @SeattleDataGuy  8 หลายเดือนก่อน

      glad you found it helpful!

  • @minhson1411
    @minhson1411 3 ปีที่แล้ว +1

    loved this roadmap

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      Glad you liked the data engineering roadmap!

  • @kazimali07
    @kazimali07 3 ปีที่แล้ว +2

    This was really helpful thank you so much!!!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      I am glad you enjoyed the video!

  • @Mehrdadkh87
    @Mehrdadkh87 2 ปีที่แล้ว +1

    Is data engineering for you, is awsome post.

  • @shubhampathak8955
    @shubhampathak8955 2 หลายเดือนก่อน

    I LOVE YOU SO MUCH DUDE!!

  • @kingjude-enerie535
    @kingjude-enerie535 2 ปีที่แล้ว +1

    Thanks @ Seattle. This is really explanatory and clear. Please i could'nt find the links for building the flask api or any of ther projects you listed.

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว

      That I believe was just a suggestion. But try tech with tim th-cam.com/video/GMppyAPbLYk/w-d-xo.html

  • @madelineflores3534
    @madelineflores3534 2 ปีที่แล้ว +1

    Thank you so much for this video!! 🙂

  • @chrischristi1818
    @chrischristi1818 3 ปีที่แล้ว +3

    This is AWESOME ; I'm studying Python, C# and Java right now ; but , I have an unending urge to pursue Data Engineering. Would it be possible to gain employment in the Data Engineering field without any sort of college degree ? Thanks for everything !

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +3

      Sure you could get a data engineering degree without a college degree..but it will be hard. Because either you have experience or college to get that first job. If you can get experience without a degree then you will be set..but thats hard to do.

  • @TheMrNomadus
    @TheMrNomadus 2 ปีที่แล้ว +2

    As an UX Designer from IT-sphere I always look at that amount of knowledge I have to learn to be able to become a Data Engineer and become very sad that it's almost impossible to figure out where to start especially when you're 33.

  • @shrikantprabhu1788
    @shrikantprabhu1788 3 ปีที่แล้ว +1

    Please make a video for interview preparation for data engineering , which sources to use for SQL practice (Leetcode SQL is very basic and might not be useful for data engineering SQL e.g. calculating active daily users etc) , practice data warehouse modeling or how to test a particular funnel etc.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Interesting. I have a few other videos on my list, but I like the video idea.

  • @jaysharma5822
    @jaysharma5822 2 ปีที่แล้ว +1

    Hey Ben! Thank you for the vide. It's crisp and comprehensive at the same time. You mentioned that you'll be sharing resources/links to learn/explore flask api. But, I can't find the link anywhere. Could you please pinpoint the link? Thank you again!

    • @brianbrophy1115
      @brianbrophy1115 2 ปีที่แล้ว

      It's in the Google drive link in the description

  • @annaphamclouds
    @annaphamclouds 2 ปีที่แล้ว +1

    this is such an amazing video. thank you.

  • @tebogoawotunde4373
    @tebogoawotunde4373 ปีที่แล้ว

    Great road map. What's your take on the Udacity Nanodegree program: How to Become a Data Engineer. Is worth having a look at for someone with no prior experience?

  • @ministerboan
    @ministerboan ปีที่แล้ว +1

    Good information.... thanks a lot.

  • @viniciusluiz8833
    @viniciusluiz8833 2 ปีที่แล้ว +1

    Great video!!

  • @behrad9712
    @behrad9712 ปีที่แล้ว +1

    Thank you very much!🙏

  • @aag3298
    @aag3298 3 ปีที่แล้ว +3

    Do you think getting the AWS Data Analytics Certification is a good idea and it will help in this road to become a Data Engineer? Also, do you have any source that works as a guide to learn how to document or give proper structure to the projects in github that will serve as portfolio?
    Your content is great by the way, greetings from Costa Rica.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      I though I responded to this one. I would say focus on getting data engineering certificates. With AWS you could get the big data aws certificate. Of course, that also depends where you are in your technical journey.
      You can use some of felipe hoffas pieces of work as an example. I am working to get him onto the channel so he can talk about his projects. Here is one of his projects hoffa.medium.com/400-000-github-repositories-1-billion-files-14-terabytes-of-code-spaces-or-tabs-7cfe0b5dd7fd#.qm2s97y25

  • @iakobkv271
    @iakobkv271 2 ปีที่แล้ว

    I think a video about the Data Mesh would be interesting from you

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว

      I have thought about it for sure

  • @kairoswave
    @kairoswave 3 ปีที่แล้ว +1

    Great content! definitely subscribed.
    I am a Software Engineer wanting to transition into Data Engineering, What is your take the Google Cloud Certified Professional Data Engineer Certificate Exam? Do you think that certs help?

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      I actually have a video on the google cloud certificate. I think, especially as a SWE it makes sense to get certs just so it becomes clear that you are making the switch. I usually say certs aren't that helpful for most people because they are getting it with 0 experience. But since you have experience, it can help round it out.

  • @rezahamzeh3736
    @rezahamzeh3736 2 ปีที่แล้ว +1

    @seattle Data Guy:
    It would be beneficial to introduce some materials (PDF, Link, TH-cam channel) for each specific skill set. That is the most challenging part for learners

    • @rezahamzeh3736
      @rezahamzeh3736 2 ปีที่แล้ว

      Especially about networking, OS, containerization, ... that are too broad

  • @woobulbul
    @woobulbul 2 ปีที่แล้ว +3

    Hey, thank you so much for this information, I have a few questions if I may:
    1. I am a CS major, with no previous experience in this field, do I need to pursue my masters as well? If so, what master should I pick to suite data engineering?
    2. As a fresh university grad, can I land entry level job in this field?

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว +2

      In general, most technical roles like software or data engineering don't need masters degrees as long as you can pass the interviews. Generally, its a good idea to get an internship in a DE position and then get a returning offer. That way you can get experience. There are jr. positions, but I noticed...as per usually...most of them want 2 years of experience.

  • @oluwadamilolajesutofunmi1358
    @oluwadamilolajesutofunmi1358 ปีที่แล้ว +1

    Thank you for this video.
    Is it important I get a laptop n which one should I get.
    I'm just getting started today

    • @SeattleDataGuy
      @SeattleDataGuy  8 หลายเดือนก่อน

      i like my mac...but as long as your computer 8-16gb of ram you'll probably be fine..There are for sure some engineers out there running circles around me on 2 Gbs of ram in vim

  • @nivretech2072
    @nivretech2072 3 ปีที่แล้ว +1

    Hi Ben! Thank you for the roadmap. I am torn in choosing whether to go with being a mobile engineer/developer or a data engineer. If you are in my place what will be your decision and which do you think will be more in demand in the future with these two? Thanks again!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      Thank you for the comment.
      I imagine both will have a similar demand. I would say you should take a few courses in both and build a mini-project and see which area you like more.
      Programming and data in general will be a necessary skill in the future. So I wouldn't worry about the perfect choice. Instead, focus on which area you enjoy.

  • @priyankpant2262
    @priyankpant2262 2 ปีที่แล้ว +1

    Hi, Thank you for this video. How much time do you think it would take to complete all the steps mentioned here ? I work in IT but have mostly worked as a consultant on the ETL tools like Informatica etc. I know about Data but Data Engineering is somewhat new to me.

  • @rishabhmediratta6200
    @rishabhmediratta6200 3 ปีที่แล้ว +7

    Hi man! I've been watching your videos since I got interested in Data Engineering. I'm not from a CS background, currently I'm majoring in Statistics at the undergraduate level. Given I can hain the skills, do you think I could land a job as a data engineer? Also is the IBM Data Engineer Professional Certificate a good way to get a high level view and get started? And what about the training on the AWS website that Amazon offers? Are they any good? Appreciate your videos!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +3

      I think this roadmap is a great way to get a high-level understand of what data engineers do. Most of the IBM, AWS, GCP and Azure certificates are ways for these companies to get you used to their products and they aren't as focused on helping you understanding data engineering.
      If anything, you should at least look at the basics to data warehousing at udemy here
      bit.ly/3wg94E2

  • @Ravit20
    @Ravit20 3 ปีที่แล้ว +2

    This is top class!!!!

  • @NVnun
    @NVnun 2 ปีที่แล้ว +1

    A good comprehensive methodology, have found this pretty useful as I strated out on my DE journey a while back. Can you please recommend a good way to develop strong sql skills ? I dont do a lot of data warehousing in my current DE role and also we dont have a traditional data lake so my prototypical ETL experience with SQL is low and I see most DE roles in the industry today test for intermediate to advanced sql.

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว

      What do you do in your day to day?

  • @himayata9600
    @himayata9600 2 ปีที่แล้ว +2

    Hey! I am currently going into my third-year of undergrad majoring in CS, found your page and now am interested in Data Engineering. I am beginning the UDemy A-Z SQL and Database course you recommended in another video to get a taste of data engineering. If I end up liking data engineering and want to take the next steps in this video, do you think I can complete at least up to step 7, 8, or 9 by the end of August if I keep my head down and grind? Currently have a Data Science/Analyst internship at a small company for the summer, but want to pivot and secure a big Data Engineering internship for next summer by being prepared for interviews in the Fall/Winter. Thoughts?

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว

      If you have time perhaps. But truthfully it sounds like you have an internship and you should focus on that for the summer. Maybe you can intern at the company again next summer and ask them to let you try out DE.

  • @montgomeryscottbrea2614
    @montgomeryscottbrea2614 2 ปีที่แล้ว +1

    Excellent content.

  • @RatFace_MonkeyEar_FishEye
    @RatFace_MonkeyEar_FishEye 2 ปีที่แล้ว

    Hi! Thanks for the video. I am a beginner DE myself and would like to ask a question about the Kimball’s books you recommended. If you had to pick only one of the 3, which one would you get and why?

  • @ramielkady938
    @ramielkady938 2 ปีที่แล้ว

    Good point about building your own APIs so you would know how to use them. Do you recommend we build our own OSs, Web Servers, and our own Apache Sparks so we can get the hang of it as well ?

  • @angelocello9967
    @angelocello9967 2 ปีที่แล้ว +1

    legend, thank you :)

  • @ukaszdugozima816
    @ukaszdugozima816 ปีที่แล้ว

    Hello! Thank you for your invaluable video! I find it extremely useful for beginners! I would like to ask about one thing regarding this map. I learnt Pandas in terms of Data Wrangling and Transformation. Therefore, how about Pandas for Data Engineers? Is it useful tool for ETL/ELT transformations? Obviously, the next step will be PySpark, but I would like to start learninig Pandas. It seems it is a good path for the next one. What do you think about it ? I would appreciate it if you could share your views about it.

  • @KhoaNguyen-gh2fo
    @KhoaNguyen-gh2fo 3 ปีที่แล้ว +1

    Hi Ben, thanks so much for this video. will you talk a bit more about learning cloud or recommend a Udemy course? Looking at Amazon learning I have no idea where to start

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      Hello! Thanks for the comment. I am working on a series of roadmap videos and the cloud is one of them. It will include what you are asking for!

  • @ataimebenson
    @ataimebenson 2 ปีที่แล้ว +3

    A good number of the Udemy courses you recommended in the pdf are quite Out-dated, that is a big learning challenge. It would be very appreciated if you review this video in your free time.

  • @3dascension744
    @3dascension744 3 ปีที่แล้ว +1

    I like your friends strategy of guessing what would be asked. That is very clever

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Yeah, it forces you think just one layer deeper. Like what types of questions should i expect? What questions have I seen in the past?

  • @readyready2957
    @readyready2957 3 ปีที่แล้ว +1

    Dear Sir, I really love this video. Thanks a lot. But I have a question about the 'Kimball's Data Warehouse Toolkit' book, I clicked the link of the book you added into the Road Map, but that book is the different version from the image of the book you displayed on this video, I think the 3rd edition has more cases study and general than the 3 book collection on the video. So should I read the book you added into the roadmap or the collection of 3 books like on the video?

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Whoops that was an accident. I enjoy the one in the link because it helps break down the tables and SCD concepts. Sorry for any confusions

    • @readyready2957
      @readyready2957 3 ปีที่แล้ว +1

      @@SeattleDataGuy Thank you very much.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Yeah I don’t know how I missed it.

    • @readyready2957
      @readyready2957 3 ปีที่แล้ว +1

      @@SeattleDataGuy Don't worry about that. This's really a great video.

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Thank you, I am always trying to give the best i can. Good luck on your data engineering journey.

  • @ChaeWookKim-vd7uy
    @ChaeWookKim-vd7uy 3 ปีที่แล้ว +1

    Hello Ben! I am computer science student from south korea. I am learning a lot from you thank you :)
    I want to be a Data Engineer after i graduate and thinking about studying machine learning in the future.
    How much math and static requires to be data engineer?
    Does high school math level will be ok?

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว +1

      I don't think data engineering needs a lot of math. I do think it would be best to have some statistics (because sometimes we do apply this) and general pre-calc. I would also add in that having an understanding of logic courses would also be helpful.

    • @ChaeWookKim-vd7uy
      @ChaeWookKim-vd7uy 3 ปีที่แล้ว +1

      @@SeattleDataGuy thank you!

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      @@ChaeWookKim-vd7uy Good luck on your data engineering journey!

  • @ale-3385
    @ale-3385 2 ปีที่แล้ว

    Excellent!

  • @oyindamolavictor
    @oyindamolavictor 3 ปีที่แล้ว +1

    Hello, please whats your take on the Data Engineer Track from DataCamp... is it a great process to follow... by the way you really have great contents, they are awesome

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      I have actually been looking into datacamp recently. I think it makes sense. But let me test it out more and I will come back with a video on datacamps data engineering track.

    • @oyindamolavictor
      @oyindamolavictor 3 ปีที่แล้ว +1

      @@SeattleDataGuy Awesome.. thank you😁

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      @@oyindamolavictor You're welcome!

  • @gunnersshishir11
    @gunnersshishir11 3 ปีที่แล้ว +1

    Thanks..this is amazing

    • @SeattleDataGuy
      @SeattleDataGuy  3 ปีที่แล้ว

      Thank you for the comment! This comment is amazing.

  • @gtang31
    @gtang31 2 ปีที่แล้ว +1

    can you make a video on different ways of building ETL infrastructure and scaling it

    • @SeattleDataGuy
      @SeattleDataGuy  2 ปีที่แล้ว +1

      Possibly, this would be far down the line though. I often recommend people try to look for services to scale their ETL infra. Like with Airflow, its probably better to use Cloud Composer or Astronomer vs try to manually scale.

  • @Nachiket_upadhye_23
    @Nachiket_upadhye_23 2 ปีที่แล้ว

    Hello, thanks for the video. I want to get into IIOT space, Do you think I should focus more on streaming analytics or data warehousing