I don't quite remember. It was a while ago. They had good relevant questions.
Data Warehouse Interview Questions
379 data warehouse 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"] ]
tell me about yourself
What do you know about FAST
Explain the difference between passing a variable as a value vs as a reference. What are the pros and cons of both?
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.
Basic Unix commands
Tell us an example where you took initiative in a group project.
design a platform for the company
Viewing 131 - 140 interview questions
See Interview Questions for Similar Jobs
Datawarehouse DeveloperBusiness Intelligence ConsultantData EngineerAb Initio DeveloperData InternBusiness Intelligence DirectorData ModelerDatastage DeveloperEtl TesterAtg DeveloperData AnalystOracle Data IntegratorMachine Learning ScientistData ScientistData MinerBusiness Objects DeveloperDatabase AdministratorMining EngineerBusiness Intelligence Specialist