Daily active-candidates export to S3
Daily CSV export of active candidates (365-day activity) to an S3 bucket for ingestion into Salesforce Marketing Cloud, cleared by the DPO.
Ruby on Rails
AWS S3
Salesforce Marketing Cloud
Active Job
CSV
Daily CSV export of active candidates (365-day activity) to an S3 bucket, ingested by Salesforce Marketing Cloud (4 Data Extensions in a single file), with DPO sign-off. The service streams data via find_in_batches(500) with association preloading and a batched EXISTS lookup on favorites, restricts the temp file to 0600 (PII) and uploads it through Staff::S3ExporterService. A dedicated online index on last_activity_on (INPLACE / LOCK=NONE) keeps the daily filter fast on ~1.77M rows. Daily cron at 6am. Tested.