what i want for a job
Senior Data Engineer Interview Questions
2,394 senior data engineer interview questions shared by candidates
1.Asked about the architecture of the current project 2.How to display sum of negative and positive values in different columns in a single column? 3.What is the difference between Union and Union All? 4.Outputs and count of rows for all different joins? 5.Difference between Union and Full outer join? 6.How to display the name of student whose aggregate is more than 200 in students table?
how did you deal with poor performers
Simple coding test on python sql and spark
how will you find duplicate rows using SQL
Home assignment to create ETL process on Airflow and design table on Postgres, all in docker container.
2 rounds of technical and then managerial round
Software Design and Architecture Question: How I would design a popular application at scale ?
Situations questions, Database schemas, NoSQL database questions.
1) Initial one round full of leadership related questions. Didn't expect a one hour full of leadership questions. This round was unexpected as recruiter didn't tell me that it's a leadership round. I was told this is a hiring manager screen where they wanted to check the fit. There were 2 hiring managers (of the 2 teams who were looking for a lead). 2) Initial coding screening - 2 Python coding questions - same as the ones that others mentioned in the Glassdoor. 1- data modeling question (social media site) and set of SQL questions against the data model. 3) Data pipeline system design interview. Asked high-level and low-level details of high data volume real-time pipeline. 4) Behavioral questions with cross-team based questions. 5) Technical round with ETL related question with SQL coding applied. One Python coding to build a grouping based ETL using Python. The output can be easily provided using SQL script. The challenge was to build the same using Python. Should be manageable somebody who's very hands-on. Unfortunately, I wasn't. Though I could write the pseudocode and think through the solution, I couldn't write the actual code within the time. 6) Design the data model for a ridesharing app and answer a set of questions using SQL. I underestimated the complexity of a couple of SQL questions in this round.
Viewing 271 - 280 interview questions