No. 6 prospect per MLB.com will join Giants as right-handed hitting option in outfield and likely make Major League debut on Sunday