Data Engineer

How would you implement filtering before a join in a query?

Have you worked with Informatica or Oracle? Did you use SQL procedures and functions?

Middle+

Альфа-Банк

How do you pass data between different Airflow tasks?

Middle+

Альфа-Банк

What are your expectations from a new project?

Middle+

Альфа-Банк

What data volumes did you have to process?

Middle+

Альфа-Банк

Have you worked with Oracle and PL/SQL?

Middle+

Альфа-Банк

Did you write DAGs in Airflow? What types of tasks did you use?

Middle+

Альфа-Банк

Describe an end-to-end technical task: from source to storefront, including layers and actions at each stage.

Middle+

Альфа-Банк

Do you have any questions at this stage?

Middle+

Альфа-Банк

What is the most complex SQL you have written? What window functions did you use?

Middle+

Альфа-Банк

[name] tell us about your current project: what did you do, what interesting tasks, technologies, and the complexity of the project.

Middle+

Альфа-Банк

When is it more advantageous to use hash partition, and when range partition?

Middle+

Альфа-Банк

Why did you decide to leave your current project? What is unsatisfactory there?

Middle+

Альфа-Банк

Did you use indexes in your work? Which ones did you use most often?

Middle+

Альфа-Банк

Why do you have doubts about offers?

Middle+

Альфа-Банк

If an SQL query takes too long, what will you do?

Middle+

Альфа-Банк

How do you evaluate a new, unfamiliar task? Where do you start?

Middle+

Альфа-Банк

Have you worked with Kafka?

Middle+

Альфа-Банк

What did you usually do in PostgreSQL? Did you create indexes and what else did you do inside the database?

Middle+

Альфа-Банк

What is the difference between VACUUM and VACUUM FULL in PostgreSQL?

Middle+

Альфа-Банк