Data engineers are IT professionals who are needed in almost every industry. Data engineers monitor data trends to determine best next steps for companies. A critical part of a data engineer job is to process raw data into usable data by creating data pipelines and building data systems.
1) Imagine you are data modeling Netflix and create the entities and relationships involved using a modeling tool. 2) follow a link to a sql tool which shows 4 tables. Run some provided sql to populate the tables, Create the sql to aggregate the data and provide a result set showing the top row.
Imagine you receive an alert indicating that a group of servers in one pod has gone offline. How would you approach troubleshooting and resolving this issue?
Query a many to many relationship while not violating the grain of a fact table.
How would you design an ETL pipeline to handle real-time data ingestion from multiple sources (e.g., web servers, mobile apps) and ensure data quality and consistency before loading it into a data warehouse?
Unfortunately unable to share because of NDA
Find the Hamming distance of these two lists
SQL Question asking for a percentage of the selected data.
Same as mentioned in other responses here.
What are the top five (ranked in decreasing order) single-channel media types that correspond to the most money the grocery chain had spent on its promotional campaigns? media_type can contain mutliple values seperated by a comma, so single channel is when media_type only has one value.
python:1. find 's' in mississippi 2. uncommon words 3. replace none with next element in the list. SQL: 2 questions on case, 1 on order-limit/rank/top(whatever you want to use),percentage/ratio calculations/joins
Viewing 521 - 530 interview questions