ODI Developer

Cambay; Chicago (IL); On-site; USD 90,000 - 115,000; Full time

Job summary

Cambay is seeking an experienced ODI Developer in Chicago, IL. The role requires 6+ years of experience in large enterprise Data Warehouse/ETL environments. Responsibilities include developing ETL designs and maintaining Oracle Data Integrator implementations.

The ideal candidate should possess strong communication skills and have expertise in SQL and PL/SQL. Experience with Golden Gate Technologies and OBIEE is preferred. This is a full-time position.

Qualifications

• 6+ years of experience with large enterprise Data warehouse / ETL environments.
• Strong experience with Oracle Data Integrator, SQL, and Oracle PL/SQL.
• Expert level skills in ODI development.

Responsibilities

• Develop and maintain ETL designs from both logical and physical perspectives.
• Interact with clients and coordinate with offshore teams.
• Implement best practices for data integration and reporting.

Skills

Oracle Data Integrator

SQL

Oracle PL/SQL

ETL design

Golden Gate Technologies

OBIEE

Change Data Capturing

Client interaction skills

Communication skills

Offshore coordination

Tools

Microsoft SQL Server

Oracle 10g RAC

SAP Crystal Reports

SAP Business Objects

SAP Crystal Reports Dashboard

Job description

Cambay Consulting Business Intelligence Consulting Services comprise low‑risk, high‑impact, short‑cycle diagnostic and assessment studies that facilitate the execution of a client organization’s BI/DW initiative at its various lifecycle stages. The Business Intelligence Solutions practice helps clients articulate problem definition and then propose alternate solutions and best practices, and recommend an implementation plan. The deliverables enable clients to take quick and well‑informed decisions for the success of the BI/DW initiative.

Our area of focus in BI Technology to develop Agile and economic solutions is using the following products:

• Microsoft SQL Server 2008 R2
• SSIS - SQL Server Integration Services
• SSRS - SQL Server Reporting Services
• SSAS - SQL Server Analysis Services
• Oracle 10g RAC
• SAP Crystal Reports
• SAP Business Objects
• SAP Crystal Reports Dashboard

Job Description

ODI Developer

Location: Chicago, IL

Employment: Full‑time

• Must have about 6+ years of experience with large enterprise Data warehouse / ETL environments
• Must have strong experience with Oracle Data Integrator (ODI: formerly known as Sunopsis), SQL and Oracle PL/SQL
• Must have experience in ETL designs from both a logical and physical perspective
• Must have expert level skills in ODI development
• Experience in Golden Gate Technologies is preferred
• Hands‑on experience in OBIEE is preferred
• Experience on ODI CDC (Change Data Capturing) is preferred
• Should have good client interaction skills
• Should possess good communication skill and excellent offshore co‑ordination abilities

Additional Information

All your information will be kept confidential according to EEO guidelines.