Does database view occupy the disk space.
Data Engineer Interview Questions
20,280 data engineer interview questions shared by candidates
SQL - I was given 4 tables Sales, Product, Promotion and something else (Never had to use it). 1. Which product had the highest sales with promotions and sales ( basically a where clause on 2 flags) 2. What % of sales happened on the first and last day of promotion. I don't remember the rest.. I'd say your ability to translate regular english statements into SQL is tested very well
basic sql and python problem
Null +1 = ? Union and Union Alll which one is faster
"What data format should you use for a large amount of data?"
Based on my experience in different projects and analytical functions in SQL
You have this table - orders (order_id, customer_id, order_datetime, order_amt): 1)select top 10 paying customers for given month
Tell me about your self? What is Data Warehousing?
The interview was highly focused SQL questions such as finding the third high, finding the newest one.
Mostly technical / coding questions with limited time to answer, talk about past projects (with techncial depth), almost no questions with respect to data science (statistics, ml, math, modeling ...)
Viewing 141 - 150 interview questions
See Interview Questions for Similar Jobs
Analytics EngineerPerl DeveloperModeling EngineerDatabase AdministratorDatastage DeveloperData MinerDatawarehouse DeveloperData Warehouse DeveloperData Warehouse ManagerBusiness Objects DeveloperOracle Data IntegratorMachine Learning ScientistData AnalystData Warehouse ArchitectData ScientistBusiness Intelligence SpecialistEtl TesterData ModelerEtl Developer