What is rownum? Why do we use columnar database? Which cases columnar database is not good?
Data Warehouse Engineer Interview Questions
93 data warehouse engineer interview questions shared by candidates
AWS objective type questions
SQL- usage of aggregate functions, Rank, duplicate removals etc
Questions in 1st round - live coding sql - joins query, analytic function query, duplicate rows from table... etc live coding python - Compare words for 2 lists . Questions in 2nd round - ETL/data warehousing concepts, dimension modelling, project..etc Questions in 3rd round - basic discussion over project and work timings and cultural fit
What are the different joins in SQL and explain them
Tell me about experince
1 easy sql query using ranking
On the board write the code for finding the cube root of a number.
IP validator SQL involving ranking function
The behavioral, SQL, ETL, and coding questions asked during the phone interview were pretty basic. Onsite questions 1. Implement a trie (NOT tree) data structure with insert, search, and startsWith methods. 2. Given an array of strings, group anagrams together. For example, given: ["eat", "tea", "tan", "ate", "nat", "bat"], Return: [ ["ate", "eat","tea"], ["nat","tan"], ["bat"] ]
Viewing 21 - 30 interview questions