How do you evaluate a new, unfamiliar task? Where do you start?
Middle+
324
Data Engineer
743
0
Task #2 Write a query that outputs the TOP-3 employees by salary in each department. Display the department name, employee name, and salary. employee table: | id | name | salary | dept_id | |----|-------|--------|---------| | 10 | John | 1000 | 2 | | 20 | Tom | 5000 | 3 | | 30 | Bill | 3000 | 2 | department table: | id | name | |----|-----------| | 1 | Marketing | | 2 | IT | | 3 | Finance | Output: department_name, num, employee_name, salary with cte as( select d.name as department_name, e.name as employee_name, e.salary, dense_rank from employee e join department d on e.id = d.id
Middle
324
Have you worked with Informatica or Oracle? Did you use SQL procedures and functions?
Middle+
323
Did you use indexes in your work? Which ones did you use most often?
Middle+
323
Did you write DAGs in Airflow? What types of tasks did you use?
Middle+
321
What problems can tracing identify?
319
Compare two solutions for the memory consumption of unit search: 1) loop with variables, 2) split('0') + list comprehension + max()
Middle
318
Why do you have doubts about offers?
Middle+
317
What can you tell about SOAP API?
Middle+
317
What does the Iceberg format bring compared to regular Parquet?
Senior
317
What is the most complex SQL you have written? What window functions did you use?
Middle+
317
What is the difference between the operators 'is' and '==' in Python?
Middle
313
How to handle skew in user_id when JOINing transaction and user tables? How to choose the optimal sharding key?
Middle
312
How can shuffle be managed in Spark (partitioning, broadcast join, etc.)?
Senior
310
How well do you know Python?
Middle
309
What optimization methods did you use for SQL code?
Middle+
307
How does HDFS differ from regular distributed file systems?
Middle
300
What additional parameters of DDL/CREATE TABLE in ClickHouse do you know, what do they affect, and in what cases are they used?
Middle
297
How do generators differ from lists in Python?
Middle
296
There is a table T1 (10 rows) and a table T2 (5 rows), both with an ID field. What is the maximum and minimum number of rows that can be in the output of an INNER JOIN and a LEFT JOIN of these tables?
Middle
293