Business Intelligence Consultant with experience in ODI and SQL. OBIA will be an added advantage Essential Skills – Technical and Functional ODI Consultant with experience in ODI concepts, SQL, data warehousing and modeling. Experience in OBIA modules such as Finance, Human Resources, Projects, Procurement and Expenditure would be an added advantage.
– Customer facing skills
Should have support/implementation experience
– Ready to work in shifts including night shifts.
– Excellent Communication Skills
– ODI ELT modeling and development
– ODI ELT upgrade and post-upgrade experience
SQL build and validation
Experience in ODI ELT tool development such as interfaces/mappings, packages, scenarios, variables, actions and load plans. Excellent SQL building skills. Experience upgrade from ODI older version to 12c. Troubleshoot ELT issues and roll back up to the source layer. Performance tuning capabilities.
Support functional technical system, configuration, technical/technical design of custom solution and integration.
Experience in all aspects of the system – development, support, upgrade, testing, and pre- and post-implementation activities.
Should be able to independently design and develop new teaching lectures or modify existing ones using ODI.
Has experience in writing code efficiently, optimizing and understanding performance tuning techniques in ODI.
Should be able to research, analyze and provide solutions for improvements/development.
Work with the product support team as needed. Knowledge of My Oracle Support is required.
Perform ELT developer tasks related to project implementation and promotion.
– ELT support – break/repair support,
Monitor performance and logs of ODI ELT load plans.
– Monitor daily ELT data loads,
Minor improvements – including changes and tweaks to scripts, minor ELT tweaks, and creation/modification of ETLs.
Take personal responsibility for continuous process improvement.
Oracle offers an integrated suite of applications, databases, servers, storage, and cloud technologies to enable modern businesses. For most companies, flexibility is critical. Oracle provides a wide range of software, systems, and cloud deployment models—including public, on-premises, and hybrid clouds—to ensure technology is resilient to the unique needs of businesses.
Oracle Cloud is a complete, integrated suite of platform, infrastructure, and application services. With advanced scalability and security, Oracle Cloud enables technical flexibility across the enterprise, connects people to information for clearer insights, and drives efficiency through streamlined workflows.
More than 420,000 customers in 145 countries have used Oracle technology to accelerate digital transformation.