Hundreds of jobs are being created by supermarket giant Tesco which announced today it is opening its first hypermarket in the North.