Business Intelligence Consultant with expertise in ODI and SQL

Oracle

Egypt

Ref: RP556-1990

Job description / Role

Employment: Full Time

Expertise in ODI ELT tool development such as Interfaces/Mappings, Packages, Scenarios, Variables, Procedures and Load Plans. Excellent SQL building skills. Upgrade expertise from older version of ODI to 12c. Troubleshooting ELT issues and backtracking till the source layer. Performance tuning capabilities.

- Techno-Functional System Support, Configuration, functional/technical design for custom solution and integration.
- Experience with all aspects of the system - development, support, upgrade, testing and Pre & Post implementation activities.
- Should be able to independently design and develop new ELTs or modify the existing ones by using ODI.
- Have experience of writing efficient and optimize code and understanding of performance tuning techniques in ODI.
- Should be able to investigate, analyze and provide solution for enhancements/development.
- Work with the product support team as needed. Knowledge of My Oracle Support is required.
- Perform ELT Developer tasks related to implementation and upgrade projects.
- ELT Support - Break/Fix support,
- Monitoring performance, logs of the ODI ELT Load Plans.
- Monitoring the daily ELT data loads,
- Minor enhancements - including changes & tweaks to scripts, minor ELT adjustments and creating/modifying ETLs.
- Take personal responsibility for continual process improvement.

Requirements

Business Intelligence Consultant with expertise in ODI and SQL. OBIA will be an added advantage. Primary Skills - ODI Techno-Functional consultant with experience in ODI, SQL, Data Warehousing concepts and modeling. Expertise in OBIA modules like Financials, HR, Projects, Procurement and Spend will be an added advantage.

- Customer facing skills
- Should have experience in Support / Implementation
- Ready to work in shifts including night shift.
- Excellent communication skills
- ODI ELT Modeling and development
- ODI ELT Upgrade and post upgrade expertise
- SQL building and validation

About the Company

Oracle offers an integrated array of applications, databases, servers, storage, and cloud technologies to empower modern business. For most companies, flexibility is critical. Oracle provides a wide choice of software, systems, and cloud deployment models - including public, on-premises, and hybrid clouds - to ensure that technology flexes to the unique needs of a business.

Oracle Cloud is a complete, integrated stack of platform, infrastructure, and application services. With advanced scalability and security, Oracle Cloud enables technical agility across the enterprise, connects people to information for clearer insights, and fosters efficiency through simplified workflows.

More than 420,000 customers across 145 countries have harnessed Oracle technology to accelerate their digital transformation.

Get personalised updates on latest vacancies
Job Alerts by Email
  • Personalised updates on latest career opportunities
  • Insights on hiring and employment activity in your industry
  • Typically sent twice a month