System design a takeout system so users can retrieve their data from Yelp
Sr Data Engineer Interview Questions
2,567 sr data engineer interview questions shared by candidates
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
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).
- SQL exercises - Pyspark exercises - A conversation with the manager about your data engineering experience
data engineering and project experiences
Windows OS internals related Communication between components, Existing projects
Difference between DDL and DML
Why did you leave your last employer? What kind of team are you looking for?
Viewing 1521 - 1530 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