We firmly believe, and hence we hope that, just as Christ is truly risen from the dead and lives for ever, so after death the righteous will live for ever with the risen Christ and he will raise them up on the last day. Our resurrection, like his own, will be the work of the Most Holy Trinity:
If the Spirit of him who raised Jesus from the dead dwells in you, he who raised Christ Jesus from the dead will give life to your mortal bodies also through his Spirit who dwells in you.
Source: Catechism of the Catholic Church (Vatican.va)