Oracle Data Integrator (ODI) Developer

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.

Educational Qualification:

B.Tech in Engineering or equivalent in Computer Science/IT or related fields.

POINTS TO NOTE:

1.DOJ should be in between 0 to 15 Days