Null +1 = ? Union and Union Alll which one is faster
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,120 data engineer interview questions shared by candidates
Already covered in other reviews
SQL - I was given 4 tables Sales, Product, Promotion and something else (Never had to use it). 1. Which product had the highest sales with promotions and sales ( basically a where clause on 2 flags) 2. What % of sales happened on the first and last day of promotion. I don't remember the rest.. I'd say your ability to translate regular english statements into SQL is tested very well
basic sql and python problem
You have this table - orders (order_id, customer_id, order_datetime, order_amt): 1)select top 10 paying customers for given month
Tell me about your self? What is Data Warehousing?
The interview was highly focused SQL questions such as finding the third high, finding the newest one.
Based on my experience in different projects and analytical functions in SQL
queries, R,Python, data warehouses
Mostly technical / coding questions with limited time to answer, talk about past projects (with techncial depth), almost no questions with respect to data science (statistics, ml, math, modeling ...)
Viewing 141 - 150 interview questions