Oracle Applications Lead Technical Consultant
Johnson Controls · Bengaluru East, Karnataka, India
- On site
- Full-time
- $150,000 / year
- Bengaluru East, Karnataka, India
Job highlights
- Lead Oracle R12 ERP technical aspects.
- Develop, customize, and support Oracle EBS.
- Resolve complex technical issues and bugs.
- Collaborate with functional teams and users.
- Mentor junior technical team members.
About the role
Oracle R12 ERP Technical Lead
We are seeking a highly experienced Oracle R12 ERP Technical Lead to join our dynamic team at Johnson Controls. The ideal candidate must provide technical expertise and support for Oracle EBS applications, including development, customization, and maintenance, focusing on areas like PL/SQL, reports, forms, and integration. A strong background in application development, deployment, and production support processes is essential. The candidate should also possess good knowledge of one or more ERP functional modules.
Key Responsibilities
- Provide subject matter expertise on Oracle EBS Development and Integration Tools.
- Lead production support for Oracle EBS Application Technical issues, identifying and resolving complex issues while supporting end users.
- Support third-party interfaces and ensure data integrity.
- Troubleshoot and resolve technical issues in Oracle EBS applications, identifying root causes and implementing effective solutions.
- Provide technical support to end users on Oracle EBS applications, addressing queries and resolving issues.
- Maintain accurate and up-to-date documentation of system configurations, processes, and troubleshooting procedures.
- Contribute to the development and maintenance of a knowledge base for easy access to information.
- Collaborate with clients, technical teams, and other stakeholders to ensure smooth application management.
- Develop high complexity SQL scripts to extract ERP data for analysis.
- Proactively identify opportunities for improvement in application performance, processes, and user experience.
- Participate in the development and implementation of new enhancements.
- Collaborate with cross-functional teams to gather and document business requirements.
- Design and configure Oracle EBS solutions to meet specific business requirements.
- Collaborate with EBS functional teams to deliver robust solutions.
- Support Functional Consultants with the implementation of Oracle EBS modules.
- Develop, modify, and customize Oracle EBS modules, forms, reports, and workflows to meet specific business needs.
- Design and develop SQL Scripts for data extraction based on STTM mapping (Source to Target ERP mappings) from or to Oracle EBS functional modules.
- Provide technical guidance and mentorship to junior team members.
Requirements
- Bachelor’s degree in Computer Science or Information Technology.
- 15+ years of experience working with R12 ERP applications with a focus on EBS Technical skills like PL/SQL, SQL, Oracle Forms, Oracle Reports, and other relevant tools.
- Strong experience in Oracle EBS development, customization, and support.
- Proficient in Business requirement analysis, Gap identification, Solution proposals, and Design development.
- Strong understanding of Oracle EBS Technical architecture.
- Understanding of Oracle EBS modules (Order Management, Procurement etc.).
- Excellent problem-solving skills and attention to detail.
- Ability to diagnose and resolve technical issues and provide effective solutions.
- Excellent communication and collaboration abilities to work with functional teams and business users.
- Experience with Oracle Applications Framework (OAF).
- Experience with Oracle Workflow.
- Experience in SQL performance tuning.
- Experience in building, supporting, and troubleshooting integrations.
- Experience in code repository/version management systems implementation in high-paced environments with multiple simultaneous projects and support activities.
Preferred Qualifications
- Certification on Oracle Financials (preference to Oracle R12).
- Experience with Oracle Cloud implementations is a plus.
- Experience with SDLC/Agile methodologies and project management tools.
Key skills/competency
- Oracle EBS
- PL/SQL
- SQL
- Oracle Forms
- Oracle Reports
- ERP Technical Lead
- Application Support
- Integrations
- Data Migration
- Business Requirements Analysis
Skills & topics
- Oracle EBS
- PL/SQL
- SQL
- Oracle Forms
- Oracle Reports
- ERP Technical Lead
- Application Support
- Integrations
- Data Migration
- Business Requirements Analysis
- Oracle R12
- Technical Consultant
- ERP
How to get hired
- Tailor your resume: Highlight your 15+ years of Oracle R12 ERP experience, emphasizing PL/SQL, SQL, Oracle Forms, Reports, OAF, and Workflow.
- Showcase leadership: Detail your experience leading production support, mentoring junior members, and collaborating with cross-functional teams.
- Quantify achievements: Provide specific examples of complex issues resolved, integrations built, and data migrations completed.
- Prepare for technical questions: Be ready to discuss Oracle EBS architecture, module understanding, SQL performance tuning, and integration troubleshooting.
- Demonstrate business acumen: Highlight your proficiency in business requirement analysis, gap identification, and solution design.
Technical preparation
Master PL/SQL, SQL, Forms, and Reports.,Understand Oracle EBS R12 architecture.,Practice integration troubleshooting scenarios.,Review data migration script examples.
Behavioral questions
Describe a complex technical issue resolved.,How do you mentor junior team members?,How do you collaborate with functional teams?,How do you handle conflicting business requirements?
Frequently asked questions
- What are the key technical skills required for the Oracle R12 ERP Technical Lead role at Johnson Controls?
- The Oracle R12 ERP Technical Lead role at Johnson Controls requires strong expertise in PL/SQL, SQL, Oracle Forms, Oracle Reports, Oracle Applications Framework (OAF), and Oracle Workflow. A deep understanding of Oracle EBS Technical architecture and experience with integrations and data migration are also crucial.
- How much experience is needed for the Oracle R12 ERP Technical Lead position at Johnson Controls?
- Johnson Controls is seeking a candidate with at least 15 years of experience working with Oracle R12 ERP applications, specifically focusing on the technical aspects of Oracle EBS.
- What functional modules of Oracle EBS should candidates have knowledge of for this role?
- While the role is technical, candidates should possess good knowledge of one or more Oracle EBS functional modules. Examples provided in the description include Order Management and Procurement.
- Does Johnson Controls prefer candidates with Oracle R12 certifications for the Technical Lead role?
- Yes, Johnson Controls has a preference for candidates who hold a certification on Oracle Financials, with a particular preference for Oracle R12 certifications for this Oracle R12 ERP Technical Lead position.
- What is the expected work arrangement for the Oracle R12 ERP Technical Lead role at Johnson Controls?
- Based on the job description, the role implies a significant amount of collaboration and on-site involvement for production support and client interaction. While not explicitly stated as remote or hybrid, the nature of a lead technical role often involves a mix. However, we recommend clarifying the work arrangement during the application process.
- What kind of technical challenges can I expect as an Oracle R12 ERP Technical Lead at Johnson Controls?
- As an Oracle R12 ERP Technical Lead, you can expect to troubleshoot and resolve complex technical issues in Oracle EBS applications, support third-party interfaces, optimize SQL performance, build and support integrations, and lead data migration efforts. You'll also be involved in customization and development to meet specific business requirements.
- Is experience with Oracle Cloud beneficial for this Oracle R12 ERP Technical Lead role?
- While the primary focus is on Oracle R12 ERP, experience with Oracle Cloud implementations is considered a preferred qualification and would be a plus for candidates applying for this role at Johnson Controls.