Back to all Jobs see more Data Science jobs

Oracle Data Integrator

Job Detail

  • Job ID 8039
  • Career Level  Others
  • Experience  6-8 Years
  • Industry  IT & BPM
  • Qualifications  Degree Bachelor

Job Description

About the job:

  • Job Title: Oracle Data Integrator
  • Experience: 6 to 8 years.
  • Location: Pune, Mumbai, Noida, Bangalore, Chennai, Hyderabad.
  • Educational Background: Bachelor’s degree in Computer Science, Information Technology, or a related field.

Role & responsibilities:

  • Technical experience with the development of ETL processes in the Data Warehouse Oracle environment
  • Experience with Oracle ODI.
  • Expert in SQL and PL/SQL.
  • Performs SQL queries – design, code, test, and aggregate the results to create useful information
  • Responsible for building online analytical processes (OLAP) using relational and multidimensional databases Knowledge of Business Intelligence
  • Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI)
  • Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis
  • Advanced SQL statements to interact with a database
  • Experience in profiling source and raw data
  • Define transformation logic of data from business requirements
  • Experience in Python
  • Knowledge of logical and physical database modeling concepts and techniques
  • Understand normalized and star-schema physical models and logical modeling concepts
  • Works on APIs and frameworks to expose data for visualization and study
  • Experience of working with ODI SNP Tables and setting up alerts for data load job failures
  • Experience of working on Production Support project is an added advantage.

Required skills

Configuration skills Development skills Oracle Data Integrator Python SQL

Related Jobs

 
Required 'Candidate' login to applying this job. Click here to logout And try again
 
 
Required 'Candidate' login for send message Click here to logout And try again
 
 

Apply for this Job

  • Drop a resume file or click to upload.
    To upload file size is (Max 5Mb) and allowed file types are (.doc, .docx, .pdf)
    or
    Upload Resume
  • Upload Cover Letter

    To upload file size is (Max 1Mb) and allowed file types are (.doc, .docx, .pdf)

  • By clicking checkbox, you agree to our Terms and Conditions and Privacy Policy

 

Answers

 

Account Activation

Before you can login, you must activate your account with the code sent to your email address. If you did not receive this email, please check your junk/spam folder. Click here to resend the activation email. If you entered an incorrect email address, you will need to re-register with the correct email address.