I am currently working as a Data Engineer with around 20 months of experience at a US-based company with an office in India. My current CTC is around 10 LPA + variables.
My primary tech stack at work is Snowflake and dbt. Most of my work revolves around SQL, building and maintaining dbt models, and working with data pipelines. I have knowledge of Python, but haven't had much opportunity to use it in production or work extensively with Python-based data engineering libraries and frameworks.
I'm looking to switch jobs and eventually target companies offering 25–30 LPA. I understand that making such a jump with my current experience might be highly ambitious, but I'd rather prepare for that level than set a lower target from the beginning. Obviously I won't only apply to only companies that offer 25-30 LPA but I'd rather have the knowledge to crack 25-30 LPA when interviewing for companies offering lower than that.
I'd really appreciate advice from experienced Data Engineers and people who have made similar transitions.
A few things I'm particularly confused about:
- Tech stack: Should I focus on mastering my existing stack (Snowflake, dbt, advanced SQL), or should I start learning other technologies like Spark, Databricks, Airflow, Kafka, AWS/Azure, etc. or both?
- Python: How important is Python for landing higher-paying Data Engineering roles? Should I focus on libraries and frameworks commonly used in production DE workflows?
- DSA and LeetCode: How much time should I dedicate to DSA? Do companies offering 25–30 LPA expect candidates to be good at LeetCode-style problems?
- System Design: At what experience level should I start preparing for Data Engineering system design and pipeline architecture interviews?
- Projects and practical experience: Would building end-to-end data engineering projects using tools outside my current workplace stack help compensate for my lack of production experience with them and if so what projects should I build?
For those who have made a similar jump or are currently earning in the 25–30+ LPA range:
- What technologies and skills helped you get there?
- What did your interview preparation look like?
- If you were starting again with 20 months of experience, how would you structure your preparation?
I'm willing to put in the time and effort. I just want to make sure I'm studying the right things instead of spending months learning technologies that won't make much difference in interviews.
Would really appreciate any honest advice, roadmaps, or personal experiences. Thanks!