Data Engineer Roadmap | You can be a Data Engineer | Do not overwhelm yourself

Опубликовано: 27 Сентябрь 2024
на канале: ETL-SQL

5,926

258

Free SQL Pattern Training: https://etlsql.kartra.com/page/sps-fr...

Do you understand SQL but still cannot write SQL queries correctly ?
Are you afraid to switch jobs because of the SQL interview rounds or have you failed SQL Interview earlier ?
If you are someone who understands SQL and need more confidence to solve SQL queries correctly, I would like to share my recent online course especially created for you.
Check for more details: https://etlsql.kartra.com/page/sql-pa...

Hi everyone
I have more than 13 years of experience working as data engineer for different companies.
In this video I have shared roadmap for aspiring Data Engineers as per my professional experience & observation.

In this video we will cover following topics:
Introduction
Why you should listen to me ?
Bonus Tip
Define Data Engineer
3 non negotiable skills - SQL , DWH Concepts, Specific environment knowledge
First Skill - SQL
SQL Basics
Case statements, Joins, Date & String functions
Intermediate SQL - Source to Target Mapping sheet into SQL logic
Advance SQL level - end to end data pipelines
Stored Procedures/Macros/SQL Files/Orchestration
Second skill: Datawarehouse Concepts - be comfortable with theory at least
Third skill: Environment Specific knowledge - RDBMS Data Engineer / Cloud Data Engineer / Bigdata Data Engineer
Complementary Skill 1 - Shell Scripting
Complementary Skill 2 - Python
Optional extended Skill 1 - Data Governance -- Data Architect
Optional extended Skill 2 - Reporting & Visualisation -- BI Engineer
Optional extended Skill 3 - Data Model -- Data Modeler
One more tip - relate SQL to DWH Concepts
Personal tip - learn something new every day
Google & bookmark useful links

Practice SQL questions on Data Lemur platform.
I will highly recommend to sign up for this platform.
I am sharing my referral link below for easy reference.
https://bit.ly/3SuF3wf

Hope the video helps you.
If you liked the video , please hit the link button.
If you have any questions/feedback please drop a comment below. I read each & every comment and it really motivates me.

Best,
Raj
You can download the roadmap image from below link:
https://etl-sql.com/roadmaps/

Disclaimer: All the opinions suggested in this video are my personal observation & experience. This has nothing to do with my current or previous employers. Also this roadmap should be used as a guideline to help you and it is not a guarantee for any job.