Python

Why are indexes needed in databases? What are the disadvantages? What data structure is used for a standard index?

What data types are there in Python? Tell me about mutable and immutable types.

Middle

СБЕР

How do you envision your role in the project?

How does caching work in Dockerfile? How to reduce the time of subsequent builds?

What is application monitoring (health-checks, URL availability)?

Middle+

СБЕР

from fastapi import FastAPI, UploadFile, Response from fastapi.responses import StreamingResponse from pydantic import BaseModel, field_validator import base64 app = FastAPI() class PdfSchema(BaseModel): filename: str content_type: str data: str # base64 pdf 10мб @app.get("/data", response_model=PdfSchema) async def get_data(): return await service.get_big_data() @app.get("/download") async def download(): with open("big.pdf", "rb") as f: data = f.read() return Response(content=data, media_type="application/pdf") def heavy_pdf_parse(data: bytes) -> dict: # CPU-heavy логика return {"size": len(data)} @app.post("/parse") async def parse(file: UploadFile): content = await file.read() result = heavy_pdf_parse(content) return result @app.get("/users") async def get_users(): users = await repo.get_users() result = [] for u in users: posts = await repo.get_posts(u["id"]) result.append({"user": u, "posts": posts}) return result @app.get("/download-two") async def download_two(): def iterfile(): with open("big.pdf", "rb") as f: yield from f return StreamingResponse(iterfile(), media_type="application/pdf") class service: @staticmethod async def get_big_data(): return { "filename": "file.pdf", "content_type": "application/pdf", "data": base64.b64encode(b"fake").decode(), } class repo: @staticmethod async def get_users(): return [{"id": 1}, {"id": 2}] @staticmethod async def get_posts(user_id: int): return [{"id": 1, "user id": user_id}]

Middle

СБЕР

Do you know what Zabbix is?

Middle+

СБЕР

On which project did you work the most with Python and what exactly did you do?

Have you been in search or outsourcing/in-house projects or a break since May?

Tell about your job search experience: how active are you in the search, at what stages are you?

Situation with code review: [name] wrote a large PR, [name] reviews, PR is hanging — [name] constantly returns with new comments. How to solve tactically and strategically?

Find a fixed-size submatrix KX×KY with the maximum average value of elements

Senior

СБЕР

Tell me about the product/project you worked on and your main tasks.

How did [organization] comply with the requirements of 152-FZ when using LLM?

If a function can legitimately return NaN (which is normal behavior), and your current cache implementation will throw an error in this case or always recalculate — how would you fix this?

In what case are linked lists more efficient than arrays?

Middle

Лига Цифровой Экономики

In your own words, tell us how you designed PostgreSQL for a marketplace showcase: business requirements, number of tables, relationships, what is a business entity?

Why did you decide to switch to development?

How was idempotency and error handling ensured?

Middle

Bell Integrator

Can you work on the frontend, checking the flow of processes from point to point?