Have you used XCom in Airflow?
Middle
175
Data Engineer
671
0
Tell about partitioning in Oracle: why it is used and what types exist?
Middle
173
What about CSV family formats — when can they be used?
Middle
170
Is it possible to view the table schema before executing a query in Hive?
Middle
168
What are views (VIEW) and materialized views in Oracle? How is data updated in a materialized view?
Middle
166
Does the execution plan from EXPLAIN always match what is actually executed?
Middle
166
Why are views and tables separated? What are views used for?
Middle
166
What are lazy operations in Spark and what are they used for?
Middle
165
What other file formats, besides Parquet, work well with Hadoop and Hive?
Middle
164
How to find out the actual execution plan of a query in Oracle?
Middle
164
Tell me about your previous project, what were your responsibilities?
Middle
164
Have you worked with Oracle Data Integrator (ODI)?
Middle
161
How does your experience match the responsibilities in the vacancy: supporting and analyzing loading processes, monitoring and identifying anomalies, testing and deploying improvements in production, second-line support, checking technical documentation?
Middle
161
What are the advantages and disadvantages of distributed database systems?
Middle
157
There was a slow analytical query in Hive. How do you understand what happened to it and how to fix it?
Middle
156
What is the difference between multithreading and multiprocessing? For which tasks should you use threads, and for which processes?
Middle
154
Have you worked with batch loading or streaming?
Middle
154
Can you recall your experience with query optimization? How did you act, analyze?
Middle
153
What architecture did you have on the project? DWH or something else?
Middle
153
Have you worked with window functions? What types of window functions do you know?
Middle
153