Pfizer Ireland is to make a €100m investment at one of its key Cork plants over the next two years, but shed 25 full-time positions.