Data Engineer's Incredible 300% Hike Story: Switching from TCS to Target | Work from Home

In this video we have Subham Saha who recently switched his job from service based to product based company with 300 percent hike. We discussed following points in the podcast:

1- How he kept himself motivated to give 20 interviews after multiple rejections
2- Interview process at Target
3- What kind of SQL and Python questions were asked
4- Resources to prepare for SQL, Python , Big data and Cloud
5- Big data and Cloud Interview questions
6- Salary ranges for data engineers and product and service based companies
7- Motivation for Data Engineers

Zero to hero(Advance) SQL Aggregation:

Most Asked Join Based Interview Question:

Solving 4 Trick SQL problems:

Data Analyst Spotify Case Study:

Top 10 SQL interview Questions:

Interview Question based on FULL OUTER JOIN:

Playlist to master SQL :

Rank, Dense_Rank and Row_Number:

#sql #dataengineer #python

[ankitbansal]

Do like the video for more podcasts. Master the SQL with my zero to hero course :

[rakeshranjan]

It’s hard to believe someone getting 300% hike in today time, my interview also went very well both in sql, power bi but still no one is ready to give more than 60% hike

[arpanscreations]

To the point and no bakwas. Thanks for this amazing podcast Ankit. Please keep on posting such amazing insights

[praveenbhandari]

Hey Ankit sir please make a course or playlist of Data engineer from zero to hero

[mrinalinighewari]

If you can mention resources which candidates have used, that will be really helpful. As they mention general youtube, try to take specific channel's name for other technologies.

[maqbul]

Totally genuine podcast Ankit like your content, as always. You asked the right questions and we got the right answers. No orchestra. Great work 👍👍. Wish to see such genuine podcast in future as well for data analyst role as well. Best wishes 💐💐💐

[ShubhamSingh-pumj]

Can you please show ur resume so that we can also get an idea of how to get it selected via AI software level

[shrutibag]

Hello Ankit, What clarifying questions to ask to the interviewer, rather than just jumping to coding

[jyotirmayasatpathy]

Can you please provide the YouTube channels you referred to

[swayam]

Hi ankit sir.... Can you please guide me what I need to study for my pl/sql interview

[memesmacha]

please include question regarding "how to deal with notice period "

[delhilife]

For Python, where we can get good resource.
In comparison to sql we have good resource of your course and channel.
Similarly at same level do we have any good resource of python
Please guide.

[Rajag-icxt]

Ankit Bansal, I have total 7 years experience. SQL SSIS SSRS but finding difficult while facing SQL related questions. Which course would you recommend for me?

[raheemmd]

Kindly request his resume and provide us it will be helpful.

[SenthilKumarBDE]

Package from and to ? To get motivated others.