ODI Developer (Oracle Data Integrator) - Newport Beach, CA - Onsite

[Jagadeesh Matheshwaran]

Hi,

Position: ODI Developer (Oracle Data Integrator)

Location: Newport Beach, CA - Onsite

Duration: 12+ Months

Client: TCS/ Pacific Life

Must have Competency :

9+ years of proven experience in design and development of Data Warehouse solutions, ETL, Software Development

and system integration projects

Minimum 6 yrs of strong exp in Oracle Data Integrator(ODI) with knowledge of data modeling and ETL design

Minimum 3-4 yrs of strong exp in OBI-APPS(Financials analytics modules)

Must have 1-2 yrs of exp in OBIEE

Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure

Good knowledge of Enterprise application data structure(Oracle Peoplesoft)

Experience of performance tuning of mappings and able 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

Strong knowledge and exp 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 achieve results effectively and professionally

Strong follow-up skills: ability to organize applicable department timelines and follow up with internal and external customer needs

Strong organization skills, ability to accomplish multiple tasks within the agreed upon timeframes 

through effective prioritization of duties and functions in a fast paced environment.

Good to have :

Flexible work timings

Participate in day-to-day aspects of a formal Agile/Scrum process, including contributing to 

Agile meetings(backlog, planning, review, retrospectives, and daily stand-ups).

Experience with ITSM tools like ServiceNow

Must be able to work with Business Customers, Line Managers, project managers, Business Analysts and

Subject Matter experts in a professions an collaborative manner to define strategies and implementation approaches

Role description /expectations from the role:

Work on ITSM tool - Servicenow

Daily Operations - Solving L2/L3 level tickets

Technical/Functional Gap Assessment and Resolution

Expertise to train staff on Module specific knowledge

Build an internal wiki with technical documentation, manuals, and IT policies.

Team leadership activities include mentoring Jr support technicians

Details of the project :

Customer is an American Insurance company providing life insurance products, annuities, and mutual funds, and 

offers a variety of investment products and services to individuals, business, and pension plans.

Recognized as a leader in the financial services industry with more than 150 yrs of exp and 

has been listed in the Forbes fortune 500 companies.

Thanks & Regards

 

Jagadeesh Matheshwaran | Technical Talent Acquisition Specialist

+1 (586) 500-6670 | jagad...@twsol.com

Disclaimer

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to which they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.