Hw do you explain the work you are doing to a 5 yr old or someone who's of your nephew age. shoot me few technical questions on chat window and type the answers within 5 mins
Sr Data Engineer Interview Questions
2,592 sr 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
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.
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.
Viewing 301 - 310 interview questions