Senior Oracle Developer

Motion Recruitment; Irving (TX); On-site; USD 100,000 - 130,000; Full time

Job summary

A leading IT staffing firm in Irving, TX is seeking an experienced Senior Oracle Data Integrator (ODI) Developer for a 6-month contract role. The ideal candidate will have over 6 years of experience with ODI 12c, strong skills in Oracle SQL and PL/SQL, and a proven ability to manage complex data integration solutions. Responsibilities include designing ODI interfaces, scripting in Unix, and collaborating with teams to address data quality issues.

Qualifications

• 6+ years hands-on experience with Oracle Data Integrator (ODI) 12c.
• Experience with Oracle BI Applications customization.
• Strong analytical and problem-solving skills.

Responsibilities

• Design, develop, and maintain ODI interfaces, packages, and load plans.
• Automate batch jobs and scheduling using Unix shell scripting.
• Monitor job executions and perform root cause analysis.

Skills

Oracle Data Integrator (ODI) 12c

Oracle SQL

PL/SQL

Unix/Linux shell scripting

Data warehousing concepts

Analytical and problem-solving skills

Excellent communication skills

Tools

Job scheduling tools

Git

Job description

Overview

Senior Oracle Data Integrator (ODI) Developer – Offshore Recruiter role for Motion Recruitment

Location: Irving, TX

Duration: 6-Month Contract (with potential for extension or conversion)

• We are seeking an experienced ODI Developer to lead the development and support of complex data integration solutions.

Responsibilities

• Design, develop, and maintain ODI interfaces, packages, and load plans for large-scale data integration.
• Build and manage complex file topologies for multi-format structured and unstructured data.
• Customize and support Oracle BI Applications load plans, mappings, and workflows.
• Translate complex business requirements into scalable ETL/ELT logic using ODI.
• Develop PL/SQL scripts and utilize Oracle SQL for data transformation and validation.
• Create reusable mappings and scenarios following best practices.
• Automate batch jobs and scheduling using Unix shell scripting and integrate with job scheduling tools.
• Collaborate with teams to identify and resolve data quality issues.
• Monitor job executions, perform root cause analysis, and implement corrective actions.
• Document solution designs, technical specs, and support procedures.
• Mentor junior developers and conduct peer code reviews.

Required Skills

• 6+ years hands-on experience with Oracle Data Integrator (ODI) 12c.
• Experience with Oracle BI Applications customization.
• Strong Oracle SQL and PL/SQL skills.
• Hands-on Unix/Linux shell scripting experience.
• Understanding of ELT/ETL best practices and data warehousing concepts.
• Experience with job scheduling tools and batch job integration.
• Strong analytical and problem-solving skills.
• Excellent communication skills and ability to manage priorities in a fast-paced environment.

Desired Skills

• Exposure to OBIEE, Oracle Cloud, or other analytics tools.
• Familiarity with version control systems like Git.

How to Apply

If you’re interested or want to learn more, please send your updated resume or message me directly!