SQL Questions, DWH Questions, Projects which I worked and whats my role Exactly in it, Questions about the services used in AWS/Azure Performance Tuning Techniques, a bit of Programming
Senior Data Engineer Interview Questions
2,553 senior data engineer interview questions shared by candidates
1. best join practices 2. Spark Optimization
Tell me about your experience. What did 'you' do in your last project. I don't want to hear 'we did this/that'.
There was a lot of technical questions on ETL/ELT, SQL, Snowflake, Fivetran ,Python ,cloud technologies and implementation in the project . the interviewer were very knowledgeable and down to earth. Even the Managerial round had many technical questions and the interviewer was very humble .There were few personality questions asked like what comes to your mind if about a tiger/crow. The HR round was pretty senseless as per me and they agreed for the offer in first round. In the next interview which was with an HR from Danaher she said that they have a particular amount and said she will release the offer only if i accept it , it seemed i had no say in deciding my compensation. Ultimately they dropped my candidature . Utter Waste of Time !!!!!!
How would you rate your SQL?
Q: Do you know what OLAP Cube is?
The SQL test required writing a query that involved joining two tables, applying a WHERE clause, and using the DENSE_RANK function. Problem statement felt poorly defined.
First interview had general screening questions about experience and motivation. Tech interview was a time-limited challenge that you need to practice in order to feel comfortable and make quick decisions. Second tech interview is about SQL and things that every experienced SQL engineer should know, so refresh fundamentals.
Types of joins in sql
How to architect some system Explain a project in which I had an important invovement and what were my contributions and the challenges What was the asymptotic complexity of the algorithms I implemented
Viewing 2001 - 2010 interview questions