2 SQL question 1. grouping and having clause. 2. Lag questions (windows function) python - very single (word count in array) and remove duplicates
Senior Data Engineer Interview Questions
2,447 senior data engineer interview questions shared by candidates
- 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
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.
Writing python program & SQL queries
- SQL exercises - Pyspark exercises - A conversation with the manager about your data engineering experience
data engineering and project experiences
Na entrevista técnica houve perguntas como: Seu conhecimento com infra-estrutura de Cloud, Gonvernança de dados e Segurança da informação.
Difference between DDL and DML
Viewing 1451 - 1460 interview questions