Software Design and Architecture Question: How I would design a popular application at scale ?
Senior Data Engineer Interview Questions
2,553 senior data engineer interview questions shared by candidates
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.
Develop a fully functional e-commerce and data analytics systems in three days.
Experience or situations where I had difficulty convincing a new idea in my team
If you have Category (Columns), Sub-Category (Rows), and Sales in the Text card; how do you highlight the min and max sales for each category with red and green color? The rest of the sales need to stay blue/ default color.
Implement stack with some functionality
How i developed my expertise on Power BI?
Talk about the biggest challenge in Data Engineering you faced in your last job.
SQL Data warehousing and bit of python.
Viewing 301 - 310 interview questions