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,979 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]
Level of severity is in line with what folks have mentioned above. But they have new question set. Funny that they kept asking the same questions for more than a year before changing them out.
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 - Q1. Find the IDs of the top 5 customers, ordered by average payment per book made by the people they invited.
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
Find max min avg of the order by date, customer, product, state. Coding was easy pretty much what people already posted here.
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.
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