How do you automate your day to day tasks as part of Data Platform team?
Sr Data Engineer Interview Questions
2,569 sr data engineer interview questions shared by candidates
2 SQL question 1. grouping and having clause. 2. Lag questions (windows function) python - very single (word count in array) and remove duplicates
Tell me about your self?
Data system design question dealing with batch and stream processing.
Resume walk through and previous insurance domain experience discussion.
data engineering and project experiences
- SQL exercises - Pyspark exercises - A conversation with the manager about your data engineering experience
Writing python program & SQL queries
In the technical round, they asked about the project mentioned in my resume. Approach obstacles, then ask about the Palantir workshop application and SQL (window & inner join) questions. questions were more focused towards credit fraud capturing (logics).
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 1491 - 1500 interview questions