Apps Associates - Data Analytics Engineer - ETL / Python

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? :

(ref : hirist.tech)