System Analyst

How do you approach working with a request as a business analyst? Describe your process.

Middle

СБЕР

What types of JOINs do you know in SQL?

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

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?

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

How many years of experience with REST API and JSON?

Middle

IT One

What UML notations do you know?

What is pagination?

Middle

Wildberries