We have a ETL login in our local database, and ETL processed data is pulled by our down stream clients, We are seeing that current ETL is not capable enough to execute such a huge load. So we wanted to port our raw data to secondary database and run ETL login on secondary database and to parallelize it accordingly.

I was just thinking, can we use ETL logic inside OGG parameters, so we can load transformed data to secondary database. So no need of running ETL in secondry database. May be i sound little foolish, but just a thought.

You can perform simple transformations. But this really depends on the type of transformations. Because Oracle GoldenGate perform one record a time during replication, for certain ETL transformation, it might not provide the idea performance.