In the next few weeks, my company will be engaging multiple vendors to establish a choice for a common global ETL tool - not necessarily one that can't be broken from, but just where our license investment will go to consolidate those costs. Two of the major players are Talend and Informatica, with others that are unimportant for the sake of this question.
My experience is in Talend's Enterprise ETL tool, Talend Integration Suite, which also has many standard integration capabilities. Aside from all of the obvious pros and cons between the two such as cost, availability of knowledgeable resources, etc. my question is specific to the development language knowledge required.
I'd like some feedback on the Informatica option. I can state from experience that to use Talend effectively, and reach beyond it's pre-programmed bounds (which happens pretty often), you need to have a decent background in Java. And in this case, I mean Java directly - you can literally use Java if you need to add-on functionality, not a "special" version of Java. What is the situation with Informatica? Is there a particular extension language you can use? Is it proprietary, but perhaps closely related to a mainstream language? What is the likelihood of needing to use it for any jobs of consequence?
This is only one factor I'm going to use in evaluating the space, but I need to get a little more up to speed on this aspect of Informatica before I feel fully informed. Thanks for your answers!