For batch ingestion standalone mode where is the work being performed?

Local node where the pinot-admin command was launched.

Good to know, thanks. So for parallel ingestion of offline table data using spark to create the segments would be the recommended approach I assume. I need to ingest 5+TB of parquet data (30b rows)

Yes