Oracle Data Integrator (ODI) Developer

Overview

On Site
$60 - $70
Contract - W2
Contract - 12 Month(s)

Skills

Oracle Data Integrator (ODI) Developer
Oracle Data Integrator(ODI) 12c
SQL
Data Warehousing

Job Details

Immediate need for a talented Oracle Data Integrator (ODI) Developer. This is a 12+months contract opportunity with long-term potential and is located in Irving, TX (Onsite). Please review the job description below and contact me ASAP if you are interested.

Job ID: 25-77718

Pay Range: $60 - $70/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

Key Responsibilities:

  • Design, develop, and maintain ODI interfaces, packages, and load plans for large-scale data integration solutions.
  • Build and manage complex file topologies in ODI to handle multi-format structured/unstructured data integrations.
  • Customize and support Oracle BI Applications (OBIA) load plans, mappings, and workflows.
  • Translate complex business requirements into efficient, scalable ETL/ELT logic using ODI.
  • Develop PL/SQL scripts and use Oracle SQL for data transformation, validation, and enrichment.
  • Create reusable mappings and scenarios aligned with best practices and performance standards.
  • Automate batch jobs and scheduling using Unix shell scripting and integrate ODI processes with Autosys.
  • Collaborate with functional and technical teams to identify and resolve data quality issues.
  • Monitor daily job executions, perform root cause analysis of failures, and implement corrective actions.
  • Document solution designs, technical specifications, and support procedures for long-term maintainability.
  • Ensure compliance with data governance, security, and integration standards.
  • Mentor junior team members and perform peer code reviews

Key Requirements and Technology Experience:

  • Key Skills; Oracle Data Integrator (ODI) 12c, SQL, Data Warehousing
  • 6+ years of hands-on experience in Oracle Data Integrator (ODI) 12c.
  • Strong expertise in developing complex file topologies (delimited, fixed-width, hierarchical).
  • Experience with Oracle BI Applications (OBIA), including customization of load plans and data mappings.
  • Proficient in Oracle SQL and PL/SQL for data extraction, transformation, and loading.
  • Hands-on Unix/Linux shell scripting experience.
  • Deep understanding of ELT/ETL best practices, data warehousing concepts, and performance tuning.
  • Experience with job scheduling tools and integration with ODI batch jobs.
  • Exposure to OBIEE, Oracle Cloud, or other reporting/analytics tools.
  • Familiarity with version control systems like Git.

Our client is a leading Retail Industry and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.

Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.

By applying to our jobs you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy .

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.