SQL questions on promotions, sales schema. 1. find top 5 sales products having promotions 3. what %age of sales happened on first and last day of the promotion Python:- 1. [1,None,1,2,None} --> [1,1,1,2,2] Ensure you take care of case input[None] which means None object. 2. find s in missisipi. 3. Complete a function that returns a list containing all the mismatched words (case sensitive) between two given input strings # For example: # - string 1 : "Firstly this is the first string" # - string 2 : "Next is the second string" # # - output : ['Firstly', 'this', 'first', 'Next', 'second']
Data Engineer Interview Questions
20,150 data engineer interview questions shared by candidates
How many unique world are in the provided string?
delete duplicates in a list
1 Programming, I chosen python. How to get top ten data (from last column) from comma separated flat file
SQL question: 1 table with player_id, log in date, and 2 other fields and was asked to calculate first day retention rate. First day retention rate is defined as the player who log in the 2nd straight day, after the first ever time they log into game.
Product Sense, Data Modeling, SQL, Python, Ownership
Complete a function that returns a list containing mismatched words in two strings. The return list can be in any order. I used set to solve this question, but was also asked to verbally explain how I would solve it without using sets.
Question 2: 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?
Longest palindromes in a string SQL quesiton
Data Modeling: Data Modeling Question for a hypothetical scenario where you have scope to work on your Data Warehousing knowledge. How will you design ETL pipelines for the model? SQL question to display data from your model. Python/SQL questions.
Viewing 41 - 50 interview questions