Pros: see the review
Cons: turf wars - but i think they are working on it
I have given Informatica a high overall rating, based mostly on four things that aren't covered in the ratings: Executive management, product, customer satisfaction and engineers.
The engineers are on the whole, exceptionally talented and dedicated, certainly in UK and US. By engineers I mean not only developers, but also QA testers and the customer – more... service team.
As a result, the product is one of the best in its field (data integration) if not the best. I am genuinely proud of having contributed to this, even in a small way.
These two facts mean that customers keep coming back for more - I believe Informatica consistently have very high levels of customer satisfaction.
Finally, the top management stand out from the crowd by being very competent and actually decent, honest people. For executive managers to win the respect of the engineers is quite an unusual feat; engineers are not easily impressed. I could mention names, but then, where should I stop? – less