I've been beating my head against a stubborn wall trying to get a expdp of an oracle schema (on premises db) loaded to my new Oracle RDS instance. I saw this comment from you and it sounds exactly like what I want to do. Do you remember how you 'pulled the files from S3, tweaked them, then loaded them into RDS' ?
"For what it's worth... in the end we needed to process the files a bit. So I simply pulled the files from S3, tweaked them, then loaded them into RDS. The retrieval is fast enough that the potential gains of FuseOverAmazon or a pipe are really quite small for us. – mdahlman Dec 4 '13 at 23:34 "
I would love to solve this issue without getting an rman backup of the oracle db.