Tell me about a time where you had to adapt to an unexpected change
Sr Data Engineer Interview Questions
2,563 sr data engineer interview questions shared by candidates
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.
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.
Write a decorator that wraps another function
Writing python program & SQL queries
Viewing 1511 - 1520 interview questions
See Interview Questions for Similar Jobs
Data EngineeringSenior Data EngineerBig Data EngineerSenior Big Data EngineerData EngineerSenior Data ConsultantLead Data EngineerData ScientistsData Scientist IiiPrincipal Data EngineerData Mining EngineerBigdata EngineerSr Data AnalystEtl Data Stage DeveloperSr Database EngineerDatabase Administrator IiSenior Data Stage DeveloperEtl Informatica Developer