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