Oracle golden gate to BigQuery
I have figured out what's wrong in this, actually nothing wrong. The glitch here is the mapping.

I was mapped my table names in prm file like below.

MAP HR.TEST, TARGET bqtest.TEST

I was thinking in bqtest dataset, I can see the Test table, But its not true. Goldengate will convert your mapping as bqtest_test. This is the actual table name. So you can see that this table got created automatically.