FTE_Weekday Supply_OBIEE & ODI Developer

Job Description

OBIEE and ODI Should have experience in Oracle Data Integrator (ODI) with knowledge of data modeling and ETL design. Must have worked on end to end implementation of DW and BI projects Experience working with Oracle GoldenGate is a plus Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure. Design and develop mappings, Process Flows and ETL scripts. Ability to tune mappings at ETL level and provide suggestion of tuning at database level. Ability to design ETL unit test cases and debug ETL Mappings. Must have done the Development of topology setup, Load Plans, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs. Managing Files, Oracle DB, XMLs through ODI Create Load-Plans and schedule the same. Create email notifications to alert on exceptions and error. Must be well versed and hands-on in using and customizing Knowledge of KM Strong knowledge and experience and implementation of Oracle Data warehouse concepts SCD2, Aggregates, Hierarchy tables, Snapshot fact tables etc. Should have experience in designing and managing an enterprise wide, large scale data warehouse, with end-to-end implementation on cloud Functional Proficiency on Packaged BI Application (Oracle) and OBIEE is preferred. Can work in teams as well as independently Able to plan / track tasks / activities / co-ordinate and report on periodical basis Onsite Offshore Co-ordination on day to day basis on deliverables and inter-team interaction on need basis Should have experience working with OBIA/OBIEE OBIEE Certification is a plus Proficient in the use of OBIEE RPD Experience in customizations for OBIA/OBIEE rpd and reports. Experience in working with Data level and Object level OBIEE security. Ability to tune Reports at RPD/DB level and provide suggestion of tuning at database level. Ability to design the OBIEE rpd model, and prepare Technical design documentation. Worked in atleast 2 full life-cycles of OBIA/OBIEE implementation for modules like Financial Analytics, Procurement & Spend Analytics, Project Analytics etc. Requirement gathering, solution blueprint, performing fit gap analysis, Business process designs Good problem solver and prompt decision maker Can work in teams as well as independently Able to plan / track tasks / activities / co-ordinate and report on periodical basis Onsite Offshore Co-ordination on day to day basis on deliverables and inter-team interaction on need basis Key Skills: OBIEE and ODI Should have experience in Oracle Data Integrator (ODI) with knowledge of data modeling and ETL design. Must have worked on end to end implementation of DW and BI projects Experience working with Oracle GoldenGate is a plus Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure. Design and develop mappings, Process Flows and ETL scripts. Ability to tune mappings at ETL level and provide suggestion of tuning at database level. Ability to design ETL unit test cases and debug ETL Mappings. Must have done the Development of topology setup, Load Plans, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs. Managing Files, Oracle DB, XMLs through ODI Create Load-Plans and schedule the same. Create email notifications to alert on exceptions and error. Must be well versed and hands-on in using and customizing Knowledge of KM Strong knowledge and experience and implementation of Oracle Data warehouse concepts SCD2, Aggregates, Hierarchy tables, Snapshot fact tables etc. Should have experience in designing and managing an enterprise wide, large scale data warehouse, with end-to-end implementation on cloud Functional Proficiency on Packaged BI Application (Oracle) and OBIEE is preferred. Can work in teams as well as independently Able to plan / track tasks / activities / co-ordinate and report on periodical basis Onsite Offshore Co-ordination on day to day basis on deliverables and inter-team interaction on need basis Should have experience working with OBIA/OBIEE OBIEE Certification is a plus Proficient in the use of OBIEE RPD Experience in customizations for OBIA/OBIEE rpd and reports. Experience in working with Data level and Object level OBIEE security. Ability to tune Reports at RPD/DB level and provide suggestion of tuning at database level. Ability to design the OBIEE rpd model, and prepare Technical design documentation. Worked in atleast 2 full life-cycles of OBIA/OBIEE implementation for modules like Financial Analytics, Procurement & Spend Analytics, Project Analytics etc. Requirement gathering, solution blueprint, performing fit gap analysis, Business process designs Good problem solver and prompt decision maker Can work in teams as well as independently Able to plan / track tasks / activities / co-ordinate and report on periodical basis Onsite Offshore Co-ordination on day to day basis on deliverables and inter-team interaction on need basis,

Keyskills :
windows 7music makingsqloracle 11test casesmappingoracle data integratorodigap analysisoracle data integrator odistatements of work sow