A leading French pharmaceutical company has announced plans to create 267 new jobs in Kilkenny and Wicklow over the coming years.