Can you please tell me which program is used to make this kind of videos.
The video you included doesn't play for me, did you mean this one? https://www.youtube.com/watch?v=nH0OLZkLCZk
When creating a video there are always multiple pieces of software to choose from. And often you don't use just one program but several: one for compositing and editing the video, another for creating artwork, a third for 3D-renderings, etc.
The ones I have had some (limited) experience with are Adobes suite of programs (Premiere Pro, After Effects, Photoshop, Illustrator, Dimension, etc). They integrate very well together. But there are other alternatives, some free ones also. Haven't used any of those myself though.
And please recommend if I can achieve the skills in that program to make it myself, or is it necessary to hire a professional?Since I don't know what level of proficiency you have in different fields this is near impossible to answer.
But based only on the information that you do not know what programs to use and need to ask, I would say no, you probably cannot learn yourself in time for your Kickstarter. Can you learn at all? Of course you can! But it will take quite some time and effort, and you must ask yourself if it is worth it.
Videos like these are created by people with experience and often quite a bit of talent. So if you want guaranteed results, it is probably better to hire good talent and do what you do best.