The Ultimate Data Engineering Interview Guide

[@JashRadia]

Thanks for watching! Let's talk more about it here 👇 Amber for finding best student accommodation: amberstudent.com/partners/jash-radia-1734957030

[@mavsidharth]

This is a goldmine for prep. Thank you!

[@kaafi_alsi]

Much needed video , thanks for this crisp!!

[@aniketjadhav32]

Can you please make a video or share your thoughts on how your role overlaps both Data Engineering and AI domain.What is your day to day work and how can one transition into AI being a data engineer

[@JashRadia]

Sure, thanks for suggestion!

[@jayeshjoshimalakolikar4830]

Thanks @JashRadia Great Explain each and every topic very clearly for Data Engineer role

[@aishwaryaradia]

Detailed & Informative Video 👌🏻 Keep it up ✨️

[@JashRadia]

Thank you! 🙏

[@somnathdutta6311]

Hay Jash, I am following you from your very first video, You are very talented and knowledgeable person. It will be great if you start teaching on youtube and share your knowledge with us. There are very few good resources for DE on KZbin and s specifically Data Modelling and System Design for DE is not available at all in KZbin. It will great for all if you start teaching on KZbin.❤ And if you need help to curate teaching content I an free to help as i have worked with some know KZbinrs in teaching field.

[@JashRadia]

Hey, thank you so much for following my content. I would love to do something like that if i could but it's challenging to find time for me. I'll keep your suggestion in mind! 😊

[@mohitmotwani9256]

Amazing video. Quick question. In the data modelling question, do we need to create a database or a data warehouse? I see you create entities and relationships (ER diagrams) but you also listed Facts and Dims but didn’t create any snowflake or star schema. Little confused. Could help me understand what is really expected from this question

[@JashRadia]

It is generally an OLAP data warehouse modeling. You will use snowflake or star as per requirement or hybrid as well. If you see my ED diagram, I am using hybrid in this case.

[@amankharwar268]

Goat level explanation ❤

[@KSengupta]

Thanks for this video, was waiting for this...

[@Drizzy-ze2xg]

When are you launching an extensive DE course fr fr

[@Discussionontech]

Hi Jash Where can we practice data eng. interview.Please make a video on this.And also what is the best resources to learn pipeline buiding and prepare etl tools?

[@jaladhithakur7567]

awesome video, to the point!!! 👍👍👍

[@PraveenKumarBN]

Jash is a life saver for Data Engineers... It's so difficult to get mentoring for DE... Im planning to learn AWS but I'm confused whether i should do it first or after System Design preparation. What do you recommend i start first? System design or AWS certification?

[@JashRadia]

Learning aws is a prerequisite for system design, so I'd say aws certification should be first.

[@PraveenKumarBN]

​​@@JashRadia Ok, then AWS Solutions Architect Certi first and then system design.

[@sujitsadagopan9823]

Can you recommend a book that will help us get strong from a system design perspective?

[@JashRadia]

The 4 resources mentioned in the videos are much better way to learn system design than a book, but if you like books may be check out designing data intensive applications. The problem i have with that book is it's too lengthy

[@AsangaRamanayake]

Very insightful!!!

[@amankharwar268]

Any Specific resources to Learn Dsa in python

[@pradeepchakraborty9910]

Hi Jash, thank you for the wonderful advice. Could you also share some insights on the learnings DE need to have on the AI side considering the current market trends with AI Agents & Generative AI coming in?

[@JashRadia]

Yes, I made a video on this: kzbin.info/www/bejne/aZrLo6Z9g5dpbM0

[@AshuToshSharma99]

Hi Jash, which coding language did you use for the interview?

[@JashRadia]

Python

[@heropantheren2609]

Hey! I’m currently in school studying MIS, I’m thinking of going to an analyst role for a couple years but then pivoting to data engineering… is that feasible? Of course self learning along the way will be essential.

[@JashRadia]

Yes this is one of the most common paths for DEs

[@artofheart2891]

Your Tips & Tricks 👌🏽👌🏽👌🏽👍🏻

[@MathanPrasathR]

How much can someone with 2 years of data engineering experience, along with some AWS knowledge,aws basic certificates and AZ-900, DP-900, and entry-level Databricks certifications, expect to earn?

[@mohammadthousif5373]

Please make a video the kind of projects that should be built to put on resumes

[@JashRadia]

Sure, thanks for suggestion!

[@Uda_dunga]

what is the purpose of dsa in data engineering?

[@JashRadia]

Data engineering is a branch of software engineering. Any SWE roles have DSA

[@Uda_dunga]

@@JashRadia where we use dsa in data engineering?

[@JashRadia]

@@Uda_dunga literally everyday unless you are ne etl developer 🙆‍♂️

[@Uda_dunga]

@@JashRadia can u give me some examples?

[@shashankx18]

@@Uda_dunga +1

[@yashvashist4514]

Hello sir To shift from ETL and MDM developer profile to data engineer role with 2.5-3 yrs of experience. What shall be expected and primarily what skills should be required?

[@JashRadia]

For skills about DE roles, please check my roadmap video. I am not sure specifically for iqvia, reach out to someone who works at that role in that company on LI

[@dhruvg530]

I am currently working in finance and want to switch to data engineering. If I have the correct skills will they be open to interview someone with a different background and 10 years of experience

[@JashRadia]

You need highlight directly or indirectly how your experience used data somehow to make an impact at your work. You will also need a couple of really good projects, but yet it's possible. You might not get L5 level which is common at 10 YOE but if you're okay with down leveling to L4, it is possible. Overall if you go into a good company, downleveling won't matter much and you'll still make good money in the long run. I will also recommend trying for data analyst profile, get 2 YOE and then go to DE profile, which is much more technical.

[@dhruvg530]

@JashRadia thank you so much! And for the DA role I should concentrate on Python (DSA - array and strings), Pandas, SQL, and Power BI?

[@JashRadia]

@@dhruvg530 sql, data visualization, data modeling, etc are more important. Dsa is much easier or non existent in some companies.

[@victory99866]

Can bba (finance) become data analyst ?

[@JashRadia]

Yes!

[@shivamjha4410]

Hello bhaiya i am software engineer at accenture with 6 months of working experience i am working on snowflake data warehousing, i want to know how i can be in faang or equivalent company when i have 2 year of working experience, what should be your advice to me please reply.....

[@JashRadia]

Focus on the points mentioned in this video for interview related tops. also do a good project (solving something unique) and a certification and then look for referrals. You don't need to wait for 2 years. Try applying after 1 year

[@shivamjha4410]

@@JashRadia thanks bhaiya i follow these advices 👍