Oracle Data Integrator (ODI) Developer - Full Time or Contract

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