A German engineer abducted in January by gunmen in northern Nigeria has been killed during a failed rescue bid, security sources say.