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