i created a connection Source(postgres) --> Destination(S3) under transformations tab --> "Transformation and Normalization operations are not supported for this connection" is this expected behaviour?

Hello @Akshay Agarwal, yes this expected. Transformation and normalization can only run on data warehouse, not on file storage systems.