# Oracle Data Integrator (ODI) Consultant — SonsoftInc

- Location: Baltimore, MD
- Posted: Dec 21, 2016
- Status: open (checked Nov 21, 2026)
- Apply (employer's site): https://jobs.smartrecruiters.com/sonsoftinc/104333623
- Employer record: https://visajobs.io/company/sonsoft.md

## Sponsorship history
- Tier: Employer history only
- With this exact title: 0
- Staffing / consulting firm: 100% of its H-1B applications place workers at client sites (FY2024–FY2026)

## Description
Job Description
Oracle Data Integrator (ODI) consultant with overall experience of 4 years and 3+ years of relevant experience in the implementation of Batch/Real-time Integrations using ODI 11g.
Ability to customize knowledge modules as per the requirement.
Should have strong design and development skills.
Ability to design and develop Interfaces, Packages, Load plans, user functions, variables and sequences in ODI.
Understanding of ODI/ODQ administration, maintenance and configuration skills.
Experience working with multiple source/target systems such as Oracle, MS SQL Server, XML files, flat files, MS access/excel documents..
Exposure to OLAP, OLTP, Data warehouse, Data mart development, Fact and Dimensional DB designs..
Should have experience in developing dimensions and fact tables using ODI.
Experience in high data volume environments/ performance tuning in ODI.
Good to have exposure on ODI Administration and Load Balancing.
Should be able to configure topology for all the technologies.
Should be able to configure Standalone and Java EE agents.
Exposure to CDC / Journalizing implementations and customizing knowledge modules.
Experience in Modelling (logical and Physical) Warehouse and Marts Strong database design, relational and dimensional data modelling.
Experience in writing complex queries, Stored Procedures in PL/SQL.
Experience with UNIX Operating System , Windows Systems.
Experience on ODI version 12c would be an added advantage
Qualifications
Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.
At least 4 years of experience within the Information Technologies.
Additional Information
** U.S. citizens and those authorized to work in the U.S. are encouraged to apply . We are unable to sponsor at this time.
Note:-
This is a Full-Time Permanent job opportunity for you.
Only US Citizen, Green Card Holder, GC-EAD , H4-EAD & L2-EAD can apply.
No OPT-EAD, TN Visa & H1B Consultants please.
Please mention your Visa Status in your email or resume .

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
