Could someone please suggest the process to sync the data from PROD DB to the Staging environment with minimal manual intervention or automatically.
Read up on the general purpose "bash" scripting language, the PostgreSQL "pg_dump" and "pg_restore" commands, "ssh", and "cron".
"cron" and "bash" provide for the "automatically" requirement.
It is possible to assemble something functional with those tools. Whether it will actually work in your specific situation is impossible to say since you provide zero information about your environment.
