His identity
Catholics, as many other Christians, solve the problem of Nathaniel's name being missing from lists of the apostles by identifying Nathaniel with Bartholomew. The latter is a patronymic, a "last name" similar to Peter being call "Simon Bar-Jona."
And Jesus answered him, “Blessed are you, Simon Bar-Jona! (Matthew 16:17)
Thus, the Catholic Encyclopedia says
It is generally held that Nathanael is to be identified with the
Apostle Bartholomew of the Synoptic writers... It is assumed that it is he whom the author of the Fourth
Gospel designates by his personal name Nathanael.
In Hebrew, this apostle's last name would be Bar-Tolmai. What we have in John's gospel a Greek version of this.
His role
Regarding his role, the article says:
Nathanael is mentioned as present with other Apostles after the
Resurrection in the scene described in John 21. He was brought to
Jesus by Philip (John 1:45), and thus it seems significant that
Bartholomew is always mentioned next to Philip in the lists of the
Twelve given by the Synoptists (Matthew 10:3; Mark 3:18; Luke 6:14).
The Catholic Encyclopedia further admits that little is known about him by either name and says "no mention of St. Bartholomew occurs in ecclesiastical literature before Eusebius."
We have to conclude that Nathaniel/Bartholomew played only a minor role in Jesus' ministry as recorded in the Gospels and early church tradition.