Oracle Data Integrator (ODI) Developer

Posted on July 3, 2025

Apply Now

Job Description

  • Oracle Data Integrator (ODI) Developer 5+ years Remote Immediate
  • Job Description:
  • We are seeking a skilled and experienced Oracle Data Integrator (ODI) Developer to join our data engineering and analytics team. The ideal candidate will have 3�5 years of hands-on experience in designing, developing, and implementing ELT/ETL solutions using ODI 11g/12c, Oracle databases, and related data integration tools. The role requires proficiency in building efficient data pipelines and supporting enterprise-level data warehouse solutions.
  • Key Responsibilities:
  • Design, develop, and implement robust ELT processes using Oracle Data Integrator (ODI).
  • Create and manage master and work repositories, reverse engineering, knowledge modules (LKM, IKM, CKM, RKM), and data models.
  • Build interfaces, packages, procedures, variables, and scenarios using ODI.
  • Work with relational databases, flat files, and XML to extract, transform, and load data into data warehouses.
  • Perform performance tuning, error handling, and implement incremental data loads.
  • Participate in unit testing, peer reviews, and support the migration process across development, QA, and production environments.
  • Interact with business analysts to understand data requirements and translate them into technical specifications.
  • Support and maintain existing ODI pipelines, troubleshoot production issues, and ensure data integrity.
  • Leverage tools like TOAD, SQL Developer, OBIEE, Salesforce, and other platforms for report generation and dashboarding support when needed.
  • Contribute to best practices, reusable mappings, and process documentation.
  • Required Skills and Experience:
  • 5+ years of overall IT experience, with 3+ years in ODI development.
  • Strong expertise in ODI 11g/12c, Oracle 11g/12c, SQL, and PL/SQL.
  • Proficient in ODI components like interfaces, packages, procedures, variables, knowledge modules.
  • Experience working with data warehouse design, OLAP models, and performance tuning.
  • Knowledge of data integration from multiple sources like Oracle, flat files, XML.
  • Hands-on experience in error handling, static and flow controls, and job scheduling (Standalone/J2EE agents).
  • Familiarity with reporting tools like OBIEE, and dashboard configuration is a plus.
  • Good exposure to production support activities and release management.
  • Strong problem-solving skills, attention to detail, and ability to handle data quality issues.
  • Nice to Have:
  • Experience with Salesforce, Oracle EBS, or other enterprise source systems.
  • Exposure to data modeling concepts (fact/dimensions) and SCDs.
  • Experience working in Agile environments and using tools like VSTS or Jira.
  • Basic familiarity with Ad hoc reporting, user training, and client interfacing.

Required Skills

oracle data integrator (odi) developer