KPMG India

Oracle Analytics ETL Associate Consultant

15 April 2024
Apply Now
Deadline date:
£30000 - £56000 / year

Job Description

Requirement 

  • Candidate should have the ability to perform in a dynamically changing environment
  • Hands-on experience in ODI versions 11g and 12c
  • Strong Sql & PLSql Knowledge
  • Hands-on experience in developing Procedures, User Functions, Mappings and Packages in ODI 
  • Hands-on experience in Custom ODI development projects or Oracle BIAPPS Implementation projects
  • Hands on experience using SOAP / REST technologies using ODI
  • Knowledge on Accounting Hub is an added advantage
  • Knowledge in Integrating multiple Source systems, Legacy systems in ODI
  • Relevant experience for 4-7 years
  • Should have minimum 2 years of experience on end-to-end implementation projects
  • Having Certification on any Oracle Technology is an added advantage
  • Experience in OCIDI / Data Transforms will be an added advantage.
  • Having Oracle Reporting Knowledge will be an added advantage

Roles and responsibilities

The responsibilities of the role include:

  • Responsible for developing technical solutions in Oracle Data Integrator for multiple Source Systems
  • Knowledge on integrating ODI with various Cloud Technologies like BICCC, BI Publisher and Object Storage
  • Knowledge in Loading data to ADW/ATP Database
  • Good Knowledge of ETL/ELT functionalities and Data warehouse concepts
  • Responsible for Converting the Business use cases to Technical Requirements suitable for Data warehousing & Integration Projects
  • Responsible for preparing the Technical Design Documents 

Experience & Background 

  • Graduate/Post-Graduate qualification B.Tech./BCA/MBA/M-Tech/MCA
  • Relevant experience for 4-7 years
  • Excellent Communication Skills