I Data engineer sono professionisti informatici richiesti pressoché in tutti i settori. Si occupano di monitorare i trend dei dati per pianificare le azioni più adeguate che un'azienda deve intraprendere. Uno degli aspetti più critici del lavoro di un Data engineer è l'elaborazione dei dati grezzi e la loro trasformazione in dati utilizzabili per creare pipeline e sistemi di dati.
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 ...)
queries, R,Python, data warehouses
Viewing 141 - 150 interview questions