Hello all, I'm a GCP data engineer with 5.4 yoe. I've attended quite a few interviews and haven't been successful. The interview questions are not standard these days and no matter how much I prepare I get asked really different questions during the interviews. I don't know the exact roadmap I should be looking at to ace these interviews. If anyone has any tips or can share some insights on frequently asked questions as a DE it would help so much. Thank you!

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

I am an Azure DE, here are the things that I observed during my interviews
1. SQL & PySpark - Practice questions on sql joins, window functions, and know how to write same query in Pyspark.
2. Scenario based questions:
My data pipeline has failed, what necessary actions you take
How do you optimize the performance
Build a sample data pipeline for the usecase, and give justification for each and every step.
3. Data warehousing concepts -
Schemas in dwh, scd and its types, incremental load and full load
4. Architectural and design questions - Spark Architecture, Medallion Architecture
5. Have a strong grip on the data engineer project you're doing (can be the one which you're working or your personal one), explain in and out and know the specification of each tool.

Keep trying, all the best!! You're almost there. Don't lose hope

like

Checkout youtube lot of resources

How about python questions?

Related Posts

Is anyone from Kroll or Security Brigade here?

Is it fairly smooth to transition to CDI without inpatient coding experience? I have my RHIA but have been apprehensive to get into CDI. I feel like I have transferable skills from my background in profee coding, coding educator and having payor side experience. Is it necessary to get IP coding experience or just jump ship for the challenge?

like

Siemens technology is product based company?

like

Question for F🐠. Someone asks you to keep them company via text, social media, maybe a phone call sometime etc. You'll be payed to do this. Would you do it? And what are your terms?

like

If you have been given an official review and were told you’re on track to become partner, how did that play out for you? Really interested in individual stories.

like

Please say yes! 🥰😂

Post Photo
likefunny

Yoe 9
Relevant 4 years
Location : almost remote always (as i requested)
Package : 17lpa +2v + 1joining bonus

Feeling like lowballed by hr.
Though i had counter offer of 17.3 (15.7 fixed)

Queries:
1. Will exl pay the variable pay fully ?
2. Hr mentioned for client meetings i may need to come to Noida on my own expenses ( from chennai) but may be once in a year.
Is that true ?

like

I joined on Nov 2020 in EY GDS as Senior 1,so when I will be getting progression for senior 2?

like

If you living currently in a home and looking to buy another home but plan to put only 10% on the new home, can I pay the remaining 10% after selling my existing home in 1-2 months .. and get the PMI

like

Hi all, I'm waiting for the offer / Letter of Intent from Societe Generale. Submitted the compensation documents a week back, would they reject the candidature if the expected CTC is out of their budget? Or atleast let me know..Societe Generale

If money was not a criteria, what job would you do?

like

Science & Democracy... Thoughts?

like

Hola mi gente ! 🇲🇽

likehelpful

After a fire, how long does it usually take for a building to be rebuilt or torn down completely ?

like

Leo loses Allstate to Droga. I know this was a long time coming, but it’s yet another big loss for Chicago.

like

Hi guys, can someone please help me understand what does "Senior Consultant in HR Band 4" mean?

like

Hi Fishes !

Need referral for EY job requisition : 922901. Would be greatful if someone can please refer.

Thanks in advance !

like

Any Recruiter here?
Need help

like

The thing I struggle with the most on a project is being able to quickly understand the business process of the clients across different industries. Any tips or resources I can use to improve that?

like

Why did OBTC tank this week while Bitcoin rode to $56k?

Post Photo
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

Hey Fishes,

I'm in a biggest confusion here. And its pushing me to depression. Please help me if possible. I got 2 offers and both are good reputed product based companies. And offered the same role.

Fractal Infosys Tata Consultancy Wipro Accenture Microsoft IBM Cognizant

Post Photo
like
like

How much package i can ask from kpmg india as Consultant (Digital lighthouse, data engineer)

like
like
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

Hey Guys,Can anyone who is a Data Engineer and working with Big Tech Companies share some light on how you guys are preparing for interviews?How are you learning so fast/so much?Can you please share some plan or guide me on what resources you are following?There are too many things. And in my current organization I am not able to learn those.I want to learn fast and more.I see profiles on LinkedIn that are filled with big data techstack.Please guide. Adobe Amazon Walmart Expedia, Inc. American E

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

Anyone here who have given data engineer interview at rolls royce?

like

McKinsey & Company Hi guys,

Please help me with the referral.

Senior/Lead data Engineer

Exp -- 8.5 years
Notice period -- 30 days
Tech stack -- Big data,Hadoop, Spark, Kafka, Azure,Python,Scala,Sql

Please ping your email id .I will share the Cisco" class="linkified" target="_blank" rel="nofollow" >resume.Cisco Target Bosch Intuit Amazon McKinsey & Company Indeed Flipkart JPMorgan Chase Morgan Stanley VMware Intel Corporation Hewlett Packard Enterprise Paypal Salesforce

Hi need a referral at Bank of America for data engineer profile

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 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

Hello All, In the next couple of months i am targeting companies like Apple , American express, Salesforce, Microsoft etc. Can anyone please share the required skill set and preparation strategy for these companies? YoE - 4 years Current skill set - Advanced SQL , Pyspark,Azure services, Hadoop ecosystem , shell scripting, Power BI

I am not very good at DSA.

Apple Microsoft Salesforce Amazon

like

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

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

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