https://departments.arlingtonva.us/staff-directory/
ETL: AWS Lambda Python function
- Retrieve external API credentials from DynamoDB and decrypt with KMS (using CredStash)
- Download staff details from Office 365 SharePoint list
- Sync profile pictures from Outlook to S3, storing eTag as S3 metadata
- Generate JSON file for public website and mobile apps
- Upload JSON file to S3
- Generate CSV file for open data portal
- Upload CSV to open data portal