Job Description :
Roles & Responsibilities Perform changes on ODI flows configuration and PL/SQL components to resolve incidents Perform ODI servers recycle & trouble shoot any issues on server cluster instances and flows deployment Identify and eliminate recurring issues on ODI flows configuration and batch jobs optimization on ODI Ent & ODI BI Apps Monitor tickets, critical jobs, alerts and interfaces for issue similarities on ODI plaform and data flows Housekeeping activities of ODI platform, ODS and data flows Co-ordinate with the client infrastructure & vendor team for OS, network and hardware level patches Installation of certificates & ODI product patches, co-ordinate firewall rules open Monitoring of implemented ODI flows and rerouting tickets as needed Work with Oracle support team on ODI product issues, patches Automated alerts creation, server metrics collecton and reporting on ODI Platform components using OEM Perform ODI flows enhancements deployment & verification Good knowledge on Load plans run, debug and batahc jobs in ODI Enterprise and BiApps ODI Adequate knowledge on OBIEE backend tables and views Skill Set Oracle Data Intergrator Admin activites, performance tune up, configuration changes, flows deployment Oracle Data Intergrator instances build, configuration and environment set up Used Oracle Data Integrator Designer (ODI) to develop processes for extracting, cleansing, transforming, integrating and loading data into Data Warehouses Experienced in developing stored procedures, functions, packages and database triggers using Oracle SQL Developer and PL/SQL to improve query performance. Troubleshooting on Linux, ExaLogic environment Familiarity with code management, ticket tracking and alert tools like OEM Strong SQL knowledge. Familiar with creating queries, tables, views and other relational objects, and maintaining the referential and data integrity.
             

Similar Jobs you may be interested in ..