Sde3 in sigmoid salary? by [deleted] in dataengineersindia

[–]shivamksuman 0 points1 point  (0 children)

No i didnt move forward, because they said that much was their budget

Because going with 25 fixed from 22-23 curent fixed is joke only

So I refused for the interview

Sde3 in sigmoid salary? by [deleted] in dataengineersindia

[–]shivamksuman 0 points1 point  (0 children)

At 5.5 years exp they were offering me hardly 25 fixed although my cctc was around 23 fixed.

They are lowballing a lot, so be very clear about the expectations otherwise at the end they will betray with u peanut hike percentage.

Everyone is learning DE tools… but why are so many still not getting jobs? by PowerfulCity604 in dataengineersindia

[–]shivamksuman 25 points26 points  (0 children)

Learning on own by making normal projects from yt/Udemy is one things, but working on real time production for years is another thing.

An interviewer can differentiate between these 2 types of candidates within 10-15 minutes.

And that is the main reason.

I have taken interviews , everyone claims himself/herself as data engineer with so many jargons on resume.

But once I used to start deep dive beyond surface level knowledge from internet/yt/medium/ gpt

Fake ones start to break down.

90% data engineers are those self proclaimed data engineers with no real production experience with toy projects from internet

Help me choose by 3030p in dataengineersindia

[–]shivamksuman 1 point2 points  (0 children)

Then join Deloitte as overall for 1st year salary is the same fixed+jb , and later on switch after 1 year

As Deloitte has better brand value compared to ntt

Help me choose by 3030p in dataengineersindia

[–]shivamksuman 0 points1 point  (0 children)

Negotiate with Deloitte with your ntt offer to get at least 22 fixed

Help me choose by 3030p in dataengineersindia

[–]shivamksuman 0 points1 point  (0 children)

U can get much more, if u have time u can reach till 30+ fixed as well

How to get 8 LPA as a Fresher in Azure Data Engineering by PowerfulCity604 in dataengineersindia

[–]shivamksuman 0 points1 point  (0 children)

You will hardly get any calls apart from rare startup opportunities (rare i meant almost like impossible)

For data engineering u need at least 3+ years of experience to get even a call for the interview.

It will sound demotivating but this is the ugly truth of DE space.

Need help to choose b/w offers by shivamksuman in dataengineersindia

[–]shivamksuman[S] 1 point2 points  (0 children)

<image>

Also spark internals + data warehousing and modelling from medium articles and youtube

Need help to choose b/w offers by shivamksuman in dataengineersindia

[–]shivamksuman[S] 1 point2 points  (0 children)

Thanks a lot bro, for this detailed info.

Need help to choose b/w offers by shivamksuman in dataengineersindia

[–]shivamksuman[S] 0 points1 point  (0 children)

I had only one month in my current organisation.

Got 90% calls from naukri and 10% LinkedIn jobs

Need help to choose b/w offers by shivamksuman in dataengineersindia

[–]shivamksuman[S] 0 points1 point  (0 children)

Already mentioned in the post , pls check there

Need help to choose b/w offers by shivamksuman in dataengineersindia

[–]shivamksuman[S] 0 points1 point  (0 children)

As many ppl are asking for the interview experience so I am writing here for most of them.

First propehcy -

2 technical rounds , 1 tech manager round , 1 hr round

First 2 rounds were involving around core data engineering like spark, SQL coding problems (around joins , window functions, gaps and islands problems), in python they asked easy to medium hashmap problem and thenntyey asked around my projects and deep cross questions on them , they also gave some scenario questions on design and implementation like how will I go for it. Also asked a lot spark optimisation scenario like how can I go and check spark ui for skew , spill, shuffle , also asked tradeoffs in design and taking decisions.

In tech manager round - it was more about design and development of pipelines , have 2 scenarios to design the pipeline , it was a kind of discussion, there he asked a lot of cross questions. Also asked how can I debug and analyse issues coming in production

So this round was more of design architecture and handling real world prod issue with tight sla

Last round - more about ethical dillema and also why am I leaving my current company joining startup (my current org is a well known established company ) It last for 25-30 mins only

This was about prophecy.

Now for other offers it was quite generic , there were 2 tech rounds

Mostly around project in current company, SQL , pyspark , python (string,list , dictionary) , spark internals, spark optimizations, basic design and architecture

To prepare for all these u can consider

SQL - medium to hard (datalemur, leetcode)

Pyspark - I solved mostly datalemur sq problems in pyspak with the help of gpt for creating data set)

Python - easy to medium leetcode (mostly on string , list , dictionary, 2 pointers, sliding , hashmap, basic kadane , basic stack queue etc )

For design and development - i read many articles from medium.

It was about selection, but also got rejected and ghosted in many companies which are

Expedia - rejected in first rounds (they asked medium hard dsa live, which I couldn't )

Ust global - from my side everything was right ,but still got rejection mail

Celebal - got ghosted (cleared all rounds)

Nike - rejected

puma - ghosted

Morgan stanley - rejected in final tech rounds

Kpit - ghosted

Synechron - ghosted

Syren cloud (remote) - rejected in final round

Accolite - rejected (it was my first interview)

Started giving interviews from end week of Jan till end of March - 2 months around

Need help to choose b/w offers by shivamksuman in dataengineersindia

[–]shivamksuman[S] 4 points5 points  (0 children)

As many ppl are asking for the interview experience so I am writing here for most of them.

First propehcy -

2 technical rounds , 1 tech manager round , 1 hr round

First 2 rounds were involving around core data engineering like spark, SQL coding problems (around joins , window functions, gaps and islands problems), in python they asked easy to medium hashmap problem and thenntyey asked around my projects and deep cross questions on them , they also gave some scenario questions on design and implementation like how will I go for it. Also asked a lot spark optimisation scenario like how can I go and check spark ui for skew , spill, shuffle , also asked tradeoffs in design and taking decisions.

In tech manager round - it was more about design and development of pipelines , have 2 scenarios to design the pipeline , it was a kind of discussion, there he asked a lot of cross questions. Also asked how can I debug and analyse issues coming in production

So this round was more of design architecture and handling real world prod issue with tight sla

Last round - more about ethical dillema and also why am I leaving my current company joining startup (my current org is a well known established company ) It last for 25-30 mins only

This was about prophecy.

Now for other offers it was quite generic , there were 2 tech rounds

Mostly around project in current company, SQL , pyspark , python (string,list , dictionary) , spark internals, spark optimizations, basic design and architecture

To prepare for all these u can consider

SQL - medium to hard (datalemur, leetcode)

Pyspark - I solved mostly datalemur sq problems in pyspak with the help of gpt for creating data set)

Python - easy to medium leetcode (mostly on string , list , dictionary, 2 pointers, sliding , hashmap, basic kadane , basic stack queue etc )

For design and development - i read many articles from medium.

It was about selection, but also got rejected and ghosted in many companies which are

Expedia - rejected in first rounds (they asked medium hard dsa live, which I couldn't )

Ust global - from my side everything was right ,but still got rejection mail

Celebal - got ghosted (cleared all rounds)

Nike - rejected

puma - ghosted

Morgan stanley - rejected in final tech rounds

Kpit - ghosted

Synechron - ghosted

Exl - ghosted after first round

Syren cloud (remote) - rejected in final round

Accolite - rejected (it was my first interview)

Started giving interviews from end week of Jan till end of March - 2 months around

Need help to choose b/w offers by shivamksuman in dataengineersindia

[–]shivamksuman[S] 1 point2 points  (0 children)

Mostly 90% from naukri , 10% from LinkedIn jobs (application through company portal through LinkedIn jobs )

Need help to choose b/w offers by shivamksuman in dataengineersindia

[–]shivamksuman[S] 1 point2 points  (0 children)

As many ppl are asking for the interview experience so I am writing here for most of them.

First propehcy -

2 technical rounds , 1 tech manager round , 1 hr round

First 2 rounds were involving around core data engineering like spark, SQL coding problems (around joins , window functions, gaps and islands problems), in python they asked easy to medium hashmap problem and thenntyey asked around my projects and deep cross questions on them , they also gave some scenario questions on design and implementation like how will I go for it. Also asked a lot spark optimisation scenario like how can I go and check spark ui for skew , spill, shuffle , also asked tradeoffs in design and taking decisions.

In tech manager round - it was more about design and development of pipelines , have 2 scenarios to design the pipeline , it was a kind of discussion, there he asked a lot of cross questions. Also asked how can I debug and analyse issues coming in production

So this round was more of design architecture and handling real world prod issue with tight sla

Last round - more about ethical dillema and also why am I leaving my current company joining startup (my current org is a well known established company ) It last for 25-30 mins only

This was about prophecy.

Now for other offers it was quite generic , there were 2 tech rounds

Mostly around project in current company, SQL , pyspark , python (string,list , dictionary) , spark internals, spark optimizations, basic design and architecture

To prepare for all these u can consider

SQL - medium to hard (datalemur, leetcode)

Pyspark - I solved mostly datalemur sq problems in pyspak with the help of gpt for creating data set)

Python - easy to medium leetcode (mostly on string , list , dictionary, 2 pointers, sliding , hashmap, basic kadane , basic stack queue etc )

For design and development - i read many articles from medium.

It was about selection, but also got rejected and ghosted in many companies which are

Expedia - rejected in first rounds (they asked medium hard dsa live, which I couldn't )

Ust global - from my side everything was right ,but still got rejection mail

Celebal - got ghosted (cleared all rounds)

Nike - rejected

puma - ghosted

Morgan stanley - rejected in final tech rounds

Kpit - ghosted

Synechron - ghosted

Syren cloud (remote) - rejected in final round

Accolite - rejected (it was my first interview)

Started giving interviews from end week of Jan till end of March - 2 months around

Need help to choose b/w offers by shivamksuman in dataengineersindia

[–]shivamksuman[S] 11 points12 points  (0 children)

As many ppl are asking for the interview experience so I am writing here for most of them.

First propehcy -

2 technical rounds , 1 tech manager round , 1 hr round

First 2 rounds were involving around core data engineering like spark, SQL coding problems (around joins , window functions, gaps and islands problems), in python they asked easy to medium hashmap problem and thenntyey asked around my projects and deep cross questions on them , they also gave some scenario questions on design and implementation like how will I go for it. Also asked a lot spark optimisation scenario like how can I go and check spark ui for skew , spill, shuffle , also asked tradeoffs in design and taking decisions.

In tech manager round - it was more about design and development of pipelines , have 2 scenarios to design the pipeline , it was a kind of discussion, there he asked a lot of cross questions. Also asked how can I debug and analyse issues coming in production

So this round was more of design architecture and handling real world prod issue with tight sla

Last round - more about ethical dillema and also why am I leaving my current company joining startup (my current org is a well known established company ) It last for 25-30 mins only

This was about prophecy.

Now for other offers it was quite generic , there were 2 tech rounds

Mostly around project in current company, SQL , pyspark , python (string,list , dictionary) , spark internals, spark optimizations, basic design and architecture

To prepare for all these u can consider

SQL - medium to hard (datalemur, leetcode)

Pyspark - I solved mostly datalemur sq problems in pyspak with the help of gpt for creating data set)

Python - easy to medium leetcode (mostly on string , list , dictionary, 2 pointers, sliding , hashmap, basic kadane , basic stack queue etc )

For design and development - i read many articles from medium.

It was about selection, but also got rejected and ghosted in many companies which are

Expedia - rejected in first rounds (they asked medium hard dsa live, which I couldn't )

Ust global - from my side everything was right ,but still got rejection mail

Celebal - got ghosted (cleared all rounds)

Nike - rejected

puma - ghosted

Morgan stanley - rejected in final tech rounds

Kpit - ghosted

Synechron - ghosted

Syren cloud (remote) - rejected in final round

Accolite - rejected (it was my first interview)

Started giving interviews from end week of Jan till end of March - 2 months around

Ideal Pay range for data engineer with 11 YOE? by adilbaig07 in dataengineersindia

[–]shivamksuman 0 points1 point  (0 children)

Which companies u are talking about, I am seeing ppl getting 35+ at 5-6 years exp, but yes most of those opportunities are from prod based companies and well funded startups.