how will you find duplicate rows using SQL
Sr Data Engineer Interview Questions
2,622 sr data engineer interview questions shared by candidates
Home assignment to create ETL process on Airflow and design table on Postgres, all in docker container.
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
I don;t see any Real Time Project related technical questions. They come completely unprepared. Going through some Standard unrelated Questions.
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.
Viewing 301 - 310 interview questions