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

- 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.