Frontend

How was this query formed: through ORM, query builder, or was it SQL with parameters substituted?

What are the advantages of RTK Query?

How to migrate a table with millions of rows: add a new column with a default value and remove the old one, without causing production hang during deployment?

How to organize role-based access control in Express?

How to properly stop a Node.js worker process on external termination to avoid interrupting ongoing database transactions?

How to optimize report generation when many requests to multiple databases, including historical data, are performed via Promise.all?

How would you investigate a problem where generating a user-requested PDF report sometimes takes too long, sometimes does not finish, and users get a timeout? You have access to frontend, backend, and infrastructure.

How many roles were in the system?

After switching to streams, a weekly report is generated in a minute, a monthly report in 10 minutes, and a quarterly report in two hours. What could be the reasons and what needs to be done?

What disadvantages of Feature-Sliced Design have you seen or faced difficulties with during its implementation?

How to optimize large forms with many fields in React: reduce unnecessary re-renders and decrease coupling?

How would you change the product and technical approach to report generation so that the user does not wait for the synchronous formation of a large PDF?

What are the advantages of Feature-Sliced Design?

Do you have experience testing frontend?

How do you determine which indexes are missing and on which fields to add indexes?

Do you have experience using View and Materialized View in PostgreSQL?

How was role-based access control implemented on the NestJS backend?

How to implement a situation where access to a resource is available to all users of a certain role, but some data should be hidden or masked, for example salaries?

Tell about your experience organizing and implementing E2E flow in Playwright for large multi-step forms and user scenarios.

Tell us how you found a slow query that took almost two seconds to execute and how you optimized it?