What are the responsibilities and job description for the Oracle FAW Architect SR. Manager position at The Hackett Group?
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.