Overview
Skills
Job Details
Job Title: Senior Oracle Data Integrator (ODI) Developer Location: Irving, Tx Employment Type: Contract Experience: 8+ years
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.
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.
Preferred Qualifications:
- Exposure to OBIEE, Oracle Cloud, or other reporting/analytics tools.
- Familiarity with version control systems like Git.
Where is the candidate required to work?: Onsite
How many days in a week must contractor work onsite? (If Applicable): 5
What office will the contractor work from (If you don't have a preference select both)? (If Applicable):
Irving, TX
* Interview Mocha Testing: Oracle Data Integration Test ODI + SQL + Data Warehousing