Job id : 42456
ODI / OBIA Specialist
ODI / OBIA Specialist
Bangalore
2 years ago
JOB ID:42456
Job details
Job Type
Full Time
Functional Area
Database Administrator/ Data warehousing
Industry
IT-Software/Software Services
Education
Not Specified
Experience Required
5 - 10 Yrs
Key Skills Required
sql, plsql, data guard, data center, odi 11g/12c., oci, saas, paas
Other Skills Required
Job Description
ODI / OBIA Specialist:
- Candidate must have 5 to 10 years of experience of design and implementation of Data Warehousing and Business Intelligence applications, of which last 2 years must be on Cloud.
- Candidate must have good understanding of Oracle Cloud platforms - OCI, SaaS and PaaS.
- Should have designed the database using Dimensional Modeling.
- Data Integration Experience - Strong ELT / ETL expertise using ODI 11g/12c.
- Must have worked on Packages, Interfaces / Mappings, Procedures, Scenarios and Load Plans, ability to invoke Web Services from ODI and must have used Databases (running in both On-Prem and Cloud environments), Files and XML as data sources.
- Be able to setup topologies, create mappings, packages, scenarios, load plans. Be able to synchronize data from On-Premise data sources to Cloud and vice-versa.
- Should be able to create and deploy ODI Packages and Scenarios across multiple environments.
- It is preferred that candidate be experienced on Oracle Business Intelligence Applications (
ODI / OBIA Specialist:
- Candidate must have 5 to 10 years of experience of design and implementation of Data Warehousing and Business Intelligence applications, of which last 2 years must be on Cloud.
- Candidate must have good understanding of Oracle Cloud platforms - OCI, SaaS and PaaS.
- Should have designed the database using Dimensional Modeling.
- Data Integration Experience - Strong ELT / ETL expertise using ODI 11g/12c.
- Must have worked on Packages, Interfaces / Mappings, Procedures, Scenarios and Load Plans, ability to invoke Web Services from ODI and must have used Databases (running in both On-Prem and Cloud environments), Files and XML as data sources.
- Be able to setup topologies, create mappings, packages, scenarios, load plans. Be able to synchronize data from On-Premise data sources to Cloud and vice-versa.
- Should be able to create and deploy ODI Packages and Scenarios across multiple environments.
- It is preferred that candidate be experienced on Oracle Business Intelligence Applications (OBIA) using ODI as Data Integration tool. Should have the ability to implement Out of the box solution and customize the OOTB solution to meet the client requirements.
- Experienced on Oracle database writing SQL and PL/SQL code using packages, procedures and functions.
- Must have worked on performance tuning at various layers in order to optimize the applications throughput.
- Should have excellent debugging and troubleshooting skills and be able to perform root cause analyses.
- Should have excellent verbal, written communication and presentation skills.
- Experience in interacting with the clients to gather requirements and analyze the data flow process.
- Independently identify areas of improvement and makes recommendations.
About Company
Oracle is the world’s leading provider of business software. But you probably already knew that. With a presence in over 175 countries, we are one of the biggest technology companies on the planet. What you might not know is that we are leading a cloud revolution.
We’re using emerging technologies like AI, machine learning, and blockchain to solve critical real-world problems. From advancing energy efficiency to reimagining online commerce, the work we do is not only transforming the world of business—it’s helping governments, powering nonprofits, and giving billions of people the tools they need to outpace change and make a difference.
We’re using emerging technologies like AI, machine learning, and blockchain to solve critical real-world problems. From advancing energy efficiency to reimagining online commerce, the work we do is not only transforming the world of business—it’s helping governments, powering nonprofits, and giving billions of people the tools they need to outpace change and make a difference.
Recommended Companies
Recommended Events
