sql and python are practically the same as the ones you get as practice questions in the meta career site.
Data Engineering Interview Questions
20,954 data engineering interview questions shared by candidates
Python -Count distinct words in a sentence -Count the number of times a word appear in a sentence using a Hash Map -Return tuples of a list, matching each item to another item -Count the number of times a substring appear in a string SQL -Return min and max age of male/female who bought a product -Count the number of stores in a state with grand total ? 25000 sq feet
gave few columns, asked to design a model and based on the model 3/4 sql questions were asked
2) create daily revenue report between given start_date and end_date output schema: (order_date, number_of_customers, number_of_orders, daily_total_order_amount, mtd_order_amount) mtd_order_amount - total order_amt from the beginning of the month till order_date
all question were just basic but sometimes the basic questions can be tricky like why we use main function in java ? why it is public? run program without main?
List the strings that are anagrams from a set of strings?
A lot of SQL questions. General knowledge about how you would handle large amounts of data.
Calculating percentage of sales percentage of non dat and regular products Calculating percentage of sales that matched the start date and end date of the promotion Fill the none values in a list with the previous non none value
try to get a pattern out of string or json. ask you to translate numbers from 1 to 100 to names of numbers ( for example 34 translated to thirty-four). you need to come with a solution within 10 seconds, I am able to get it done within 2 minutes. That's not fast enough.
Parlez nous de vos motivations
Viewing 91 - 100 interview questions