ODI 12c developer

3-8 years of hands-on experience in ODI 12c, OBIEE 12c and Oracle SQL

-Ready for Overnight support (minimum 2 weeks in a month) for ETL loads built using ODI tool.

-To provide production support for DWH Load through ETL (ODI) and maintain OBIEE Reports; Excellent understanding of creating and monitoring Load Plan in ODI

-To monitor production tickets as pert ITIL framework and provide resolution within acceptable SLA/s

- To ensure correctness and completeness of Data loading (Full load & Incremental load)

-To co-ordinate with BU/ IT Team Lead to ensure implementation as per stated requirements

- Good hands-on in SQL/ PL SQL on volumes of data

- Good understanding of DWH concepts and Oracle Database

- Performance Tuning and Optimization of DB SQL Script and ODI

- Good to have General Insurance Domain Knowledge

- To ensure correctness and completeness of Data loading (Full load & Incremental load)

- Optimizing execution time of interfaces by implementing best practices

- Working Knowledge of OBIEE 12c ; Creating Analytics Reports & Dashboards; Extracting Usage Tracking Report

OBIEE developer

3-8 years of hands-on experience in OBIEE 12c tool for Analytics Report and Dashboard development

- Design and Development of Business Intelligence Analytics / Dashboards & Reports for derivation/ presentation of business KPIs, Scorecard and Measures with several interactive features viz. hierarchy, preferred drilled path, what-if analysis using Oracle Business Intelligence Enterprise Edition (OBIEE) Tool

- Good Knowledge of OBIEE Installation, Configuration and Administration

- Experience on OBIEE Admin Tool in developing Repository (RPD) in all the layers (viz. Physical, Business Modeling Mapping & Presentation Layer)

- Good understanding of DWH concepts and Oracle Database

- Exposure pf Application of OBIEE & ODI Patches for Version upgrade & critical patches for Security- Performance Tuning and Optimization of DB SQL Script and ODI

- Excellent Exposure of detailed preparation and review of LLD (Data Model & Report Mapping) vs BRD (Report Specification Document) to generate feasibility / gap analysis - To ensure correctness and completeness of Data loading (Full load & Incremental load)

- To ensure timely completion of work as per Project Plan

- Must have Worked on usage tracking for OBIEE 12c and Resolved Run time issues related to reports, Prompts and Dashboards.

- Should have Worked on BI Publisher to develop documents template using Data Model.

- Optimizing execution time of interfaces by implementing best practices

-To coordinate with BA/ Lead/ Customer/ Data Modeler to clarify the mapping & other details provided

- Working Knowledge of ODI 12c ; Creating ODI Mapping, Should have Worked with knowledge modules like LKM, IKM and CKM.

- Knowledge of General Insurance Domain