Senior IT Architect - Oracle Technical

Johnson Electric; Chennai District; On-site; INR 1,200,000 - 2,400,000; Full time

Job summary

Johnson Electric is seeking an experienced Oracle EBS developer to implement and customize ERP solutions across finance, manufacturing, and supply chain modules. The role requires hands-on PL/SQL, SQL scripting, and Oracle Forms/Reports development in the R12.2 environment.

The candidate will lead technical design, perform unit testing, assist FAT/UAT, and support global projects across Europe and the Americas, with strong English communication and optional Mandarin.

Qualifications

• 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 API...etc. 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

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 Electric’s 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

Skills

Oracle EBS

PL/SQL

SQL scripting

Oracle Forms

Reports

XML Publisher

OAF personalization

RESTful API

Workflow

Form personalization

Debugging tools

SQL optimization

Interface tables

Oracle upgrade

Technical solution design

Tools

XML Publisher

OAF Personalization

RESTful API

Workflow

Form Personalization

Job description

**Roles & 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 Electric’s 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**Academic & Personal Qualification*** 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 API...etc. 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