. Objectives:
The primary objectives of engaging this resource are:
Provide technical expertise in Oracle Data Warehousing, Schema design, Oracle Reports, and Oracle BI tools.
Assist with the development, maintenance, and support of the existing Oracle DW/BI environment.
Contribute functional and technical knowledge related to Oracle EBS and/or Oracle Fusion applications to support data extraction, integration, and reporting requirements.
Potentially assist with data migration, upgrades, or new implementations related to Oracle EBS and/or Fusion.
Improve efficiency and reduce the workload on the onshore team.
2. Scope of Services:
The resource will be responsible for performing the following tasks:
2.1. Oracle Data Warehousing & Schema:
Design, develop, and maintain Oracle data warehouse schemas, including star schemas, snowflake schemas, and other dimensional models.
Develop and implement ETL (Extract, Transform, Load) processes using Oracle tools (e.g., SQL*Loader, PL/SQL) or other relevant ETL tools as required.
Optimize data warehouse performance through indexing, partitioning, and query tuning.
Create and maintain data dictionaries and data models.
Troubleshoot data loading and data quality issues within the data warehouse.
2.2. Oracle Reports:
Design, develop, and modify various types of Oracle Reports (e.g., tabular, matrix, chart-based).
Develop reports based on data from Oracle EBS, Oracle Fusion, and the data warehouse.
Optimize report performance and ensure data accuracy.
Troubleshoot issues related to Oracle Reports.
Manage report scheduling and distribution as required.
2.3. Oracle EBS Functional & Technical Knowledge (If Applicable):
Understand the data structures and business processes within relevant Oracle EBS modules (specify modules, e.g., Finance, Supply Chain, HR).
Assist in identifying and extracting data from Oracle EBS for reporting and data warehousing purposes.
Develop custom SQL queries and PL/SQL procedures to access and manipulate data within Oracle EBS.
Collaborate with functional consultants to understand reporting requirements and data needs.
Potentially assist with technical configurations or customizations within Oracle EBS related to data and reporting.
2.4. Oracle Fusion Functional & Technical Knowledge (If Applicable):
Understand the data structures and business processes within relevant Oracle Fusion Cloud Applications modules (specify modules, e.g., Financials, SCM, HCM).
Assist in identifying and extracting data from Oracle Fusion for reporting and data warehousing purposes, utilizing tools like Oracle Transactional Business Intelligence (OTBI) and BI Publisher.
Develop and customize reports and analyses within the Oracle Fusion environment.
Collaborate with functional consultants to understand reporting requirements and data needs in Fusion.
Potentially assist with technical configurations or customizations within Oracle Fusion related to data and reporting.
3. Tools and Technologies:
The resource should have access to and be proficient in using the following tools and technologies:
Oracle Database
Oracle SQL Developer or similar database development tools
Oracle Reports Builder
Oracle BI tools (specify versions and tools, e.g., OBIEE 12c, OAC)
ETL tools
Top Skills
What We Do
A dynamic solution provider, passionate about building smart, modular, comprehensive, and sustainable solutions for today’s world of business.
We resolve problems, improve operations and enhance customer experience through technology as we help our clients find better, smarter ways to perform business and modernize the way they work. Since our establishment in 2014, our 400+ Skilled engineers have been strongly committed to our 100+ enterprise Customers’ satisfaction by helping them overcome their challenges and supporting their journey towards a more agile business in more than 14 Countries. Our offices are across the globe in USA, UK, UAE, KSA and Egypt.
Advansys ESC is part of INTRO Group, which was founded in 1980 and currently employs more than 2,500 skilled calibers. The group encompasses a wide range of companies in several sectors, including oil and gas, construction, pharmaceutical, engineering, and trading and commercial representation.
We are specialized in a wide array of premium services including Business Automation, Low-code Development, Cloud Services, Industrial Digitization, Warehouse Automation and Strategic Outsourcing.
For more info:
[email protected]
