config: revert to standard S3_ env var naming convention

test: refactor unit tests to support async services, S3 mocking and pytest fixtures

test: fix async test logic, mocking strategy and S3 key assertions

test: add test_workflow