Python Fullstack Engineer

Core Language & Architecture

Python 3.11+

Advanced type hints (PEP 484), static typing discipline

Async programming (asyncio, async/await, async generators)

aiohttp / httpx (async HTTP clients)

Pydantic v2 (BaseModel, validation, settings management)

Structured logging & tracing patterns

Redis (pub/sub, TTL, async clients)

REST API design & integration patterns

Retry/backoff strategies (Tenacity)

Concurrency patterns (parallel tool calls, task orchestration)

Data Engineering & ETL

Prefect 2.x / 3.x

1. Flows, tasks, futures

2. Deployments (YAML)

3. Work pools

4. Blocks (Secrets, storage)

5. Scheduling

ETL/ELT design

1. Incremental loads

2. Idempotency

3. Schema evolution

Snowflake

1. connector-python

2. OAuth authentication

3. Warehouse/schema management

4. Query optimization

PostgreSQL 16/17

1. psycopg 3.x

2. Async support

3. Connection pooling

SQLAlchemy 2.x (ORM + asyncio)

Alembic migrations

Advanced SQL

1. Multi-table JOINs

2. CTEs

3. Window functions

4. Timezone conversion

Pandas 2.x (complex multi-stage transformations)

PyArrow / columnar formats

Azure Blob Storage (azure-storage-blob)

Document ingestion/parsing:

1. Docling

2. Unstructured

3. python-docx

4. python-pptx

Graph Algorithms & Pattern Processing

NetworkX

1. Connected components

2. Transitive closure

3. Graph construction

Alarm correlation logic

Regex engineering

1. IPv4 / IPv6

2. Network interface extraction

3. CI/entity extraction

Entity classification patterns

Backend Engineering (FastAPI Stack)

FastAPI

1. Routing

2. Dependency injection

3. Middleware

4. Streaming responses (SSE)

Async-first backend design

Incremental/streaming LLM responses

Background tasks & concurrency control

Pydantic request/response models

Frontend (React Agent UI)

React 18/19

1. Hooks

2. Context API

3. Performance optimization

TypeScript

MSAL browser authentication

JWT handling

Streaming fetch / incremental rendering

Real-time agent UI updates

Testing & Code Quality

pytest

1. Fixtures

2. Parametrize

3. Markers

unittest.mock (patch, MagicMock)

Ruff

pre-commit hooks

SAST integration

Nice-to-Haves

Ray (distributed execution)

Columnar performance tuning

Network operations domain knowledge

NOC / alarm correlation familiarity