Oracle FAW Architect SR. Manager

Interpersonal Skills and Characteristics

· Required to have the accessibility and ability to interface with, and gain the respect of, stakeholders at all levels and roles within the company.

· Should be a confident and energetic self-starter.

· Has good judgment, a sense of urgency and has demonstrated commitment to high standards of ethics, regulatory compliance, customer service and business integrity.

· Displays intellectual curiosity and integrity

· Motivated and driven by achieving long-term business outcomes

· Responsibilities

· Assist with provisioning Fusion Analytics Warehouse (FAW), verify FAW prerequisites, configure and activate pipeline data loads.

· Assist with FAW data validation.

· Setup SSO to enable Fusion SaaS Apps users to access FAW, enable standard object and data security.

· Architect solution to feed data from external (non-Fusion) sources into FAW and make the data accessible to report in FAW.

· Educate clients on Cloud technologies and facilitate decision making.

· Work with the SMEs to implement data strategies and build data flows.

· Manage data related requests, analyze issues and provide efficient resolution. Design all program specifications and perform required tests.

· Evaluate all functional requirements, map documents, and troubleshoot all development processes.

· Document all technical specifications, associates, and project deliverables.

Skills and Qualifications

· Experience with FAW - Oracle Fusion Analytics Warehouse.

· Experience with Oracle Cloud Integration tools such as ODI and OIC.

· Knowledge of integrating multiple data sources to load into Enterprise DWH.

· Strong knowledge of Oracle Analytics Cloud (OAC)

· 6+ years of success in consultative/complex deployment projects, architecture, design, implementation and/or support of data and analytics solutions.

· Hands-on development Design and Develop applications using Oracle Fusion Analytics Warehouse.

· Good querying skills in Oracle database with the ability to understand and debug PL/SQL procedures.

· Experience as an architect for Dimension Modelling and Data Warehouse builds.

· Experience in effective performance tuning.

· Implementation of security protocols.

· Strong understanding of Data Modelling.

· Experience in managing various client relationships to get consensus on solutions.