Data Engineer

DBMS technically — a database is just a file, where do restrictions like NULL/NOT NULL come from? What are these logical abstractions for?

What was the purpose of Data Vault for you in general?

What is the difference between == and is in Python?

Tell me about CI/CD processes, database changes, versioning, and schema migrations (schema evolution)?

Are you from Moscow? Have you lived here long? Why did you move to Moscow?

What is your experience and understanding of building data pipelines for data marts (data processing)?

What are your plans for the next 5 years? In which areas would you like to develop?

How do you understand the concept of keys in tables — what is it for?

Tell me about your hobbies outside of coding.

Tell me, what do you do in your free time? What pet projects do you have?

What is the difference between virtualization and containerization (Docker)?

What experience do you have with SQL and relational databases?

What is important to you in a new project, new team, or company?

There is such a concept — transaction isolation levels. What do you know about it?

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

How exactly was it possible to optimize Data Vault queries, given that it usually increases the number of joins?