Why you are using your pipeline as it is why you are not a decision maker in your organization?
Data Engineer Interview Questions
Data Engineer Interview Questions
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.
Domande tipiche dei colloqui per Data engineer e come rispondere
Domanda 1: Puoi descrivere in dettaglio il tuo livello di competenza nell'ambito dei linguaggi di programmazione?
Domanda 2: Spiega a parole tue che cos’è il data engineering.
Domanda 3: Puoi descrivere un'esperienza lavorativa con Apache Hadoop e in ambienti di gestione dei dati nel cloud?
20,133 data engineer interview questions shared by candidates
1. the ORDER BY command in SQL is automatically set in what format if you didn't set it? Ascending or Descending? Answer: Ascending 2. When you want to delete or add a column of a table in a database, what command you will use? Answer: ALTER 3. this question about about LEFT JOIN, they ask what command you want to use if you want to keep all the info of the left table? Answer: left join 4. You want to combine two column after removing two duplicates, use UNION or UNION ALL? Answer: UNION
Validate an IP Address. Multiple test cases given.
Phone Interview: Intermediate level Python and SQL questions. 5 questions each for 30 minutes.
Top3 brand names with their average pieces more than $3 and having atleast 2 products.
What is the term used to select non duplicates in SQL?
They answered no questions I sent over and sent my own questions back to me. So that was mighty pathetic too.
in the phone interview: - pretty basic python algorithm question. Having read the others here, I assumed I'd get pitched a softball and then a harder question. I was able to solve it within the first several minutes, but spent the rest of the session trying to optimize the solution. - some basic SQL questions on joins and such. I answered probably 5 or 6 questions. Both of these interviews seemed like minimum bar screens. For the in-person interview: - more difficult python question and had to code on a white board. It was a pretty simple sorting question that was easy to solve but less trivial to optimize. - more difficult SQL questions. I struggled here but I was a bit weaker in SQL so I figured as much. This progressed into dashboard design. - Lunch was at a cafe on campus and delicious. Interviewer was just asking me about work experience and culture and it seemed just like a general personality compatibility test. - Full Stack interview was my favorite part and a lot of fun. Without giving too much away, I was given a realistic problem and tasked with conceptualizing the solution in real time, from start to finish, on a white board. It was a mix of coding and conceptual and seemed to be meant to test product sense.
phone screen for SQL: Give data model - solve various SQL questions Python: list and dict manipulation
SQL analytical queries. Python basic programming.
Viewing 161 - 170 interview questions