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 !!!!!!
Senior Data Engineer Interview Questions
2,387 senior data engineer interview questions shared by candidates
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.
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
1. Serialization 2. Hash set internal working 3. Thread pool 4. Anagram coding question 5. Design patterns 6. Design principals 7. Kafka over rabbitmq
1)how do u flatten json nested structure in spark, 2)delete columns based on some conditions in spark, 3)sqoop export with incremental loading 4)datetime related querstions in python 5)problem and need to solve in java 6)lot of scenario based questions related to RDBMS vs Hadoop choice
Take home assignment to design airflow pipeline and architecture diagram
Difference between Delete and truncate statements.
Viewing 1871 - 1880 interview questions