Database and Coding Questions
Data Engineer Interview Questions
Data Engineer Interview Questions
Data engineers are IT professionals who are needed in almost every industry. Data engineers monitor data trends to determine best next steps for companies. A critical part of a data engineer job is to process raw data into usable data by creating data pipelines and building data systems.
Top Data Engineer Interview Questions & How To Answer
Question #1: Can you describe in detail your level of expertise with programming languages?
Question #2: Explain data engineering in your own words.
Question #3: Can you describe your experience working with Apache Hadoop and cloud data management environments?
20,285 data engineer interview questions shared by candidates
Can you read in a dataset into Spark, create a new calculated field (cube figure) with a value and round this? Then write the result to disk.
Question on sql and datawarehouse
Software Design and Architecture Question: How I would design a popular application at scale ?
Build and scale twitter. Specifically, create required tables, identify referential integrity constraints, create a query to find latest tweets for a person from all the persons she is following latest first, how will you manage paging (infinite scroll); How will you scale it?
Situations questions, Database schemas, NoSQL database questions.
To code a particular program
Where do you see yourself, what makes you think you should join our team
What is the fundamental of building a data pipeline. What is the most challenge project that you have ever worked on. If you have conflicts with your manager, what would u do
1) Initial one round full of leadership related questions. Didn't expect a one hour full of leadership questions. This round was unexpected as recruiter didn't tell me that it's a leadership round. I was told this is a hiring manager screen where they wanted to check the fit. There were 2 hiring managers (of the 2 teams who were looking for a lead). 2) Initial coding screening - 2 Python coding questions - same as the ones that others mentioned in the Glassdoor. 1- data modeling question (social media site) and set of SQL questions against the data model. 3) Data pipeline system design interview. Asked high-level and low-level details of high data volume real-time pipeline. 4) Behavioral questions with cross-team based questions. 5) Technical round with ETL related question with SQL coding applied. One Python coding to build a grouping based ETL using Python. The output can be easily provided using SQL script. The challenge was to build the same using Python. Should be manageable somebody who's very hands-on. Unfortunately, I wasn't. Though I could write the pseudocode and think through the solution, I couldn't write the actual code within the time. 6) Design the data model for a ridesharing app and answer a set of questions using SQL. I underestimated the complexity of a couple of SQL questions in this round.
Viewing 2581 - 2590 interview questions