Recently attended an interview for a Data Engineer role.
The interview had multiple rounds covering SQL, Python, Airflow, GCP, and ETL concepts.
Some of the questions asked:
• SQL joins, window functions, dense_rank vs rank
• Finding duplicates and highest salary by department
• Python list/dictionary handling and basic scripting
• Airflow DAG flow, XComs, operators, scheduling
• GCS, Pub/Sub, Cloud Functions, and service accounts in GCP
• ETL pipeline design and data quality checks
• Scenario-based questions on handling failures and monitoring
The discussion was more practical and scenario-based rather than purely theoretical. They focused a lot on understanding the flow end-to-end and explaining concepts clearly.
Overall, it was a good learning experience and helped me understand areas I should improve further.
Sharing this in case it helps someone preparing for Data Engineering interviews.
1
Otras evaluaciones sobre las entrevistas para el cargo de Senior Consultant en Deloitte
Me postulé en línea. Acudí a una entrevista en Deloitte
Entrevista
It was very vague as only 3 questions were asked which was by BA who does not have QA knowledge.Infact he mentioned that I have good knowledge.despite that I didnt get selected which seems fishy and entire interview was done for formality
Preguntas de entrevista [1]
Pregunta 1
Explain roles and responsibilities as Qa
Whether I have used Ai tools
Explain roles and permission sets
Interview was average for consultant role etl testing with basic sql question of join, count,duplicate. Also they asked about daily task you are doing.different types of joins, difference between those
I had two technical round
final HR round for salary discussion
first round was testing the skills on module you worked on
second round was your behaviour skills, communication and ur leadership
