Data Engineer

What is the difference between docker run and docker exec commands?

What are the main Linux commands you use in the terminal?

How do you deliver DAG codes to production?

What agents and models are used within your enterprise AI solution? Does it write code for you?

In what situations should B-tree and hash indexes be used in PostgreSQL?

What technologies is your lakehouse built on and what issues arise when working with Apache Iceberg?.

Write SQL to add a running total of order sums by user and date.

How to add a moving average of the order sum for the current and two previous days per user?

LeetCode #? — In PostgreSQL, there is a table [table] with a single column id and values 1, 1, 2. Write a DELETE query that physically removes one duplicate.

How do you see your development in the new team and what tasks would you like to focus on the most?

What databases have you worked with? How is MongoDB structured and how does it scale?

What is CDC and do you have any experience working with it?

How was the parallel extraction of a large table from PostgreSQL to Spark technically implemented in the [context] case?

Tell us about yourself: your experience, tasks, features, or achievements you are proud of.

Why are you looking for a new job?

Why did you choose custom scripts in Python/Airflow for Data Quality instead of a ready-made engine like Great Expectations?

What is the ideal ratio between business tasks and infrastructure tasks for you?

What visualization tools have you worked with and how closely have you worked with Power BI?

What happens in PostgreSQL after executing the query SELECT * FROM [table]?

On the displayed screen, there are two data structures; in which one will the search for the value 2 be faster and why?