Effective in version 10.5.2, you can use Amazon Redshift Spectrum to directly run queries and read large Amazon S3 data files without the need to load or transform the data.
For more information, see the
Informatica PowerExchange for Amazon Redshift User Guide