Job Description :
ODI Lead
Summit NJ
Duration:12+ months
Experience: Over all 12+ with at least 5+ relevant experience.
Client: Cognizant
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 platform 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 collection 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 Integrator Admin activities, performance tune up, configuration changes, flows deployment
Oracle Data Integrator 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
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.