Sr. Oracle Data Integrator (ODI) Developer
CBTS - Irving, Texas, United States, 75084
Work at CBTS
Overview
- View job
Overview
Sr. Oracle Data Integrator (ODI) Developer
Sr. Technical Recruiter / Client Partner @ CBTS | Solutions Integrator
Job Title: Senior Oracle Data Integrator (ODI) Developer Location:
Irving, Tx
(MUST BE onsite 5 days a week) Employment Type:
6 months Contract (potential extensions) Rate: W2 or 1099 ONLY (NO 3rd parties) Job Summary: We are seeking an experienced
Senior Oracle Data Integrator (ODI) Developer
to lead the development and support of complex data integration solutions. The ideal candidate will have a strong background in Oracle ODI, including hands-on experience with
complex file topologies ,
BI Apps load plans , and
Unix scripting , along with in-depth knowledge of
Oracle SQL
and
business logic implementation . Required Skills & Experience: 6+ years of hands-on experience
in Oracle Data Integrator (ODI) 12c. 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. Strong analytical and problem-solving skills with attention to detail. Ability to work independently and manage multiple priorities in a fast-paced environment. Excellent verbal and written communication skills. 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. Preferred Qualifications: Exposure to
OBIEE ,
Oracle Cloud , or other reporting/analytics tools. Familiarity with
version control systems
like Git. Seniority level
Seniority level Mid-Senior level Employment type
Employment type Contract Job function
Job function Information Technology Industries Retail Referrals increase your chances of interviewing at CBTS by 2x Inferred from the description for this job
Medical insurance Vision insurance Get notified when a new job is posted. Sign in to set job alerts for “Oracle Specialist” roles.
Dallas, TX $100,000.00-$130,000.00 1 month ago Oracle Fusion Applications Administrator
Associate Developer/Developer, IT Applications
Dallas, TX $104,000.00-$130,000.00 6 days ago Application Support and Service Delivery Engineer
Dallas-Fort Worth Metroplex $110,000.00-$170,000.00 3 weeks ago Dallas-Fort Worth Metroplex $125,000.00-$160,000.00 3 weeks ago Oracle Cloud HCM Techno-Functional Consultant
Oracle Supply Chain Testing Specialist- Hybrid
Dallas, TX $150,000.00-$160,000.00 2 weeks ago Oracle Fusion Cloud Technical Consultant
Plano, TX $165,000.00-$180,000.00 2 weeks ago Senior Application Engineer (Oracle Financials)
Dallas, TX $150,000.00-$170,000.00 2 days ago We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.
#J-18808-Ljbffr