System Analyst

What is normalization and what is it for?

Have you worked with long sprints (a month or more) and planned tasks a year ahead?

Have you written large documents like technical specifications that describe the entire system?

Have you used Postman or Swagger UI for API testing?

Доводилось ли работать с планировщиком запросов (EXPLAIN) для оптимизации SQL-запросов?

Do you have experience working with SOAP, XML in integrations?

What integrations have you designed and how do you describe them?

Can you list the requirements for a transactional system (ACID)? Where have you used transactions in your work?

How would you rate your SQL query writing skills on a 10-point scale? How often do you use SQL in your work?

How can data reading speed be increased in a relational database?

Do you use standard HTTP statuses or do you have custom ones? How do you feel about a situation where the response has a status 200, but contains an error inside?

What methods of integration do you know? Which of them are synchronous and which are asynchronous?

Do you perform testing of external APIs to ensure that the specification matches reality? Do you create end-to-end scenarios in Postman?

Have you worked with XML?

When is it better to adhere to database normalization, and when to create a denormalized structure?

Have you delved into database fault tolerance, replication, and server distribution issues?

Have you participated in analyzing and troubleshooting industrial environment (production) incidents?

What are your salary expectations?

Have you ever designed an API using OpenAPI or Swagger?

How often and how deeply have you used BPMN notation? What levels of processes did you describe, and how complex were the diagrams you created?