I worked in production, where I was tagged in a data engineer job role. To be frank I am not good in python,SQL and I have not much hands on in the cloud. I have knowledge but not hands on.
Now while switching I am applying for data engineer roles only. Please suggest where I can get hands on experience or some courses that will help me to get placed.

like
Posting as :
works at
You are currently posting as works at

I have prepared this road map with my own suggestion and took help of chatgpt to frame it better.

1. Foundations

SQL: Advanced joins, window functions, CTEs, query optimization.

Python: pandas, data manipulation, scripting.
======
2. Data Engineering Core

Data Warehousing: Concepts like partitioning, clustering, and sharding.

ETL / ELT:

Orchestration: Airflow.

Transformation: PySpark.
=====
3. Cloud & Infrastructure

Most Data Engineering work is cloud-native. Focus on one cloud provider depending on your target companies:

GCP: BigQuery, Dataflow, Pub/Sub, Composer, Dataproc, GCS.

AWS: S3, Redshift, Glue, EMR, Kinesis, Lambda.

Azure: Data Factory, Synapse, Databricks.
====
Project Preparation

Once you’ve covered the above topics, frame your current project (or build a simple new one) as a data engineering project for interviews.

Use ChatGPT to refine the project explanation and prepare for likely follow-up questions.

Keep your project simple and clear, as complex ones often invite tricky, deep-dive questions.
=====
Interview Preparation

Project Discussion: Be ready for detailed questions on architecture, tools, and trade-offs.

SQL & Python: Expect advanced SQL (joins, window functions, CTEs) and at least 1–2 coding questions in SQL/Python.

Question Bank: Collect commonly asked Data Engineering interview questions from LinkedIn and other sources to practice.
=====
Notice Period Strategy

If you have a 90-day notice period, set your notice period as 30 days on Naukri and start applying.

Some companies do hire candidates with 90-day notice, but they are more likely to contact you early if you show 30 days.

Give as many interviews as possible — the more you interview, the better your chances of landing an offer.

like

Thank you so much 😊 you really helped me alot with this message

like

Which cloud you want handson

For gcp, use your company email for hands on lab exercises on their partner skill website

U need to be good in sql for interviews at least. Without strong sql, u can't go for pyspark

Related Posts

Hi Fishes. I am currently holding offer from BP and Citi , both offering the same package for penetration tester. Any idea which is an overall better option to choose?

like

Anyone have any resources I can read or any tips on valuing IP? Specifically like a cloud-based data library that is constantly growing with new data points while keeping the historical data points. Kind of new territory for me...

like

Anyone who is an SDET? How much coding do you do?

like
like

I recently graduated college last year and am trying to pursue certifications to help build up my resume. I currently hold an AWS SAA certification and Azure AZ -900. I am looking to try and obtain the CISSP next. Is there something else I should start with before diving into CISSP or should I direct my studying and focus in that direction?

like

What are your favorite resources for supporting students with delays and disabilities that impact literacy skills?

like

Hi ,

Please help me in Unlocking Direct Message by Liking this post.

Thanks In Advance !

like

Hey everyone - I'm finally having a little breathing room in my work schedule and looking to get out and explore the city a little bit more. What are your top "must see's" or must do's? Really open to anything interesting within reason lol

like

Has anyone used or is currently using My Perspectives ELA curriculum from Savvas Learning Company? Our district is considering switching from iReady and I am looking for honest feedback. Thanks!

like

I got an offer for deloitte Pune doj 20 june ?? Anyone reporting there on 20th ? And are we having dlaunch event in Pune office idk what should I choose virtual onboarding or physical at Pune location? HR is also irresponsible she don’t even know bs bolri h office jana pdega and I’m hearing there is no space and she’s telling me they’re not gonna deliver laptop to home? Please rply

like

Freelancers, do you actually benefit from having an S Corp? Assume someone is earning about $100k in 1099s and $150k in W9s. Everyone says “oh get an s corp for taxes” but does it ACTUALLY help lower your taxes? (Also, can you get ALL 1099s if you bill through your s corp and does THAT help?) Everyone who insists on it says things like “yeah I’m not sure how, but it helps” or “this is my first year doing it.”

like

8.7 yr yoe, how can I negotiate with hcl ?@hcl

like

Hi Everyone, Could someone please suggest the best institute for DevOps Online Training course?

M here. I don’t know what it is genuinely that I’m doing wrong. I get barely matches on dating app; I don’t have the shiny muscles to show off on the apps, a 7 or 8 looks wise, great personality, and can easily to talk to anyone. I don’t know how to take the conversation out of the friendly zone to make a girl realize that I want to be sexual with her. Especially F 🐠s, would love to hear your POV on this as I’m sure you’ve encountered guys like me before. M 🐠s, let me hear your take too.

like

Does anyone have a recommendation for a primary care doctor in the western suburbs or Denver area?
I’m a male in my late 20s and am generally pretty healthy but responsiveness to mental health concerns is a big plus!

likehelpful

Is Nagarro Lucknow office started ?

Press like if you’re a fan of obscure varietals

Post Photo
like

Bucks County, PA. Depending on size of book can purchase immediately or being a longer term succession plan.

18 year vet looking to acquire businesses in Denver area. Looking to exit? Let’s talk

like

I’m currently a wire house FA who received assets from a retiree. I likely have 4 years before I’d be able to move my book of business, but I definitely want to move to an Indy channel. When should I start these discussions with other firms/business owners and are there benefits to merging with an existing practice at that time?

like

Additional Posts in Data engineers India

Hi Fishes, Welcome to the data engineering Hive. Since we are growing it will be great if we can start with a brief introduction with this this thread. Mine is as follows

Company :- Harman international
YOE :- 6
tech :- AWS, Spark, Hadoop, airflow , Kafka , python , informatica, oracle, plsql ,sql

likesmart

Has anyone given interview in Daimler for data engineer? Can you please help what kind of questions they ask in the first round?

like

Hi fishes, I have 2 offers-
Thermo Fisher for Data Engineer in AWS and Python and Ameriprise as Lead Developer for Informatica Powercenter. Ameriprise is offering 50k more in my monthly salary than Thermo Fisher. My preference is to join in where I can grow and get a good learning for future career growth. Also, work life balance should be good in the organization.
Please help me with making a clear decision. And i have 8+ YOE.

like

Can anyone tell me about EY India ( Not EY GDS) ? Pros and cons

like
like

We are hiring for Azure Data engineers. Dm me if interested in accenture.
Exp - 2.5 years or greater

like
like

After 2 rounds of interview (1 hour each) , Deloitte usi hr is telling me that due to organisational restructuring the offers are on hold. Got a salary discussion call last Thrusday (no pre hire survey) . Last working day in a week. Any suggestions? Cloud Data engineer CBO unit Deloitte Deloitte USI

like

Please suggest

YOE 2.4
Azure data engineer

Fractal - 14.5
@Rich Products Corporation - 18.5

like

Hi Fishes,
I have 1.8 yrs Exp and working in the Big data domain and have a few offers please help to decide on the comparatively better option based on salary, Work-life Balance, security, and Carrer Growth.

EY GDS: CTC 12 ( 11.20 Fixed )
Publicis Sapient: 16 CTC ( 14.5 LPA FIXED )
Neudesic (IBM) 16 CTC ( 14.5 FIXED + WFH Remote Complete )
PubMatic: 22.70 CTC + 2 lakhs Joining Bonus ( 16 fixed LPA + Other benifits, stocks, etc )

It will be very helpful if you can suggest with some reason.

like
like

I am working as data engineer at Accenture with 2 YOE with ctc of 11LPA. After clearing all the technical rounds at Impetus technologies, tomorrow I have my HR discussion. She told she can't give more than 16 LPA. What should i do? How much should i ask? I am expecting somewhere around 19-20 LPA. Can anyone pls help. Accenture Impetus technologies inc

like

Hi Guys, Can you please tell me which tech stack is better :
Gartner : Azure Synapse analytics and Azure Data Factory
Dunnhumby - PySpark and Airflow

Salary is same in both of them.

like

Hi Fishes and Sharks,

Anyone looking out for referral in Maersk for Data Engineer, Engineering Manager roles, Please DM me. Lots of opportunities with good WLB and competitive package.

Post Photo
like

Hi fishes,

Need your opinion.

Working for
Wipro as azure data engineer in Spark, Hive, Azure ADF, ADB etc.

Current CTC: 17.5 LPA

Total YOE: 11 years

Relevant exp in big data: 6 yrs

Relevant exp in Azure: 2+ yrs

Got offer from Atos of 26.4 LPA. Is this a good offer? or Shall I search other job at 30+ LPA?

Getting calls from some product companies like JPMorgan Chase Chubb. How much can I expect from these product companies?

Wipro Infosys Tata Consultancy IBM Capgemini Cognizant Accenture India

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal