I don't quite remember. It was a while ago. They had good relevant questions.
Data Warehouse Engineer Interview Questions
163 data warehouse engineer interview questions shared by candidates
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
How do you approach designing a scalable data warehouse architecture?
They use canned interview questions about experience, and skill familiarity.
Draw architecture of previous data warehouse project on whiteboard
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.
Viewing 61 - 70 interview questions