Job Description
Design, develop, troubleshoot and debug software programs for databases, applications, tools, networks etc. As a member of the software engineering division, you will take an active role in the definition and evolution of standard practices and procedures. You will be responsible for defining and developing software for tasks associated with the developing, designing and debugging of software applications or operating systems. Work is non-routine and very complex, involving the application of advanced technical/business skills in area of specialization. Leading contributor individually and as a team member, providing direction and mentoring to others. BS or MS degree or equivalent experience relevant to functional area. 7 years of software engineering or related experience. About CEAL: The Customer Excellence & Advocacy Lead (CEAL) team is part of the Oracle Analytics Service Excellence (OASE) Organization. Our team is comprised of highly knowledgeable Architects, Subject Matter. Experts (SMEs) and Software Engineers. The team is spread across the globe to ensure good coverage for any time zone. Our primary focus is centered on customer-centric engineering activities, both reactive and proactive. In addition, we provide executive level development / engineering representation needed in critical and / or strategic customer engagements. We help our customers on their transformative journey to adopt Oracle Analytics cloud platforms, Applications, services, architectures and best practices. This Role: You would be part of the CEAL Team working with some of the most strategic customers for Oracle Fusion Analytics warehouse. Oracle Fusion Analytics Warehouse enables you to analyze your Oracle Applications Cloud data and generate visualizations and reports. This packaged service includes Oracle Analytics Cloud and is powered by Oracle Autonomous Data Warehouse. Prior Experience with Oracle Business Intelligence Applications and applications including Oracle Fusion Applications, E-Business Suite, Oracle Databases, Cloud technologies and Data Warehousing desired. Primary Skills: Should have 8+ years of experience working with OBIA & OBIEE Knowledge of OBIA Should possess solid knowledge on OBIEE RPD design, development & deployment Should have strong understanding in BI/data warehouse analysis, design, development & test experience. Expert level experience of Data analysis, Data Profiling, Data Quality, Data modeling, Data integration Expert. Should be able to design, develop and deploy ODI interfaces, packages & scenarios. Experience in writing complex queries, Stored Procedures in Oracle SQL and Oracle PL/SQL Should have experience in designing customized interactive dashboards and reports in OBIEE using drill down, prompts, filters, and variables. Expert in using OBIEE Answers to create queries, format views, charts, and add user interactivity and dynamic content to enhance the user experience. Experience on working with OBIEE security both object level and data leve Experience on working with report performance optimization Experience in developing Dimensional Hierarchies and adding multiple sources to business model objects. Possess skills to creating and scheduling iBots in Oracle BI Delivers to provide real-time, personalized and actionable intelligence data to subscribers Experience in Requirement gathering, solution blueprint, performing fit gap analysis, Business process designs Experience to develop the Logical Data Model (Business Model), metadata and reports including logical columns, aliases, hierarchies, and subject areas to support reporting Experience to translate business analyst requirements into analytics metadata Experience to design & develop BI Physical Data Model Experience in writing complex queries, Stored Procedures in Oracle SQL and Oracle PL/SQL Determine requirements for aggregate tables, hierarchies, level-based measures, etc. Deep understanding of dimensional data modeling techniques Experience in developing Dimensional Hierarchies and adding multiple sources to business model objects. Desirable Skills Working knowledge of ODI Should have customized existing knowledge module Should have created packages / functions/procedures within ODI /implementation of CDC. Should have created and schedule ODI load plans. Ability to design and develop ETL Interfaces, Packages, Load plans, user functions, variables and sequences in ODI to support both batch and real-time data integrations Good knowledge in customization and ODI plugin creation. Worked with multiple Cloud Platforms. Customer Management Skills Ability to understand customer problem and provide technical solution in timely manner Ability to understand customer urgency and sensitivity of problem Ability to view customer situation holistically instead of single transaction Ability to speak confidently and communicate clearly with technical customer and customer management Ability to work well with demanding customer environment, and to delight customer Ability to multitask, and to effectively handle multiple escalations simultaneously Strong verbal and written communication skills Strong adherence to process and be process champion
Employement Category:
Employement Type: Full time
Industry: Software Product
Role Category: IT Operations / EDP / MIS
Functional Area: Not Applicable
Role/Responsibilies: Principal Solutions Architect Analytics
Keyskills:
OBIA
OBIEE
Data analysis
Data Profiling
Data Quality
Data modeling
Data integration
Oracle SQL
ODI
Customer Management
Oracle PLSQL
Dimensional data modeling
ETL Interfaces
Load plans