Oracle Data Integrator (ODI) Developer

Oracle Data Integrator (ODI) Developer Full Time or Contract

Location: Hyderabad, Telangana, India

Type: Full Time

Min. Experience: Mid Level

Oracle Data Integrator (ODI) Developer – Full Time or Contract
Centroid is seeking an experienced Oracle Data Integrator (ODI) Developer consultant to assist clients with designing and delivering integrations using ODI. 

Term:  6 months with option to renew

 Required Skills
•    Overall having 6+ years of ETL Lead / developer experience and a minimum of 3-4 Years’ experience in Oracle Data Integrator (ODI).
•    3+ years of experience designing, developing, and delivering integrations using Oracle Data Integrator (ODI)
•    5 years of relevant experience in the implementation of Batch/Real-time Integrations using ODI 11g/12c. Must be well versed and hands-on in using and customizing Knowledge Modules (KM)

•     Experience designing and developing integrations to Extract, Load and Transform Data into data warehouses. Strong knowledge of ELT/ETL concepts, design and coding
  •    Expertise developing and supporting Oracle Data Integrator 12c . Build and support data integration and transformation routines from source systems to target data stores using Oracle Data Integrator (ODI)
  •    Knowledge and experience integrating data sourcing from Web Services, REST APIs, SOAP and Databases
  •    Ability to design data quality and reconciliation framework using ODI. Integrate ODI with multiple Source / Target such as Oracle, MS SQL Server, XML files, flat files, MS access/excel documents. Should have strong design and development skills
  •    Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, Mat Views and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle. 
  •    Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.
  •    Must have Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities
  •    Should have experience in developing dimensions and fact tables using ODI.
  
•     Experience in high data volume environments/ performance tuning in ODI.
  •    Must be individual contributor as well as team player. 
  

 Preferred Skills
•    Understanding of Data Warehouse modeling . Experience building, enhancing, supporting data warehouse solutions (primarily using Oracle data warehouse technologies)
•    Experience working with Data Lakes 
•    Hands-on experience with sourcing data from ERP systems integrating Oracle eBusiness Suite and/or Oracle Cloud (Fusion) products with external applications
•    Experience on ODI version 14c would be an added advantage
•    Immediate joiners preferred

Education: Any Graduate or Equivalent