I thought files would be directly transferred from Execute to s3 and thus would reduce load on AP(submitter). But if it would come to AP and then go to s3, then it would increase the load on AP ?
No. The URLs are signed on the AP. The signed URLs (which only work for a limited time) are sent to the EP, which downloads them there.
-- ToddM