Why are the date time fields different between Salesforce and my data warehouse?
Salesforce date times are always stored in the backend as Coordinated Universal Time (UTC). When displayed in your Salesforce client application, these values are then localized to your timezone. The Salesforce API (which we use to sync) relies on the backend. This is why records are written in UTC in your data warehouse.