The Celtic hero known for his battle with the giant Fomorians is Cú Chulainn. He is famed for his legendary feats, including the defense of Ulster during the Cattle Raid of Cooley. Cú Chulainn's prowess in combat and his tragic fate, along with his confrontation with the Fomorians, underscore his significance in Celtic mythology as a symbol of bravery and sacrifice.