Skillset Required:
1. Consultant will be able to perform OBI/ODI/Oracle database Admin activities.
2. Consultant will be able to translate business requirements to high level/low level technical solution
3. Consultant will be able to design and develop ETL procedures
4. Consultant will be able to design and develop RPD/Reports
Job / Duties of the resource:
1. Monitor ETL processes and triage any ETL failures.
2. Liaise with internal IT team for production failures due to files not found error (T24/NI files not copied to BI servers in the specified time).
3. Work on BI services down issues, etc. Restart servers on a periodic basis.
4. Cater to user complaints (login issues, access issues, etc). Liaise with internal IT team.
5. Manage user access and object level security.
6. Upload manual grouping files to ODI server designated location once user sends the updated file.
7. Take regular backups of BI RPD and catalog.
8. Debug Post go-live issues (can be data issue, report issue, etc) if any reported by user.
9. Cater to user change requests
9.1. Adding fields to report/RPD presentation layer.
9.2. Logic changes to the RPD design.
9.3. ETL changes to the data model changes.
10. Code migration to UAT and Production
.