C#

Can you describe how you have used migration mechanisms to manage changes in the database during development?

Can you show an example of using the Builder pattern to create objects?

How can an optimistic locking mechanism be implemented?

Junior — Middle

Aston

From the perspective of metric visualization — custom or standard solution?

What questions can you ask company representatives during an interview?

If a method run asynchronously executes synchronously, does the thread return to the thread pool after its completion?

What tools and libraries do you use when programming in Python?

How is the management of roles and rights of participants implemented in your project?

Junior — Middle

Aston

What steps would you take if a delay in receiving data from the database causes problems in the application?

Can you explain the concept of generic types in programming?

Can you explain the concept of parallel computing and its application in programming?

What does the letter L in the SOLID principles signify and how does it influence software system design?

Explain the principles underlying the SOLID concept and their impact on software system development.

What are the main difficulties encountered when working with databases and how do you solve them?

Is it possible to use async/await inside a lock? Why?

How does the index mechanism accelerate query execution in SQL databases?

Can you name the main data types used in C#?

Can you describe the key characteristics of RESTful API and how they differ from other ways of interacting with services?

Could you explain what a Mock is and in what cases it is used in testing?

Can you explain what is meant by invariants in the context of classes?