Oracle EBS Technical Consultant (Finance) - Contract To Hire

Golden Opportunities; Hyderabad, Pune District, Chennai District; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Golden Opportunities in India seeks a skilled Oracle EBS developer to design and optimize SQL scripts, customize EBS Forms and Reports, and provide production support for enterprise applications. You will collaborate with functional teams, DBAs, and stakeholders to analyze requirements, perform impact analysis, implement solutions, and ensure testing and deployment success.

Ideal candidates have 5–10 years of experience, a relevant Bachelor's degree, and strong SQL, data migration, and issue

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Engineering, or a related technical discipline.
• Equivalent relevant technical experience may also be considered.

Responsibilities

• Design and develop complex SQL scripts for data extraction, transformation, validation, and reporting across Oracle EBS modules.
• Optimize SQL queries to improve query performance, scalability, and resource utilization for high-volume transactional workloads.
• Configure and customize Oracle EBS Forms, including validation logic and user interface enhancements.
• Develop and enhance Oracle EBS Reports to provide accurate and timely business information.
• Perform detailed impact analysis for change requests involving database objects, EBS Forms, and Reports.

Skills

Oracle EBS

SQL scripting

Finance domain knowledge

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related technical discipline

Job description

Job Location: Mumbai, Pune, Hyderabad, Bangalore, Gurugram, Delhi, Chennai
Employment Type: Contract to Hire
1. Candidate Expectations
Total Experience: 5 to 10 yrs
Relevant Experience: 5 to 10 yrs
Candidate Location: Anywhere in India
Skills : Oracle EBS, Technical, Finance

2. Education and Certification
Qualification Bachelor's degree in Computer Science, Information Technology, Engineering, or a
related technical discipline.
Equivalent relevant technical experience may also be considered.

3. Detailed Job Description
Job Summary The candidate will be responsible for developing and optimizing complex SQL scripts, customizing Oracle EBS Forms and Reports, resolving production issues, and delivering reliable technical solutions for enterprise applications.
The role requires close collaboration with functional teams, DBAs, business stakeholders, and technical teams to understand requirements, perform impact analysis, develop solutions, and ensure successful testing and deployment.

Key Responsibilities

• Design and develop complex SQL scripts for data extraction, transformation, validation, and reporting across Oracle EBS modules.
• Optimize SQL queries to improve query performance, scalability, and resource utilization for high-volume transactional workloads.
• Configure and customize Oracle EBS Forms, including validation logic and user interface enhancements.
• Develop and enhance Oracle EBS Reports to provide accurate and timely business information.
• Perform detailed impact analysis for change requests involving database objects, EBS Forms, and Reports.
• Conduct unit testing and support functional testing to ensure solutions meet business and technical requirements.
• Provide production support for SQL and Oracle EBS-related incidents.
• Perform root cause analysis (RCA) and implement sustainable fixes for production issues.
• Prepare and maintain technical documentation covering SQL logic, EBS Formsconfigurations, and Report structures.
• Collaborate with functional and cross-functional teams to understand business requirements and translate them into technical solutions.
• Work with Database Administrators (DBAs) on query performance, indexing strategies, and deployment activities.
• Support data migration and data cleansing activities using controlled SQL scripts and validation queries.
• Participate in code reviews and technical design discussions while following organizational development standards.
• Support minor release deployments and ensure minimal disruption to business operations.

4. Key Skills

SQL Scripting, Advanced SQL, Complex SQL Queries, SQL Query Optimization, SQL Performance Tuning, Oracle Database, Relational Database Concepts, Indexing, Normalization, Constraints, Transaction Handling, Oracle E-Business Suite, Oracle EBS R12, Oracle EBS Forms, Forms Customization, Forms Development, Validation Logic, UI Enhancements, Oracle EBS Reports, Reports Development, Report Customization, Database Objects, Data Extraction, Data Transformation, Data Validation, Data Migration, Data Cleansing, Impact Analysis, Unit Testing, Functional Testing, Production Support, Incident Management, Root Cause Analysis, Defect Fixing, Technical Documentation, Code Review, SDLC, Requirements Analysis, Technical Design, Deployment Coordination, Release Management, DBA Coordination, Business Stakeholder Management.

5. Other Specific Remarks

Strong hands-on experience in SQL and Oracle EBS Forms & Reports is mandatory.
Candidates should have experience in production support and troubleshooting.