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
Other Senior Consultant Interview Reviews for Deloitte
The process was very structured, beginning with managers, before progressing to a final interview with the partner. The first stages were more analytical, with the final interview being less formal, where it appeared the partner was seeking to finalise the recruitment process.
I applied through a recruiter. The process took 4 months. I interviewed at Deloitte
Interview
Several rounds of interviews. Two rounds with a consulting director. One round with a technical director. Final round with a partner. Final negotiations with HR via email and phone call.
Interview questions [1]
Question 1
They asked a technical question about the software I was an expert in. It was simple enough to rule out anyone without experience, but not stump someone with intermediate knowledge.
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
Interview questions [1]
Question 1
Explain roles and responsibilities as Qa
Whether I have used Ai tools
Explain roles and permission sets