if it's possible or not to create stored procedure within a Talend Job?
You can use tPostgresqlRow for call any SQL code, do it same as PostgreSQL console - plain SQL code.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.