The "Connection refused" should mean there is nothing listening to port 9200 on the address. I think the OP is asserting that
<ip address> is an address for the local machine, and that
curl -v https:localhost:9200 works but that
curl -v https://Load-testing-1-4:9200 (maybe replacing Load-testing-1-4 with the ip address from /etc/hosts) doesn't.
If that is the case then you need to look at the thing that curl is trying to connect to, and make sure it is listening on all the addresses associated with the machine, or at least the one for Load-testing-1-4. Using 0.0.0.0 as the address will usually do this for IPv4 rather than an explicit address such as 127.0.0.1.
If I have misunderstood and Load-testing-1-4 is a different machine, then you need to look on that machine for the program that curl is trying to connect to.
An added complication is the https, I would suggest using http first to get things going before beefing up the security.