How do you approach designing a scalable data warehouse architecture?
Data Warehouse Engineer Interview Questions
93 data warehouse engineer interview questions shared by candidates
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"] ]
There were questions on: Snowflake, dbt, PostgreSql, Python, data warehousing, data modeling, OLAP vs OLTP, SQL, data quality, pipeline orchestration, and more. There was an emphasis placed on knowing Python, as noted above.
design a platform for the company
what are the most efficient ways to process some data from production database without making read traffic
Technical questions based on sql data manipulation, data retrieval, and data visualization.
Sql, data warehousing fundamentals, linux
Data engineering concepts, Open source technologies.
Viewing 31 - 40 interview questions