Home assignment to create ETL process on Airflow and design table on Postgres, all in docker container.
Senior Data Engineer Interview Questions
2,595 senior data engineer interview questions shared by candidates
All technical question was related to my expected Role, so with respect to Python, Pyspark and SQL and Cloud related all question was asked, like how you will design a Data modeling and how to process large amount of Data and few coding question to check the programming knowledge.
I don't recall any specific questions. Fairly standard intros, discussion of past projects, etc.
2 rounds of technical and then managerial round
Situations questions, Database schemas, NoSQL database questions.
Software Design and Architecture Question: How I would design a popular application at scale ?
Develop a fully functional e-commerce and data analytics systems in three days.
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.
SQL Data warehousing and bit of python.
How i developed my expertise on Power BI?
Viewing 301 - 310 interview questions