Data Engineer jobs

Oracle Data Integrator (ODI) Consultant

Sonsoft Inc (agency)Baltimore, MDFull-time

Pay not listed

Key facts

Experience
4+ years
Degree
Bachelor's degree
US visa
No US visa sponsorship

2 things to check before you apply.

On Sonsoft Inc’s own careers site (SmartRecruiters), checked open today.

  • To check: Posted by the employer 9 years agoLong-open jobs are sometimes already filled. Ask when they plan to hire.
  • To check: No pay range listed, though one is likely required in MDAsk for the pay range before you interview. The law here likely requires one.
  • Checked: On the company's own careers siteSmartRecruiters board
  • Checked: Checked open todaySmartRecruiters board
  • Checked: No reposts foundSmartRecruiters board
  • Trust score 55 / 100 · Check details
See all 6 checksShow fewer
How we check

What you’ll do

  • Implement batch and real-time integrations using ODI.
  • Design and develop ODI interfaces, packages, load plans, user functions, variables, and sequences; customize knowledge modules.
  • Configure ODI topology and standalone and Java EE agents, and support ODI administration and maintenance.
  • Develop warehouse and mart models, dimensions, and fact tables across multiple source and target systems.

Summarised from the posting by AI and can be wrong. The full description is the source.

Requirements

Experience

  • 4 years of overall experience, including 3+ years of relevant experience implementing batch and real-time integrations using ODI 11g
  • ODI/ODQ administration, maintenance, and configuration experience
  • Experience with multiple source and target systems, including Oracle, MS SQL Server, XML files, flat files, MS Access, and Excel
  • Exposure to OLAP, OLTP, data warehouse and data mart development, and fact and dimensional database designs
  • Experience developing dimensions and fact tables using ODI
  • Experience in high-data-volume environments and ODI performance tuning
  • Exposure to CDC/journalizing implementations and customizing knowledge modules
  • Experience in logical and physical modeling of warehouses and marts, and in relational and dimensional data modeling
  • Experience writing complex queries and stored procedures in PL/SQL
  • Experience with UNIX and Windows operating systems
  • Exposure to ODI administration and load balancing (preferred)
  • Experience with ODI version 12c (preferred)

Skills

  • Ability to customize ODI knowledge modules
  • Strong design and development skills
  • Ability to design and develop ODI interfaces, packages, load plans, user functions, variables, and sequences
  • Ability to configure topology for all technologies
  • Ability to configure standalone and Java EE agents

Your match

Sign in and add your resume to see which of this job's requirements it shows.

Sign in to check your match

Saved to your account, encrypted. The AI that reads it doesn't keep it or train on it.

Full job description

From Sonsoft Inc’s careers site

Company Description

SonSoft is an IT Staffing and consulting firm and duly organized under the laws of the Commonwealth of Georgia. We are growing at a steady pace specializing in the fields of Software Development, Software Consultancy and Information Technology Enabled Services.

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.
Show full descriptionShow less
  • 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.

Something wrong with this job? Report it · This flag looks wrong

Similar jobs nearby

Senior Data Engineer

Sinclair Broadcast Group · Hunt Valley, MD

$102k–$136k/yrFull-timeOn-site

StrongOpen 2 monthsChecked open todayPosted 2 months ago

Data Integration Systems Engineer 686

Freedom Technology Solutions Group · Annapolis Junction, MD +1 place

$160k–$210k/yrHybrid

StrongOpen 4 monthsChecked open todayPosted 5 months ago

Senior System Engineer

Belay Technologies · Columbia, MD

$168k–$240k/yrFull-time

StrongChecked open todayPosted 20 days ago

Data Engineer

Black Canyon Consulting · Bethesda, MD

StrongPay not listedChecked open todayPosted 1 month ago

Data Engineer

Analytica · Bethesda, MD

Full-timeHybrid

Looks goodPay not listedChecked open todayPosted 3 days ago

See more like this