Since pulumi stores information about the deployed infrastructure in a state file, and pulumi stores it on hosted pulumi service and manages that state file. Does there is a way I can manage that state file completely without storing it in pulumi cloud service.

If I understand your question correctly, yes. See: https://www.pulumi.com/docs/concepts/state/

Yes I am looking for this. Thanks a lot for sharing it