Job Description

SUMMARY:

- Oracle Data Integrator (Developer/Support Specialist) is responsible for developing medium to complex ODI interfaces and able to resolve production ODI tickets and load monitoring.
- Should be able to quickly diagnose and resolve data reconciliation issues, failure of ODI components (Load Plans, Packages, Interfaces) in ODI 11g and ODI 12c .

Skills:

- 5 to 8 years of proven experience in design and development of Data Warehouse solutions, ETL, Software Development and system Integration projects.
- Mandatory : 2 years of experience in BIAPPS Financial Analytics (ODI ETLs).
- Minimum 2 – 4 years of experience in supporting complex data warehouse projects using ODI and Oracle technologies.
- Positive querying skills on Oracle database with ability to understand and debug PL/SQL procedure.




- 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 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 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 organizational skills, ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast-paced environment.

📌 ODI Developer (Gurugram)
🏢 Apps Associates Private
📍 Gurugram