Given a table of users and whom they sent friend requests to, what is the average number of friend requests sent in the last week?
Data Engineer Interview Questions
21,094 data engineer interview questions shared by candidates
sql: already present in glassdoor. 1)ratio of is_fat and is_someother among total products 2)top 5 single channel companies that spent max amount on promotion. take into account of the ones that have only single entry company , channel; 1 food, water 2 food 3) percentage of sales on first day and last day python: occurrences of a letter in a string, replace none with previous value in a list, from a dictionary get the keys corresponding to nth highest value.
simple sql queries, but hard schema
Design a dashboard to highlight a certain aspect of the user behaviour
Why do you want to return to Stori?
They asked me to explain how I would design and optimize a cloud-based data pipeline on GCP, including data ingestion, transformation, storage, and performance considerations.
The questions were very easy related to my resume. How good are you with python elasticsearch and Big Data
SQL questions: 1. First question was based on the ranking and join to get the solution 2. Second follow up question used the same database and tables. The question asked for a rolling average based on last 3 days. 3. Third question was again based on a rolling sum and then count query based on that rolling sum. All of the SQLs required CTE statements Lastly the Python programming question was a basic for loop to search the position of a target number. Interviewer asked for a different approach of solving it.
Multiple SQL Questions
Describe DHCP to non-tech people
Viewing 1651 - 1660 interview questions