Senior Oracle Developer

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.

• 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.

• 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.

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

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