Overview
On Site
DOE
Contract - W2
Skills
Oracle
Unstructured Data
Business Intelligence
Interfaces
Data Integration
Workflow
Scripting
Scheduling
CA Workload Automation AE
Collaboration
Data Quality
Root Cause Analysis
Specification Gathering
Regulatory Compliance
Data Governance
Mentorship
Customization
OBIA
PL/SQL
Unix
Linux
Shell Scripting
ELT
Extract
Transform
Load
Data Warehouse
Job Scheduling
Oracle Data Integrator
Analytical Skill
Conflict Resolution
Problem Solving
Management
Communication
OBIEE
Oracle Cloud
Analytics
Reporting
Version Control
Git
Job Details
Job Summary We are seeking a highly experienced Senior Oracle Data Integrator (ODI) Developer to lead the design, development, and support of complex data integration solutions. This role requires deep expertise in Oracle ODI, PL/SQL, Unix scripting, and data transformation techniques. The ideal candidate will be skilled in handling structured and unstructured data, customizing BI Apps load plans, and ensuring data quality and performance across enterprise systems. Key Responsibilities Design, develop, and maintain ODI interfaces, packages, and load plans for large-scale data integration. Build and manage complex file topologies to support multi-format data integrations. Customize and support Oracle BI Applications (OBIA) load plans, mappings, and workflows. Translate business requirements into scalable ETL/ELT logic using ODI. Develop PL/SQL scripts and use Oracle SQL for data transformation and enrichment. Create reusable mappings and scenarios aligned with performance and best practices. Automate batch jobs using Unix shell scripting and integrate ODI processes with scheduling tools like Autosys. Collaborate with technical and functional teams to resolve data quality issues. Monitor job executions, perform root cause analysis, and implement corrective actions. Document solution designs, technical specifications, and support procedures. Ensure compliance with data governance and integration standards. Mentor junior developers and conduct peer code reviews. Required Qualifications Minimum 6+ years of hands-on experience with Oracle Data Integrator (ODI) 12c. Strong expertise in developing complex file topologies (delimited, fixed-width, hierarchical). Experience customizing Oracle BI Applications (OBIA) load plans and mappings. Proficiency in Oracle SQL and PL/SQL for data operations. Hands-on experience with Unix/Linux shell scripting. Deep understanding of ELT/ETL best practices and data warehousing concepts. Experience with job scheduling tools and ODI batch job integration. Strong analytical and problem-solving skills. Ability to manage multiple priorities independently. Excellent verbal and written communication skills. Preferred Qualifications Exposure to OBIEE, Oracle Cloud, or other analytics/reporting platforms. Familiarity with version control systems such as Git. Education: Bachelors Degree
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.