ODI Architect (Capital Market Exp)

TekWissen

• $120K — $150K *
New York, NY 10025In-Person
Information Technology
5 - 7 years of experience
6 days ago
Job Overview by Ladders

Qualifications

  • 6-9 years of experience with Oracle Data Integrator (ODI) 11g for Batch/Real-time Integrations.
  • At least two end-to-end implementations of Oracle Data Integrator 12C.
  • Familiarity with ODI Administration, Load Balancing, and agent configuration.
  • Experience with Change Data Capture (CDC) and slowly changing dimensions (SCD1/SCD2).
  • Proficient in complex transformations and data warehousing concepts.
  • Background in consulting, assessment work, and creating implementation roadmaps.
  • Strong SQL and PL/SQL skills, with experience in on-site/offshore project models.

Responsibilities

  • Design and implement Batch/Real-time ETL integrations using ODI.
  • Configure and manage ODI agents for optimal performance.
  • Develop solutions addressing CDC and dimension management.
  • Conduct requirement gathering to inform ETL design for data warehousing.
  • Review and validate test cases to ensure high-quality deliverables.
  • Optimize ETL jobs for performance improvements.
  • Provide customer management and support throughout projects.

Benefits

  • Opportunities for professional development and skills enhancement.
  • Work in a collaborative team environment.
  • Exposure to a variety of technical challenges in a dynamic field.
  • Flexible working arrangements.
  • Potential for career advancement within a leading organization.
Full Job Description
Title : ODI Architect (Capital Market Exp)

Location : NYC, NY

ETL Design and DW Architectural Exp

- Oracle Data Integrator Developers with Minimum 6-9 years of relevant experience in the implementation of Batch/Real-time Integrations using ODI 11g.

- At least two projects implementation on Oracle Data Integrator 12C from end to end implementations.

- Good to have exposure on ODI Administration and Load Balancing. Should be able to configure Standalone and Java EE agents.

- Exposure to CDC / Journalizing implementations, SCD1, SCD2 and customizing knowledge modules.

- Knowledge on complex transformations

- DWBI Knowledge with Requirement Gathering Skills for ETL Design

- Experience in Consulting and Assessment work and providing the roadmap to Customer for implementation with cost and schedule

- Review Test Cases and ensure quality of the deliverables

- Performance Tuning of ETL Jobs - ETL Test case preparation and data validation

- Worked in on-site/ offshore Model with at least 2 projects - Very Strong Knowledge on SQL and PL SQL

- Customer Management and excellent Communication Skills
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at TekWissen

  • ODI Architect (Capital Market Exp)
    $120K — $150K *
    New York, NY 10025 (New York County)
    6 days ago
    Information Technology
    In-Person
  • Java Developer
    $90K — $130K *
    Stamford, CT 06902 (Western Ct County)
    6 days ago
    Information Technology
    In-Person
  • .Net Developer
    $90K — $120K *
    Chicago, IL 60629 (Cook County)
    6 days ago
    Information Technology
    In-Person
  • PeopleSoft Treasury & Cash Management
    $100K — $130K *
    Portland, OR 97229 (Washington County)
    6 days ago
    Finance & Insurance
    In-Person
  • Tibco Architect
    $110K — $140K *
    Raleigh, NC 27610 (Wake County)
    6 days ago
    Information Technology
    In-Person

More Information Technology Jobs

Find similar ODI Architect (Capital Market Exp) jobs:

NationwideNew York, NY