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.
Read data from api url . And pass dates as parameters and capture data based on monthly
What is the difference between ETL and ELT?
Given a code sample and some output with errors in it find where the errors are in the code and how to fix them.
Questions about OOP
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
How do you deal with customers and the requirements and the deadlines?
Why did you leave your last employer? What kind of team are you looking for?
Difference between DDL and DML
Viewing 1501 - 1510 interview questions