All were simple SQL based questions. The only thing is to focus more on your SQL joins during the workshop. They will give you many to many relationship tables so you can end up creating duplicates.
Data Engineer Interview Questions
20,237 data engineer interview questions shared by candidates
Given a scenario, using the data to construct the model to find the answer.
python and SQL in telephonic Hadoop input file formats, when to use what, design streaming system, Hive optimization, Spark implementation, Python multi-environment related questions Agile and behavioural rounds
1. How would you determine the frequency of each unique element in a list? 2. A problem that can be solved using a SQL window function, and explain your approach?
What is a window function? Joins vs subqueries. Outer vs inner joins. Infrastructure based questions.
Synchronization of two different data frame and asking the complexity of the algorithm. Domain interview: bunch of pyspark related questions and SQL simple query Second programming interview: Find if a path exists in a Graph
Spark and hive optimization techniques, partitioning and bucketing concepts, small programs in pyspark
Explain the join and union and describe the differences between them.
How does memory management work in Python?
solve 5 random sql questions
Viewing 1181 - 1190 interview questions
See Interview Questions for Similar Jobs
Modeling EngineerPerl DeveloperAnalytics EngineerDatabase AdministratorData Warehouse DeveloperDatastage DeveloperDatawarehouse DeveloperData MinerEtl TesterEtl DeveloperData ModelerBusiness Objects DeveloperData AnalystMachine Learning ScientistData ScientistData Warehouse ArchitectBusiness Intelligence SpecialistData Warehouse ManagerOracle Data Integrator