Is there any way to create talend job based on Excel template(Job Specification) or XML template ?
Note: Informatica Powercenter has a feature to achieve this based on Excel Mapping Analyst
If you are looking for something that will allow you to build a job from scratch from processing data in an Excel file....then the answer is no. If you are looking to be able to derive mapping rules with an Excel file which can be changed at runtime, then the answer is yes......with the subscription product. You can use the tRules component for this (https://help.talend.com/reader/g8zdjVE7fWNUh3u4ztO6Dw/9QMqaSzwCKa~PMhORIhDVQ).
The Talend Metadata Bridge (MIMB) that is part of the Platform product will allow you to import an Excel Template for metadata into a Talend Job. See https://www.slideshare.net/jmfranco/talend-metadata-bridge slide 11
See also this video https://www.youtube.com/watch?v=hnPBXChTZwM
You need a platform product to leverage this bridge which is provided in that level of product.