Hello all, Is there any documentation to understand how data is staged and how the source data is extracted into postgres and then loaded out during a synchronization?

Yes, not specific about staging but there are some docs explaiing about the sync process: https://docs.airbyte.com/understanding-airbyte/jobs