Have you worked with Kafka?
Data Engineer
Tell about your overall experience and what you have studied.
How does Hive differ from Impala?
Why did you decide to leave your current project? What is unsatisfactory there?
Why are you leaving your current job?
Have you had ad-hoc tasks with a clear technical assignment, and how do you feel about ad-hoc requests and changing priorities?
What are your expectations from a new project?
Have you built dashboards and worked with data visualization tools (BI tools)?
Are you familiar with OLAP cubes? When working with multidimensional data similar to a pivot table in Excel but for faster interaction with large data volumes.
Are there any functions and features in Greenplum that are not in regular MySQL and other dialects?
What did you usually do in PostgreSQL? Did you create indexes and what else did you do inside the database?
What is the difference between VACUUM and VACUUM FULL in PostgreSQL?
Tell us how you used Hadoop/HDFS/Hive.
We have an ORDER BY by the number of orders, with two orders of 5, and two orders of 3. How will RANK() and DENSE_RANK() behave?
How was the custom Airflow operator implemented: through BashOperator?
In which cases is Nested Loop Join most suitable?
In what order are the main operations performed in SQL: SELECT, FROM, etc.?
Are you currently attending interviews? Do you have offers or are you in final stages, especially in banks?
Have you faced conflicts within the team or with a manager? How did you handle it? Provide examples.
Why is MergeTree needed in ClickHouse?