Overview
On Site
USD 65.00 - 75.00 per hour
Full Time
Skills
Database
Oracle
Business Intelligence
Interfaces
Data Integration
Unstructured Data
Workflow
Scripting
Scheduling
CA Workload Automation AE
Data Quality
Root Cause Analysis
Specification Gathering
Regulatory Compliance
Data Governance
Mentorship
OBIA
Customization
PL/SQL
Data Extraction
Unix
Linux
Shell Scripting
ELT
Extract
Transform
Load
Data Warehouse
Performance Tuning
Job Scheduling
Oracle Data Integrator
Analytical Skill
Problem Solving
Conflict Resolution
Attention To Detail
Management
Communication
Taxes
Life Insurance
Collaboration
Partnership
Business Transformation
Law
Job Details
Description
We are seeking an experienced 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.
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.
Required Skills & Experience:
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.
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.
Pay and Benefits
The pay range for this position is $65.00 - $75.00/hr.
Eligibility requirements apply to some benefits and may depend on your job
classification and length of employment. Benefits are subject to change and may be
subject to specific elections, plan, or program terms. If eligible, the benefits
available for this temporary role may include the following:
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a fully onsite position in Irving,TX.
Application Deadline
This position is anticipated to close on Jul 18, 2025.
>About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
About TEKsystems and TEKsystems Global Services
We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
We are seeking an experienced 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.
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.
Required Skills & Experience:
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.
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.
Pay and Benefits
The pay range for this position is $65.00 - $75.00/hr.
Eligibility requirements apply to some benefits and may depend on your job
classification and length of employment. Benefits are subject to change and may be
subject to specific elections, plan, or program terms. If eligible, the benefits
available for this temporary role may include the following:
Medical, dental & vision
Critical Illness, Accident, and Hospital
401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
Life Insurance (Voluntary Life & AD&D for the employee and dependents)
Short and long-term disability
Health Spending Account (HSA)
Transportation benefits
Employee Assistance Program
Time Off/Leave (PTO, Vacation or Sick Leave)
Workplace Type
This is a fully onsite position in Irving,TX.
Application Deadline
This position is anticipated to close on Jul 18, 2025.
>About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
About TEKsystems and TEKsystems Global Services
We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
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.