Will the experience of playing 'Heavy Rain' be spoiled for me now that I know who the killer is?

No, I played through the whole game knowing who the killer is and I was still sitting at the end of my seat the whole time. It does take a bit of the suspense away, but not enough to seriously hurt the overall experience ;)