Oracle Technical Consultant

Role & responsibilities

• Perform development according to requirement specification (MD050) and follow JE development standard and version control procedure
• Prepare Program Migration Steps, Technical Specification (MD070) and Unit Test Report (TE110) according to JE development standard
• Perform Program Unit Test and assist in Problem solving during Functional Test (FAT) and User Acceptance Test (UAT)
• Provide Technical Advice or Assistance to Johnson Electrics development team
• Assist Oracle Functional colleagues to investigate and fix issue during different phases of project
• Perform quality check of program and ensure it is in good quality and meet IT internal standard

Preferred candidate profile

• Solid experience on development for flow manufacturing, discrete manufacturing, Inventory, Bill of Material and finance modules (e.g. AR, AP, GL, Costing etc.) on Oracle EBS R12.2 , prefer to be on the latest release R12.2.10

• Solid experience on develop Oracle ERP customizations such as forms, reports, PL/SQL, SQL script, Workflow, XML Publisher, Form personalization, OAF personalization, RESTful APIetc. on R12.2

• Strong knowledge in using Oracle related debugging tools to debug and analyze the program and have certain SQL optimization experience, familiar with common use API and interface table on R12.2

• Solid experience of Oracle upgrade from Oracle Release R12.1 to Release R12.2 is a must

• Strong experience of Oracle implementation in Europe and Americas by providing technical solution design

• Proficient to provide effective and good technical solution design to meet the functional requirements, and able to document properly

• Fluent English written and spoken is required for the position, spoken Mandarin an advantage