SSIS Deployment failed on SQL Agent Job - Oracle connection Manager

I have designed an SSIS package which extract data from an Oracle database using SSIS 2014 - Microsoft OLEDB Provider for Oracle. I'm able to run the Package thru Manual execution SSIS but when deploying it to SQL Server Agent Job I got an error. I don't understand why it only fails when deploying in SQL Agent Job but works perfectly when manual executing thru stored packages.

Already applied below configuration

• Created proxy account
• Under the "Execution options" tab, check the check box "Use 32bit runtime"
• Oracle 32 client was installed (ODTwithODAC122011)

Message Executed as user: DOMAIN\administrator. Microsoft (R) SQL Server Execute Package Utility Version 12.0.6024.0 for 32-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:26:07 AM Error: 2021-03-09 11:26:44.14 Code: 0xC0202009 Source: SITPACKAGES Connection manager "ORACLE.SOURCE" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80004005 Description: "ORA-12154: TNS:could not resolve the connect identifier specified". End Error Error: 2021-03-09 11:26:44.14 Code: 0xC020801C Source: Project Interface Source [274] Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ORACLE.SOURCE" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. End Error Error: 2021-03-09 11:26:44.14 Code: 0xC0047017 Source: Project Interface SSIS.Pipeline Description: Source failed validation and returned error code 0xC020801C. End Error Error: 2021-03-09 11:26:44.14 Code: 0xC004700C Source: Project Interface SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2021-03-09 11:26:44.14 Code: 0xC0024107 Source: Project Interface Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:26:07 AM Finished: 11:26:44 AM Elapsed: 36.984 seconds. The package execution failed. The step failed.

Is anyone out there with any idea of how should I go about it? Thank You!