Google Data Engineer Interview Experience

[@rocknur]

Jash thanks for the video. Ur vlogs are very natural... And u sound very close to all of us...

[@JashRadia]

Thank you! Great to know. I try to keep videos natural 😊

[@imarupakula]

Jash, Your journey is Inspiring. Thanks for the video...

[@JashRadia]

Thank you! 😊

[@varunrithvikgudluru4904]

Congrats for First Video on YT ....Wishing you the longest , prosperous way

[@JashRadia]

Thank you so much :D

[@mohammedsami9214]

Congratulations on the milestone!! I really liked the climax of the video. Keep going!

[@JashRadia]

Thank you! 😁

[@pranshusharma5490]

Awesome video! Your journey is very inspiring. Your thoughts, posts and other extracurricular activities like playing Tabla in free time(I also love to play percussion instruments) is really amazing. Keep doing up the great work and sharing your experiences it helps a lot. Thanks 🙏

[@JashRadia]

Thank you so much! Glad you enjoyed it :)

[@santoshchavan1929]

Very nicely explained ,hope i will definitely work in Google someday...

[@JashRadia]

Thank you 😊 Keep manifesting and working ✌️

[@I_capture_emotions]

Keep hustling and keep shining

[@JashRadia]

[@aishwaryaradia]

Excellent!! Keep up the good work 👏

[@JashRadia]

Thank you! 😃

[@azam1200]

Start majedar tha bhai

[@manishchhillar5991]

Really helpful and motivated.

[@JashRadia]

Thank you! 😊😊

[@dhruv333]

Thank You So Much Sir 😊

[@NeeteshSrivastavaShri]

This great Jash.. and huge Congratulations on getting selected on Google

[@JashRadia]

Thanks Neetesh! 😁

[@konasrinivas5330]

Hi jash ,can u do a roadmap video for data engineer role like what all needs to be learned

[@JashRadia]

Sure. Will keep this in mind. Thanks for suggestion 😊

[@ajr1791ze]

Could you please suggest resources to prepare for Big data questions and system design question.

[@kunalrajure3508]

Nice informative video sir!!... can you please tell the roadmap of data engineer and how to prepare and from where to prepare like source...thank you.

[@JashRadia]

Thanks foe watching the video. Data engineering roadmap is my next video. Watch out for it this weekend 😊

[@priyankapandey9122]

Hi Jash, can you tell how to prepare for data modelling and system design type of question.Do you have any sources or book suggestion?

[@JashRadia]

You can pick one of these for data modelling. Or also choose interlipaat free videos on youtube. www.udemy.com/topic/data-modeling/ For system design, there is no one course since these questions are highly customized based on your experience. I am going to create a video on this, soon. So stay tuned.

[@priyankapandey9122]

Thanks. looking forward

[@deepakts12]

Could you make videos on data engineering use cases with pipelines

[@JashRadia]

Sure, noted. Will do. Thanks for suggestion

[@maheshphadale976]

Extra tips 👍🏻

[@ranjan_akash]

Thankyou Jash

[@JashRadia]

It's a pleasure!

[@nileeshadeshpande9553]

I never usually comment on any videos, but here I have to say, you have wonderfully explained everything that I had doubts about. Thank you so much for the apt. explanation. I have applied to google a couple days back. I don't know if the recruiter will get in touch with me or not. Just hoping for the best!

[@JashRadia]

This is great to see, Nileesha! Thank you for supporting and all the best 😁

[@adiy77]

Amazing content, Jash.. I just subscribed..could you tell me if it is required to learn spark sql also if you know pyspark already?.. and I would request you to make possible interview questions for Data engineer and self projects one can do to gain confidence for facing interviews ..

[@JashRadia]

Spark sql is like PySpark and SQL had a baby together. If you know them both then you have nothing to worry about. And sure, thanks for the suggestion! 😊

[@asianand4885]

Sir I need to prepare Spark SQL and Pyspark from where to read these 2 topics please guide ?

[@JashRadia]

Take Frank Kane's course called taming big data with Python on Udemy. You will learn both these topics there.

[@Shaikashfaqsaleem]

Hii Jaysh, I have 7+ years in ETL datastage, my primary skill sets are sql unix python and data warehousing, currently I am learning gcp and preparing for professional data engineer certification, so what role can I apply in google and what are the areas I need to concentrate more

[@JashRadia]

If you learn spark, you can apply for DE role with this skillset. Another option is CMC - cloud migration consultant and TSE - technical solutions engineer and AE - Application engineer

[@madhurshinde4988]

brother i had a general doubt, i have 0 years of experience in data engineering but i have worked on case studies or scenario-based problems involving the domain. Can i apply for jobs like Data engineer which have requirements of 4 to 10 years of experience?

[@syedanwar154]

What level of python needed for Data engineer role in Google

[@JashRadia]

Python is not a requirement. I solved it with Python. You can use any other language. For DSA, solving medium questions on leetcode should be enough.

[@itsrainingcatsanddogs]

Hey Jash, I was looking up for Data engineer roles on Google careers but they just have many different names for these roles? What exactly is your role called?

[@JashRadia]

We are called Strategic Cloud Data Engineers. Here is the careers page posting careers.google.com/jobs/results/118806257793409734-strategic-cloud-engineer-data-and-analytics/?company=Google&company=KZbin&employment_type=FULL_TIME&hl=en_US&jlo=en_US&page=16&q=&sort_by=date

[@RohanKumar-mh3pt]

I have 7 months of experience in Azure data engineer sir I want to know how should I get grip on Data Modeling questions and is there is any specific resources available from where I can prepare for this Data Modeling Questions and System design question like how to optimise the data pipeline

[@JashRadia]

Hi Sanjeev, this might help you in data modelling questions. This is a simple example but it can grow upto 6+ tables but concepts remain same. kzbin.info/www/bejne/r2OndWuqds-AZqc I didn't refer to any resource for system design because of my experience. Although i will drop a video about how to prep for this since i am getting many questions on this.

[@RohanKumar-mh3pt]

Thank you and for practice is there is any resource available where I can practice data modeling questions?

[@diptanjankar9848]

please bhaiya make a full roadmap of data Engineer...

[@JashRadia]

Sure! Added to the plan. Stay tuned 😊 thanks for suggestion

[@harshSingh-if4zb]

Hi Jash, Thank you for share good information. I have one query. Was your linkedin profile set "open for work" status when google recruiter reached to you?

[@JashRadia]

It was open privately (only recruiters can see that), not with the public green banner. Regardless, I get many requests even if it's not open. Data engineering is in demand and active LinkedIn profile can really help.

[@harshSingh-if4zb]

@@JashRadia thank you for reply:-)

[@rushikeshraut7949]

Hi ,i am rushikesh raut Now i am studying 2nd year of b.tech Can I get job in Google as a data engineer ?? I have done polytechnic in IT field.. which is in Maharashtra .. Google is my dream company 😍....

[@JashRadia]

I would suggest get some experience first as a data engineer and then apply after 2 years at Google directly on career page or through a referral

[@DataCoholic]

Do you have prior java development experience? Do you use spark with scala or pyspark?

[@JashRadia]

I use Pyspark. I know java but not much experience

[@pratikthombare4561]

Ynwa❤

[@abhipawar9407]

Congratulations sir Did Google Pune hire for sde role and where is Google Pune office it's location??

[@JashRadia]

Yes SDE positions are also there in Pune. But right now hiring is slow. Google office is in KP. It will open soon ..

[@abhipawar9407]

@@JashRadia Thanks sir for reply it's means a lot

[@JashRadia]

@@abhipawar9407 no problem! 😊

[@sakshiarora346]

heyy Jash, thanks a ton for sharing your experience, it was very insightful. I just wanted to know if there's any chance of companies like google hiring undergrad freshers(I'm a 4th year student), for data engineering roles, since a lot of skills you mentioned usually come with hands on experience? and if so, what resources do you suggest to get started w these. thanks a lot :)

[@JashRadia]

Hi Sakshi, thanks for watching! For this role, I have not seen Google hiring freshers. As it requires prior experience in data processing frameworks and algorithms. However companies like ZS where I was working previously are a good place to start if you're interested in this role as they would hire freshers.

[@harshalpande6637]

Hi, is there any data analyst role in Google? Because I heard about data enginner & data scientist role only

[@JashRadia]

I haven't come across such role yet. Not sure

[@harshalpande6637]

@@JashRadia alright, thanks for the reply 🙂

[@pblmx1016]

Now I am in the process for Cloud Data Engineer role, last week I had the first round, immediately my recruiter scheduled the next 3 rounds for the same day, that is tomorrow, I do not know if that is good news, what do you think? Thank you very much for your videos, they have been very useful.

[@JashRadia]

This is expected. This means that you have cleared the recruiter screening. Now you will have 3 rounds of technical interviews. So prepare well.. These rounds are not knockout rounds. You have to give these 3 and then their cumulative results will either knock you out or keep you in the process. All the best!

[@pblmx1016]

@@JashRadia Yes, exactly. The first interview was a screening interview, the second was a technical interview about general Big Data issues and a quick coding test. I expected that the next interviews would be one every week and not all on the same day, interview marathon xD was what surprised me. Thanks for the good wishes, I hope to be a Noogler soon, any recommendations for salary negotiation?

[@siddharthnahata757]

@@pblmx1016 Hi, Can you please share what all rounds were there for your Google Interview for Data Engineer position?

[@kushwanthkandala8244]

Does Google hire DE I see mostly swe or sde roles right?

[@JashRadia]

Right now there are no DE openings but it can again open up soon

[@fg-ki4nx]

Sir is it possible for fresher to get data engineer job?

[@purushothametneni-yy6mt]

Hi sir. This is purushotham from Andhra. How much time it will take to learn all the concepts like sql, python, hadoop and spark.

[@JashRadia]

Hi Purushotham, each concept can take about a month. If you follow my roadmap video it can take around 6 months

[@RohanKumar-mh3pt]

My google interview for big data gcp role is going to schedule soon sir i just want to know what are the important areas I need to focus and do they ask Designing level questions to me? I have 1 year of experience

[@JashRadia]

Can you mention the exact role name?

[@RohanKumar-mh3pt]

Technical Solution Engineer Big Data GCP

[@RohanKumar-mh3pt]

They are asking to share my contact detail But sir I have 11 month of experience in Azure Data engineer role what are the question I can expect from them

[@JashRadia]

TSE role is not data engineering role. It is a support role. Make sure you really want to move to this role. IE. This is not development role. They might ask you mamy debugging questions around OS and spark jobs. I am not sure about exact interview process of this role.

[@RohanKumar-mh3pt]

Thanks sir

[@AkankshaTyagi-x1f]

Hi Jash!! This video is really helpful. Can you please tell minimum experience required to apply for DE role at Google?

[@JashRadia]

About 2 years AFAIK

[@siddharthnahata757]

Hi Jash, congratulations 🎉 Can you please make a video, how to prepare for System Design round? And for Dsa, what all topics they generally focus for DE? As I am having 3.5 yrs of experience in different domain, so what all areas I should Focus for DE interviews?

[@JashRadia]

Thank you! First question, yes I can do a video. Thanks for suggestion. Second one, for DSA, I usually practiced simple data structures like array, linked lists, dictionaries, tress etc. Also prepare for file manipulation based DSA questions. I prepared from hackerrank. Although, can't guarantee that google will not ask out of these topics. every interview is different, this is my prep experience. For 3rd question, it will be similar to me then. I also have 3 YOE.

[@devanshuatram7073]

Sir you how I can start as an data engineer

[@JashRadia]

See my roadmap video on this channel

[@meetpatel.47]

Any hack for leetcode premium?

[@JashRadia]

You don't need premium tbh. There are sooo many questions available for free which is sufficient

[@meetpatel.47]

@@JashRadia thanks brother, I have solved all leetcode free SQL queries. I'm solving dsa through striver a2z dsa sheet but some time I see and random question I couldn't not apply logic for it, can you guide me about it.

[@meetpatel.47]

@@JashRadia on striver sheet the questions are topic wise so while solving questions I know about the topic and logic but solving randomly is very hard.

[@biswadeep27]

You definitely will not walk alone from here will you 😊 #YNWA

[@JashRadia]

Yess ❤️❤️ #YWWA 🔴

[@ektakumari6269]

This is so informative Jash..can you tell which all topics should we prepare for DSA like other then Array,strings,linked list. Also can you help how to prepare for System design and data modeling round. What was your preparation strategy..

[@JashRadia]

Thanks Ekta. I had prepared basic data structures like you mentioned. Didn't practice a lot of DP or graph. I used hackerrank for this. System design is a little tricky to prep for. You need to google some basic batch and streaming pipelines' architecture and if you know one of the clouds then it will be helpful. For me, my old job had a lot of this daily. So it was simpler. Data modeling case study is also something you can search for. I will try to keep these questions in mind and also try to create a video for qna.

[@aayushranjan5572]

Op

[@brijesh0808]

Hello, thanks for putting efforts on the video. I have a question like, I am not a computer student, although i am working in IT from ~4 yrs and know like intermediate coding, but how can i prepare for DSA, System design, All the DBA stuff, big data stuff, etc. I have expereince in python and airflow only that too basic to intermediate.

[@JashRadia]

If you are new to data engineering. Focus on learning sql and python/scala first. Then you can learn spark and other technologies. You can follow different udemy courses for this.

[@brijesh0808]

@@JashRadia thanks. Why don't you make your next video in same topic 😊

[@JashRadia]

@@brijesh0808 Sure. I will definitely make a video on this. I will be able to drop 1 video every 15 days. I'll add this in pipeline for next month! Already planning to have some other important topics around resume and system design in my upcoming videos this month. 😊

[@sahilkumarsingh]

@@JashRadia Hey man, waiting for the system design video !!

[@itsrainingcatsanddogs]

How are these google recruiters reaching out to people lmao and why would no one reach out to me XD

[@JashRadia]

As I said your approach of applying can be different. I have had many recruiters reaching out to me not only from Google but others like Amazon, Microsoft, etc. I think this is because I have a very active LinkedIn profile which helps a lot. If you don't get them, don't worry. You can apply directly or with a referral with someone you know. But right now, hiring is very slow. Almost frozen. So I'd recommend to wait till 2023.