System Analyst

What is SOAP and how does it differ from REST?

What DBMS have you worked with? Describe your experience in database design.

Tell us about your experience working with corporate system integrations

How do you approach migrating data from an unfamiliar DBMS (e.g., Sybase) to PostgreSQL?

What is DISTINCT ON in PostgreSQL?

What is CTE (Common Table Expressions) and why are they needed?

How deep have you worked with SQL? Have you used window functions, CTEs, and do you understand the physical algorithms of JOIN?

Describe your process for setting development tasks (API, databases, integrations).

What non-functional requirements (NFR) do you specify in projects?

What is the difference between UNION and UNION ALL?

What methods of integration have you worked with (REST, SOAP, message queues, CDC)?