System Analyst

What types of JOINs do you know in SQL?

You consider the main project full-time for yourself, right?

Behavioral question: a developer disagrees with a task from the product owner. What are your actions?

Middle+

СБЕР

What methods of interaction in difficult cases, besides escalation, could you use?

Design a fault-tolerant payment processing system architecture so that when the bank gateway fails, users do not see 500 errors, but payments are guaranteed to be processed.

Middle

Альфа-Банк

What are the types of relationships between tables?

Middle+

Билайн

Why did you decide to leave your previous job?

What attracts you to our company compared to the current offer?

Tell me about your last place of work.

What diagrams have you drawn?

Middle+

Билайн

What are REST API and SOAP? How do they differ?

Middle+

СБЕР

How would you design the traceability accounting of batches in PostgreSQL?

Senior

Aston

Are you familiar with Postman? Have you used it?

Have you formed process descriptions in BPMN?

In what cases is data normalization useful, and in which is it harmful? When can normalization be neglected?

Do you have an understanding of the structure and architecture of information systems?

What methods of optimizing a microservice under high load can you suggest?

What was the most challenging aspect of working with the provider's API?

Tell us about your experience working with corporate system integrations

What UML notations do you know?