Bug: Not able to use multiple SSO profiles for aws-sdk client credentials

### Description:
I have a lambda that is accessing several services in different accounts using the IAM assume role feature in production. When developing locally I am using AWS SSO and have configured a session as part of several profiles. It seems like that I can only pass in one profile that then gets resolved to a AWS_SESSION_TOKEN, AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY.

It seems like I am unable to access several profiles so that my AWS clients can fetch their respectively required credentials.

### Steps to reproduce:
Create a Lambda that instantiates two clients that each get credentials from a different SSO profile

```
const { fromSSO } = require('@aws-sdk/credential-providers')
fromSSO({
ssoStartUrl: config.SSO_START_URL,
ssoAccountId: config.SSO_ACCOUNT,
profile: config.SSO_PROFILE,
ssoRoleName: config.SSO_ROLE_NAME,
ssoRegion: config.REGION,
ssoSession: 'session'
})
```

the lambda `env` will contain AWS_SESSION_TOKEN, AWS_ACCESS_KEY_ID and AWS_SECRET_ACCESS_KEY but only for the profile that is passed in via `--profile`.

### Expected result:
I should be able to get credentials for several profiles as I want to be able to use `fromSSO`. Maybe I am misunderstanding the use of SSO credentials here. Any input would be very appreciated.

### Additional environment details (Ex: Windows, Mac, Amazon Linux etc)

1. OS: OSX
2. `sam --version`: 1.103.0
3. AWS region: us-east-1

# Paste the output of `sam --info` here
```
{
"version": "1.103.0",
"system": {
"python": "3.8.13",
"os": "macOS-14.0-x86_64-i386-64bit"
},
"additional_dependencies": {
"docker_engine": "24.0.6",
"aws_cdk": "2.92.0 (build bf62e55)",
"terraform": "Not available"
},
"available_beta_feature_env_vars": [
"SAM_CLI_BETA_FEATURES",
"SAM_CLI_BETA_BUILD_PERFORMANCE",
"SAM_CLI_BETA_TERRAFORM_SUPPORT",
"SAM_CLI_BETA_RUST_CARGO_LAMBDA"
]
}
```
`Add --debug flag to command you are running`