Oracle Data Integrator Developer

IT Teams is a Romanian company specialized in software outsourcing and remote staffing. We aim to assemble passionate experts to help companies and startups achieve success. We deliver the perfect combination of technical skills, methodology and high speed delivery techniques to help startups and established companies extend their development teams.

 

Apply now »

Job Openings

Oracle Data Integrator Developer

Oracle Data Integrator is responsible for developing medium to complex ODI interfaces by using various transformation packages and knowledge modules. Should be able to diagnose and debug data reconciliation issues and identify the fixes.

Long Term

Remote

8 hours per day

Asap, November 2021

ESSENTIAL FUNCTIONS ON BELOW ODI TASKS:

  • • 5 to 8 years of proven experience in design and development of Data Warehouse solutions, ETL, Software Development and system Integration projects.
  • • Minimum 3 years of strong experience in Oracle Data Integrator (ODI) with knowledge of data modeling and ETL design.
  • • Must have worked on end to end implementation of DW and BI projects.
  • • Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure. 
  • • Design and develop mappings, Process Flows and ETL scripts.
  • • Experience of performance tuning of mappings.
  • • Ability to tune mappings at ETL level and provide suggestion of tuning at database level.
  • • Ability to design ETL unit test cases and debug ETL Mappings.
  • • Experience in the Development of topology setup, Load Plans, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs. 
  • • Managing Files, Oracle DB, XML’s through ODI
  • • Create Load-Plans and schedule the same.
  • • Create email notifications to monitor load schedules and to alert on exceptions and error.
  • • Must be well versed and hands-on in using and customizing Knowledge Modules (KM) IKM, LKM, CKM and RKM.
  • • Strong knowledge and experience and implementation of Oracle Data warehouse concepts SCD, Aggregates, Hierarchy tables, Snapshot fact tables etc.
  • • Ability to work with functional groups and different level of employees to effectively and professionally achieve results
  • • Strong follow-up skills; ability to organize applicable department timelines and follow up with internal and external customer needs
  • • Strong organizational skills, ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast paced environment

 

EDUCATION AND EXPERIENCE:

  • • Preferably from a services organization background with prior experience in Onsite-Offshore model.

 

SOFT SKILLS 

  • • Excellent written and verbal communication skills
  • • Detail oriented, able to multitask and meet deadlines
  • • Self-motivated, able to work in a team and independently

 

Apply now »
Screenshot 2018-10-12 at 01.45.47

Why IT Teams:

We are driven by curiosity so we conduct a Discovery Process, ensuring that the technology we deliver stays in tune with customer’s business goals. We encourage our team members to speak up, to share their advices and worries if any, so we are able to properly handle the software development projects risks. Honesty is a key ingredient of our collaboration with customers as well with our colleagues. Our Commitment towards customer goals is reflected by our regular progress reporting, a constant revision of project goals and deadlines and a solid quality control.

Apply now »