Python

How was idempotency ensured when working with Kafka? What happens if a task in Airflow is restarted after an error during Kafka reading?

Middle

СБЕР

Optimizing PostgreSQL for high write load (500+ records/sec)

What special methods need to be implemented when creating a custom context manager in Python?

Can you explain what an anonymous function is in programming?

Condition: Given two arrays of objects. Each object contains a numeric field 'code'. Return a new array containing all objects from array a for which there exists an object in array b with the same 'code' value. The order of elements in the result is determined by the order of the corresponding 'code' in array b: objects from a should be arranged in the order in which their 'code' appears in b. If multiple objects with the same 'code' appear in b, only the first occurrence is considered. Input data: - a — array of objects of the form { code: number, ...rest }, length from 0 to 10^5 - b — array of objects of the form { code: number, ...rest }, length from 0 to 10^5 Output data: Array of objects from a, filtered and ordered by the first occurrence of the corresponding 'code' in b. Constraints: - 0 <= a.length, b.length <= 100 000 - The 'code' field is a non-negative integer - b may contain duplicate 'code' values — only the first occurrence is considered Example function: ```python # Available without import: json, sys, io def intersect_by_code(a, b): # Write solution here return [] ```

Did you work as an outstaff specialist at [company]?

What prompted you to leave your previous project?

What would you do if your API endpoint responds too slowly, taking about 30 seconds?

What is the role of data serialization process in programming?

What is the role and purpose of branches in the Git version control system?

What is the main difference between JSON and JSONB data types in PostgreSQL database?

What data structure would you use if you need to efficiently add and remove elements from the beginning and end?

What prompted you to leave your previous job?

Have you had experience working with the Channels mechanism in your projects?

What functions or procedures are activated during the initialization of a class object?

What questions would you like to ask about the company during the interview?

Intern — Junior

WildberriesСКАИДКодтех+8

How to implement A() + B() = C()? How to add two objects and get a third?

Middle

СБЕР

FROM python:3.11-slim WORKDIR /app COPY . RUN pip install -r requirements.txt RUN useradd -m appuser USER appuser EXPOSE 8000 CMD ["python", "main.py"]

Can Python be considered a language that is compiled before execution?

Explain what the use of O(n) memory means in the context of algorithm analysis with an example.