IP validator SQL involving ranking function
Data Warehouse Engineer Interview Questions
92 data warehouse engineer interview questions shared by candidates
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?
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.
Python- Rest Api Calls to store large amount of data
Viewing 31 - 40 interview questions