Data Engineer

What was the last task you solved in production using Python?

Why should you avoid making many small inserts in ClickHouse?

What is a partition in ClickHouse and how is it chosen?

What is important to you when designing a pipeline?

Tell us about your experience working with Airflow (orchestrator). What did you use?

When you encounter a problem in the production pipeline, how do you act?

How do you usually approach building ETL and ELT processes? What is the difference between these processes?

What are the differences between the int and uint data types in ClickHouse?

What would you like to develop? Architectural solutions specifically?

How can data be deleted from ClickHouse?

What is a primary key in ClickHouse and how does it differ from a primary key in traditional databases?

How do you usually work with Git in a team? And what is a Merge Request?

Have you written unit tests? Do you have such experience?

How do you document your projects? Do you write a README or something else?

In which team and under what leadership do you feel most comfortable working?

For what tasks is ClickHouse poorly suited, and what would you choose instead of it?

How do you usually organize your work on tasks and track progress?

Do you have experience setting up CI/CD pipelines, for example, with GitLab?

Do you have experience writing documentation?