Add local testing support for S3 code

[malhotrashivam]

In the current code, we have added unit tests for fetching files from remote S3 buckets and have disabled them in our CI jobs to avoid failures. A better way to test this code is to use a local S3 stack and unit test against it.
https://java.testcontainers.org/modules/localstack/ could be one approach to do this.

Make sure to add both python and java tests for this code path.

Found during #4972

[malhotrashivam]

@devinrsmith has shared a sample commit here: malhotrashivam#1

[malhotrashivam]

https://java.testcontainers.org/modules/minio/ is another good candidate for integration testing.

[devinrsmith]

Fixed by #5137