Job Overview
| Particulars | Details |
|---|---|
| Position | Senior PL/SQL Developer – Oracle HCM |
| Company | Orbion Infotech |
| Location | Pan India |
| Job Type | Remote |
| Experience | 5 - 6 years |
| Category / Department | IT |
| Application Mode |
🏢 About Orbion Infotech
Company Overview:
Orbion is a technology solutions provider focused on cloud architecture, AI, secure web solutions, and enterprise digital transformation. The company supports businesses in modernizing, scaling, and securing their digital infrastructure through technology solutions and strategic IT services.
Company Mission:
To empower businesses with strategic IT solutions and architecture that drive innovation, accelerate growth, and transform complex ideas into measurable business outcomes.
Company Vision:
To become a strategic technology partner that helps enterprises achieve excellence through digital transformation, scalable infrastructure, and secure technology solutions.
Core Values / Principles
- Technical precision and engineering excellence
- Innovation and continuous improvement
- Scalable and future-ready solutions
- Transparent communication
- Accountability and partnership
- Business-focused technology delivery
D-105, Path No. 6, Veer Hanuman Nagar, Kardhani, Kalwar Road, Jaipur, Rajasthan, India
💡 Editor's Note / Preparation Tip
Resume Tips:
- Highlight your 6 years of Oracle SQL and PL/SQL development experience.
- Include examples of stored procedures, functions, packages, and triggers you have developed.
- Describe database performance tuning projects and measurable improvements where accurate.
- Specify your experience with Oracle Fusion Cloud HCM or EBS HRMS.
- Showcase work involving HCM data models, data migration, and system integrations.
- Include Oracle HCM Extracts, HDL, BI Publisher, REST/SOAP APIs, and OIC if you have practical experience with them.
- Clearly provide your LinkedIn profile URL, email address, and contact number.
- Emphasize debugging, troubleshooting, and resolving production database issues.
Interview Preparation:
- Revise PL/SQL blocks, cursors, exceptions, collections, and bulk processing.
- Prepare to explain stored procedures, functions, packages, and triggers with practical examples.
- Review execution plans, indexing, query optimization, and database performance tuning.
- Understand Oracle HCM architecture and the differences between Fusion Cloud HCM and EBS HRMS.
- Study HCM data models and common data migration challenges.
- Prepare to explain Oracle HCM Extracts, HDL, and BI Publisher if you have relevant experience.
- Review REST/SOAP integrations and Oracle Integration Cloud concepts.
- Practise explaining how you debug failed integrations, slow queries, and data inconsistencies.
Professional Tips:
- Confirm the contract duration, compensation, and expected working hours with the recruiter.
- Tailor your resume to the Oracle HCM and PL/SQL requirements.
- Ensure your LinkedIn profile reflects your current skills and experience.
- Include accurate contact information and a working LinkedIn URL.
- Recruiters submitting candidates should verify that all mandatory profile details are present.
📝 Job Description
Position Details:
Job Title: Senior PL/SQL Developer – Oracle HCM
Company: Orbion Infotech
Location: Pan India
Work Mode: Remote
Experience Required: 6 Years
Employment Type: Contract
Country: India
Orbion Infotech is looking for an experienced Senior PL/SQL Developer with strong Oracle database programming skills and knowledge of Oracle Human Capital Management (HCM). The successful candidate will develop and maintain PL/SQL programs, optimize database performance, support HCM integrations, and troubleshoot database-related issues.
Candidates should be comfortable working with Oracle SQL and PL/SQL programming constructs and understand HCM data structures, migration processes, and integration requirements. Experience with Oracle Fusion Cloud HCM or EBS HRMS is preferred.
Benefits / Compensation
- Remote work arrangement across India.
- Contract employment.
- Salary or contract rate: Not Provided.
- Additional benefits: Not Provided.
Candidate Requirements:
- 6 years of relevant professional experience.
- Strong hands-on experience with Oracle SQL and PL/SQL.
- Expertise in stored procedures, functions, packages, and triggers.
- Experience with database performance tuning.
- Experience with Oracle HCM, preferably Oracle Fusion Cloud HCM or EBS HRMS.
- Knowledge of HCM data models, data migration, and integrations.
- Strong analytical, debugging, and problem-solving skills.
- LinkedIn profile, email ID, and contact number are mandatory for profile submission.
Preferred Skills:
- Oracle HCM Extracts.
- HDL (HCM Data Loader).
- BI Publisher.
- REST and SOAP APIs.
- Oracle Integration Cloud (OIC).
- Oracle Fusion Cloud HCM or EBS HRMS integrations.
Working Days & Hours:
Not Provided.
How to Apply:
Interested candidates and recruiters with suitable profiles should send CVs to nehasisodiya@orbioninfotech.com.
Ensure the submitted profile includes all three mandatory details:
- LinkedIn profile URL
- Email address
- Contact number
🎯 Key Responsibilities
- ✓ Develop, maintain, and enhance PL/SQL programs for Oracle database applications.
- ✓ Create and manage stored procedures, functions, packages, and triggers.
- ✓ Analyze and optimize database queries and application performance.
- ✓ Support Oracle HCM integrations and resolve related technical issues.
- ✓ Troubleshoot and debug database-related errors and performance bottlenecks.
- ✓ Support HCM data models, data migration, and integration workflows.
- ✓ Collaborate with relevant technical teams to investigate issues and maintain reliable database operations.
💡 Required Qualifications & Skills
🚀 Career Guidance & Interview Insights
To help you succeed, we've compiled original preparation guides, resume keywords, and growth analytics for this category of role.
Joining as a Senior PL/SQL Developer – Oracle HCM offers a fantastic opportunity to work at the forefront of technological innovation. You will be exposed to modern software development lifecycles, collaborate with cross-functional product teams, and design scalable architectures that directly impact end-users. The continuous learning curve in tech ensures that your programming, debugging, and system engineering skills remain highly marketable and sharp.
The career roadmap in technology is highly rewarding. Typical progression starts as a Junior Software Engineer, moving to Associate Developer and then Senior Software Engineer (3-6 years). From there, professionals choose between an individual contributor track—becoming a Tech Lead, Staff Engineer, and Principal Architect—or a management track, advancing to Engineering Manager, Director of Engineering, and Chief Technology Officer (CTO).
Expected Technical & Behavioral Questions:
- Q1: How do you optimize database query performance?
Answer Tip: Talk about indexing strategies, query execution plan analysis, avoiding N+1 queries, and implementing caching layers (like Redis). - Q2: Explain the differences between Microservices and Monolithic architecture.
Answer Tip: Highlight scaling advantages, loose coupling, independent deployments, network latency considerations, and data consistency challenges in microservices. - Q3: How do you handle merge conflicts in Git?
Answer Tip: Explain checking out the local branch, pulling the latest main branch, running git merge, opening the conflicted files to resolve blocks manually, and committing the resolved merge.
To pass automated ATS (Applicant Tracking System) screening and catch the recruiter's eye, tailor your resume with the following tips:
- Keywords to include: Software Engineering, SDLC, OOP, CI/CD Pipelines, SQL databases, Agile, Unit Testing, Code Review, Cloud Architectures (AWS/Azure).
- Format: Use a clean, single-column resume format. Avoid graphics, text boxes, or tables which can scramble ATS parser outputs.
- Quantify Results: Instead of writing 'wrote code', write 'Developed a caching system that reduced server response times by 35%.'
Estimated compensation for this role type in India is ₹12,00,000 - ₹25,00,000+ per annum (Senior/Lead level). The actual salary package offered depends on factors such as company size, work mode (remote or on-site), individual technical proficiency, and negotiations during final HR rounds.
Highly recommended certifications include: AWS Certified Solutions Architect, Microsoft Certified: Azure Fundamentals, Certified Kubernetes Administrator (CKA), Oracle Certified Professional Java SE, or tech-stack specific achievements (e.g. Meta Front-End Developer certification).
Frequently Asked Questions
1. What is the job title?
Senior PL/SQL Developer – Oracle HCM.
2. Which company is hiring for this position?
The opportunity is advertised by Orbion Infotech.
3. How much experience is required?
Candidates should have 6 years of experience.
4. What is the work mode?
The position is fully remote, with the location specified as Pan India.
5. What is the employment type?
This is a contract position.
6. Which core technical skills are required?
Oracle SQL, PL/SQL, stored procedures, functions, packages, triggers, and performance tuning are the primary technical requirements.
7. Is Oracle HCM experience necessary?
Yes. Oracle HCM experience is required, with Oracle Fusion Cloud HCM or EBS HRMS preferred.
8. Which additional skills are advantageous?
Oracle HCM Extracts, HDL, BI Publisher, REST/SOAP APIs, and Oracle Integration Cloud (OIC) are desirable.
9. What information must candidates include in their profiles?
A LinkedIn profile URL, email address, and contact number are mandatory for profile submission.
10. How can candidates or recruiters submit profiles?
Send the candidate's CV to nehasisodiya@orbioninfotech.com, ensuring the mandatory profile details are included.
Share This Job
🛡️ Safety Disclaimer: JobPortalConnect curates official listings for informational purposes. Genuine recruiters will never ask you for processing fees, training payments, or security deposits. If you spot suspicious activity, copyright issues, or wish to request the removal of this listing, please report it to us immediately at contact.jobportalconnect@gmail.com.