particularly in Procurement, Budget and Financials modules
oMust have good knowledge on :
ï¼Understanding of entity-relationship diagrams, and can read and understand the Technical Reference Manuals
ï¼Understanding of the Oracle E-Business Suite database schema, for a range of application modules.
ï¼Understanding of basic database concepts : e.g., instance, table, table space, data files, database structure, indexes to fine tune programs and solve program failures.
ï¼Understanding of basic Unix Operation system concepts, programs, directory structure and basic commands (e.g., vi, sh)
ï¼Familiarity with the technical aspects of Unix, the Oracle RDBMS, and tools
ï¼Knowledgeable in Oracle E-Business Suiteâs system administration tasks, e.g., define users, application responsibility, register functions, menus and procedures.
ï¼Knowledgeable in Oracle's object deployment process using FNDLOAD (e.g. concurrent programs, reports, menus, functions, templates, request groups, responsibility, etc.)
oSolid years of experience in Oracle Workflow.
oSolid years of experience in Oracle Reporting Tools (e.g. XML Publisher, Oracle Reports Builder, html Reporting)
oSolid years of experience in data analysis, data integration, data conversion / migration
oAdvanced experience in using interface files such as generating and / or loading data from spreadsheets, text files, etc.
oConsiderable years of experience in Documentation (e.g. MD050, MD070)
oFamiliarity with ADB Financial applications such as iFirst, iMatch, CLASS, Cash Management is an advantage
oFamiliar with the use of version control (e.g. SVN, CVS)
oAbility to mentor team members on data base concepts, ETL, and data integration.
oAdvanced experience in loading data from spreadsheets, text files, etc.
oSolid years of experience and advanced knowledge in Oracle PL / SQL; can create complex sql scripts