Utilizing the Oracle Data Integrator (ODI) tool to enhance and modify pre-built packages, creating mappings and procedures as necessary. Additionally, leveraging Oracle SQL Developer as our Integrated Development Environment (IDE) for making updates to PL/SQL code.• Proficiently troubleshooting intricate queries that encountered errors during execution in the work repository due to violations of unique constraints, invalid materialized views, missing objects, and other related issues.• Concurrently, diligently undertaking development activities while ensuring adherence to Service Level Agreements (SLAs) on a daily basis, through the effective maintenance and support of applications and their respective operating environments.• Promptly addressing alerts and adhering to established standard operating procedures and comprehensive documentation for efficient issue resolution.• Engaging with users and team members through professional written communication channels or via the designated ticketing system.• Conducting diligent application monitoring, generating comprehensive reports to analyze high data volumes, and promptly responding to incidents in a professional manner.