I was wondering is killing a forgivable sin. I have heard of Qisas but I think it’s only forgivable in the dunya and the pain will still affect you in the afterlife?

Yes it is forgivable. If the killer truly repents, pays the Diyyah (blood money) to the family of the one killed, becomes righteous, avoids sins, and never goes back to killing, then Allah forgives.