The gave me driver data, passenger data and booking data. You will be asked to run some aggregation on this and publish the results.
Data Engineer Interview Questions
20,985 data engineer interview questions shared by candidates
1. Imagine a table keeping track of all the rides a driver undertakes in a given day. How do you query that table to find out the time when he did not have any rides. So the table may have a record when he picks up his first ride and then he picks another and then drops both of them. After a while he picks up a few more which again is recorded in the table. So with all that how do you find the data when he does not have any rides
# Q2: Same as Q1, but now assume there can be duplicates. The output should not have duplicates # Ex: # l1 = [1,2,3,4,5,5,5] # l2 = [1,5,7,11,100] # result = [1,5]
What percent of all products in the grocery chain's catalog are both low fat and recyclable?
Write a query that returns product_family, units_sold, percentage of promoted.
The rest 30minutes was for algorithmic programming in language of your choice. I completed 3.5 questions in 30minutes.
SQL Coding: 5 questions 4 tables were given and questions were mostly on joins, aggregate functions, sub queries. Python Coding: I guess there were total 5 questions but could reach only till second question. Count the number of words in a sentence. Count the frequency of words from the list and store the results in a hash map.
sql and python question 5+5
Basic data structure and sql statement at a very high level short answers
Python (1) Count "char" in the string. (2) Replace "None" in an array. Codes are simple but passing edge cases are difficult. SQL several % calculation questions
Viewing 191 - 200 interview questions
See Interview Questions for Similar Jobs
Analytics EngineerModeling EngineerPerl DeveloperDatabase AdministratorEtl DeveloperData Warehouse ArchitectData ScientistMachine Learning ScientistBusiness Objects DeveloperDatawarehouse DeveloperData Warehouse ManagerData MinerData Warehouse DeveloperData AnalystBusiness Intelligence SpecialistOracle Data IntegratorData ModelerDatastage DeveloperEtl Tester