Tell me the time when you had worked with SQL
Senior Data Engineer Interview Questions
2,613 senior data engineer interview questions shared by candidates
Tell me about a time where you had to adapt to an unexpected change
I had 4 rounds of interview.
2 SQL question 1. grouping and having clause. 2. Lag questions (windows function) python - very single (word count in array) and remove duplicates
- Do some basic DB queries with Python. - Study an example AWS cloud architecture, have it explained by a current employee, and talk about how it could be improved. - Normal "Tell me about a time when..." background questions.
-Design a star schema model -Basic and some advanced questions related to data warehouse
How do you deal with customers and the requirements and the deadlines?
It was mostly Technical questions and case interview questions. they emphasize a lot of your analytical and problem solving skills if you are applying for data engineer role
System design a takeout system so users can retrieve their data from Yelp
1. Write a QUERY to return the daily number of leads submitted for each lead type in a month . In case 0 leads, then query should return 0. Output: date,lead_type,number_leads Table leads(delivered_datetime_utc TIMESTAMP, lead_id INT, liting_id INT, lead_type VARCHAR, billing_id INT) Table dates(event_date DATE) 2. Write a Query to return the latest event for each user in a given day Table: user_events(user_id, event_timestamp, event_name) 3. Data Modeling on Listings data and three questions based on the model that you draw, such as how many for_sale listings are there in a given month, what is the median home price in a given state, and if you are price conscious, is it better to rent in summer or winter.
Viewing 1541 - 1550 interview questions