Hey Harshraj,
This isn't necessarily a question for Mendix, as it's pertaining to a separate system, but I found some documentation with a simple Google search. Mendix supports the use of RESTful APIs as well as other communication methods with third parties. I'd recommend leveraging AWS's APIs within Mendix to interact with your secret manager.
API Documentation: https://docs.aws.amazon.com/pdfs/secretsmanager/latest/apireference/secretsmanager-apireference.pdf
Mendix REST API Implementation Documentation: https://docs.mendix.com/refguide/integration/rest-services/
Hope this helps,
Austin