Job Description

Strong Data Warehousing Background with deep hands-on SQL & PL/SQL Experience Minimum 5 years of working experience in Oracle Analytics Cloud or Oracle Analytics Server with data warehouse model design / development exposure Good understanding of ERP Source, PVOs mapping to offerings, Finding Key columns in each PVO, BICC, UCM Lead at least 2 FAW Implementations with end to end experience (Provisioning to Roll-out) Provisioning of FAW instance, Configuring Source and Spinning ODI Marketplace instance Good understanding of FAW Architecture, Configurations, Initiating Pipeline, Validation of Measures, OOB project Decks, Implementation process flow Solid understanding of metadata (RPD) modeling & development skills Experience in developing analytical reports with complex formula, layouts Well versed with time series analysis, Dimensional hierarchies, setting up security Experience in ETL process Design, development, proof of validations and code migrations using ODI Marketplace Experience in Data Augmentation, Custom ETL extensions in FAW implementations Experience in BI Publisher Data Model and Reports creation Experience in creating RTF, Excel and PDF templates online / Offline Scheduling BI Publisher reports Reports Bursting Troubleshoot data issues from the analysis criteria all the way to Data Warehouse and to the source systems Experience working with multiple database systems (on premise and cloud) Experience in performance analysis, tuning, reconciliation of data with source systems, data accuracy validation and testing Knowledge of code migration, Change management - version control systems Ability/willing to switch from one Analytics technology to other and flexible to adapt new technologies. EBS or Oracle Fusion SaaS source system knowledge is a plus if not, Willingness to understand source system business process flow and learn the technical ER models Knowledge of non-Oracle analytics is a plus (Tableau, Power BI, Looker, QlikSense etc..)

What should you possess?

Education qualification : Prefer B.E/B.Tech/M.Tech/MCA/M.Sc Computers or any Graduate A minimum of 5-8 years of experience in Oracle Analytics and other relevant with exposure to Data (ETL) Engineer Technical role. Hands-on Experience in technical Skills such as - SQL, PL/SQL, ODI components

Technical exposure in either/combination of the EBS/Fusion modules like, HCM or SCM or CRM or Financials or Manufacturing.

Possess good experience in Agile or Scrum Methodologies. Should possess hands-on experience in analytics configurations & setup. Possess fair understanding of different phases in SDLC and have independent project execution knowledge. Experience in creating documentation to support analysis and implementation for all aspects of Data & Analytics Role. Excellent Analytical, Communication, Listening and Customer interaction skill are required. Maintain high understanding of Dignity and Diversity in the workplace. Flexible and mature approach with ability to work unsupervised. * Flexibility to travel and to take up assignments as per the needs of organization.