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:
5to 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.
Good 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 followup 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 fastpaced environment.
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.