II.
LibraryAgent overview
Reference · livelib-agent:travel--python-etl-engineer
python-etl-engineer overview
Writes and executes idempotent Python 3 + stdlib sqlite3 ETL scripts that create the travel database and load every data source into it, then reconciles ingested row counts against scope expectations.
Attributes
displayName
python-etl-engineer
description
Writes and executes idempotent Python 3 + stdlib sqlite3 ETL scripts that create the travel database and load every data source into it, then reconciles ingested row counts against scope expectations.
libraryPath
library/specializations/domains/business/travel/agents/python-etl-engineer/AGENT.md
specialization
travel
role
Python ETL Engineer
expertise
- Python 3 standard library (sqlite3, csv, json, urllib.request, pathlib, argparse, hashlib)
- Streaming ingestion with batched executemany()
- Idempotent rebuild vs reuse semantics
- PRAGMA foreign_key_check and integrity_check
- Row-level failure diagnostics
Outgoing edges
lib_applies_to_domain1
- domain:travel·DomainTravel
lib_belongs_to_specialization1
- specialization:travel·SpecializationTravel
lib_implements_workflow1
- workflow:customer-journey-optimization·WorkflowCustomer Journey Optimization
lib_involves_role3
- role:data-engineer·RoleData Engineer
- role:analytics-engineer·RoleAnalytics Engineer
- role:data-analyst·RoleData Analyst
lib_requires_skill_area3
- skill-area:etl-pipelines·SkillAreaETL Pipelines
- skill-area:travel-itinerary-planning·SkillAreaTravel Itinerary Planning
- skill-area:data-quality·SkillAreaData Quality
Incoming edges
uses_agent2
- lib-process:shared--local-db-build·LibraryProcesslibrary/processes/shared/local-db-build
- lib-process:travel--flight-dataset-build·LibraryProcessflight-dataset-build