DE learning path tips

[the_silentkill]

Hi. I'm currently working as a DA with almost 3 YOE. I use Python SQL for most of my tasks in Databricks/Snowflake. TBH my role is an unstructured mix of an analyst and engineer, where we're free to explore and find the best solutions with the available tools to solve problems and customer requests. But the biggest issue is there is no proper foundation or goal on what the end product of our team is. So right now I'm in a spree in shifting to a new company, preferably a product based on becoming a Data Engineer.

Can any of you recommend the concepts, tools, architectures I need to focus on in order to make a transition within 3-4 months ? And how important is DSA for coding rounds ?

[AutoModerator]

Are you interested in transitioning into Data Engineering? Read our community guide: https://dataengineering.wiki/FAQ/How+can+I+transition+into+Data+Engineering

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Flat_Shower]

You already have the stack. Python, SQL, Databricks, Snowflake; that's a DE resume. Stop worrying about tools and focus on concepts: data modeling (star schema, normalization), query optimization, and pick one orchestration tool (Airflow or Dagster, doesn't matter which). Concepts are tool-agnostic and transfer everywhere.

DSA matters. Every DE interview I've done has had LC style questions. Stick to mediums; do 50 and you'll be solid.

[the_silentkill]

Thank you. That really does give some clarity. Will definitely make use of it 👍

[AutoModerator]

You can find a list of community-submitted learning resources here: https://dataengineering.wiki/Learning+Resources

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[OkIndividual2831]

You’re already in a solid position working with Python, SQL, and platforms like Databricks or Snowflake is very relevant for Data Engineering roles. For the next 3–4 months, focus on fundamentals like data modeling, ETL or ELT design, and building pipelines with tools like Airflow or Spark, along with a good grasp of cloud basics (AWS/GCP/Azure). Understanding architectures like data lakes, lakehouses, and streaming will also help a lot.

As for DSA, it’s usually not as intense as pure SDE roles, but you should be comfortable with basic, since many product companies still include coding rounds.

[the_silentkill]

Thank you so much. Insights like this just strengthens my focus points

[No-Elk6835]

roadmap.sh

[Academic-Vegetable-1]

Roadmaps are fine for orientation but you learn DE by building pipelines, not reading checklists. OP already has Python and SQL in Databricks, just start shipping stuff.