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.No Hyderabad/Telangana/AP/JNTU University/Nagarjuna University profiles.