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.
Sr Data Engineer Interview Questions
2,606 sr data engineer interview questions shared by candidates
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
Technical: Some questions on Spark, SQL, Python, AWS Behavioral: 1 thing u will miss from your previous organisations
How do you manage to build an scalable data pipeline :)
Difference between coalesce and repartition?
What is important for you in a team?
Viewing 2101 - 2110 interview questions
See Interview Questions for Similar Jobs
Data EngineeringSenior Data EngineerBig Data EngineerSenior Big Data EngineerData EngineerSenior Data ConsultantLead Data EngineerData ScientistsData Scientist IiiPrincipal Data EngineerData Mining EngineerBigdata EngineerSr Data AnalystEtl Data Stage DeveloperSr Database EngineerDatabase Administrator IiSenior Data Stage DeveloperEtl Informatica Developer