Extract data based on ||" symbol in SQL

WITH [raw] AS
(
  SELECT 'Name=Jhon|Age=36|Job=Sales Manager|Job Location=Texas|' Data
UNION ALL
  SELECT 'Name=Tom|Age=27|Job=Sales Man|Job Location=Texas|' Data
UNION ALL
  SELECT 'Name=Ferdinan|Age=38|Job=Sales Man|Job Location=Texas|' Data
UNION ALL
  SELECT 'Name=Jhonson|Age=29|Job=Marketing Manager|Job Location=Texas|' Data
UNION ALL
  SELECT 'Name=Mikel|Age=26|Job=Technician|Job Location=Texas|' Data
UNION ALL
  SELECT 'Name=Steve|Age=25|Job=Technician|Job Location=Los Angeles|' Data
UNION ALL
  SELECT 'Name=Rob|Age=29|Job=Programmer|Job Location=NC|' Data
)
, [cooked] AS
(
  SELECT CAST('<Data ' + REPLACE(REPLACE(REPLACE(Data,'Job ',''),'=','="'),'|','" ') + ' />' AS XML ) Data
  FROM [raw]
)
SELECT Data.value ( '(*/@Name)[1]' , 'VARCHAR(255)' ) Name
,  Data.value ( '(*/@Age)[1]' , 'int' ) Age
,  Data.value ( '(*/@Job)[1]' , 'VARCHAR(255)' ) Job
,  Data.value ( '(*/@Location)[1]' , 'VARCHAR(255)' ) Location
FROM [cooked]