Job Title: Oracle Data Integrator (ODI) Developer / Data Warehousing

Location: Boston, MA

Duration: 12+ months

Emp. Type: 1099/W2

Job Description:

Minimum 8 plus years hands on experience in Knowledge of Data Warehousing such as dimensional modeling, Star and Snowflake schemas, Data mart and Fact, Dimension tables, Slowly Changing Dimensions -Type I & II & III.

Person must have extensive knowledge of ODI with at least 5 years of experience using ODI and Oracle PL/SQL.  In addition, candidate should have data migration experience. Experience in Oracle Warehouse builder is a plus.

Must be fully proficient in writing scalable and high volume ELT jobs for large volume data warehouses.

Must have a very good understanding of the ODI Architecture and setting up agents on Oracle WebLogic Server, Setting up Master and Work repositories.

Must have a solid experience in creating Interfaces to move data from source to target schema. Must be experienced in creating and writing cleansing routines to work with ODI Interfaces while creating load plans.

Experience in setting up Topology in complex environments is a must. Manage and monitor production ETL Manage and monitor non-production ETL sessions and ascertain success of steps or failures with root cause analysis.

Understand & be able to tailor Knowledge Modules.

Design and develop the architecture for all data warehousing components (e.g. source system data ELT strategy, data staging, movement and aggregation; information and analytics delivery; and data quality strategy)

Setting up, debugging and implementing end-to-end ETL jobs. Do performance tuning of ODI ELT Mappings. Develop unit, system, and integration test plans

 

Please mention the job Title in the subject line: "Oracle Data Integrator (ODI) Developer / Data Warehousing "

Please rush your resumes to mail to: careers@iormyx.com

<mail to: careers@iormyx.com>