Company: Oracle Financial Services Software / Oracle Health (Oracle Corporation)
Job Title: Application Software Engineer 1
Job Identification / Requisition ID: 344317
Job Category: Product and Research
Career Level: IC1 (Individual Contributor – Level 1)
Posting Date: October 27, 2026
Job Type: Regular Employee | Full-Time
Shift Pattern: General Day Shift (9:00 AM – 6:00 PM IST)
Experience Level: 0 to 2+ Years (Fresh Graduates & Early Career Professionals)
Work Sponsorship: Visa / work permit sponsorship is NOT available for this position.
Location: Bengaluru / Bangalore, Karnataka, India
Company & Practice Overview
Oracle is a global enterprise cloud, database, and application giant powering mission-critical systems worldwide. Following its acquisition of Cerner, Oracle Health builds cloud-scale electronic health record (EHR) platforms, clinical automation systems, and healthcare intelligence suites serving thousands of hospitals and health networks globally.
The Application Software Engineer 1 (IC1) position is based at Oracle’s major development center in Bengaluru. Working directly within the healthcare technology engineering division, engineers in this role specialize in the Cerner Millennium data model, writing high-performance SQL/PL-SQL data processing pipelines, developing clinical reporting solutions (using CCL / Cerner Command Language), debugging application modules, and building healthcare workflow enhancements.
Key Responsibilities & Daily Operations
- Millennium Data Model Engineering: Gain deep expertise in healthcare workflows and Cerner Millennium database schemas to design and build application enhancements.
- Database & Report Engineering: Develop, optimize, and maintain complex SQL queries, PL-SQL stored procedures, and custom database reports for clinical data fetching and analytics representation.
- Custom Reporting & BI Integration: Design and execute specialized healthcare reporting solutions using Oracle PL/SQL and Cerner Command Language (CCL), with optional exposure to Business Intelligence tools (Tableau, Power Insight, DA2).
- Application Debugging & RCA: Perform deep-dive application debugging, analyze log files, document Root Cause Analysis (RCA), and implement bug fixes across staging and production environments.
- Client & Stakeholder Collaboration: Handle technical calls with client implementation teams and cross-functional stakeholders to gather requirements, estimate task efforts, and deliver custom application features.
- Process Improvement & SDLC: Participate in component-level technical design discussions, enforce Git version control standards, write unit test suites, and support release engineering cycles.
Minimum Eligibility & Qualification Criteria
Academic Background
- Degree: Bachelor’s Degree or higher (B.E. / B.Tech / M.Tech / MCA / B.Sc) in Computer Science, Computer Engineering, Software Engineering, Information Technology, Computer Applications, or Information Systems.
Experience & Work Permit Criteria
- Experience Level: 0 to 2+ years of software development and database engineering experience.
- Work Authorization: Must possess existing legal authorization to work in India (No visa or work permit sponsorship provided).
Mandatory Technical Competencies
- Database & SQL: Strong proficiency in SQL, PL-SQL, and Relational Database Management Systems (RDBMS).
- Core Programming: Programming experience in at least one major language (Python, Java, or C++).
- Software Engineering Tools: Hands-on experience with debugging tools, version control (Git), unit testing frameworks, and data processing techniques.
Preferred / Good-to-Have Skills
- Familiarity with healthcare workflows, EHR data models, or Cerner Command Language (CCL).
- Exposure to Business Intelligence (BI) platforms (Tableau, Business Objects, Power Insight, Discern Analytics 2 / DA2).
Compensation & Employee Benefits
- Estimated Starting Salary: ₹6.5 LPA to ₹11.0 LPA (CTC) for IC1 level, depending on degree tier, SQL/PL-SQL depth, and interview performance evaluation.
- Oracle Corporate Benefits:
- Comprehensive Medical, Life, and Personal Accident Insurance for employees and dependents.
- Access to Oracle University learning subscriptions and Oracle Cloud Infrastructure (OCI) certifications.
- Employee stock purchase plans (ESPP), volunteer programs, and structured career growth toward IC2 (Software Engineer 2).
Selection Workflow & Interview Steps
1. Profile Shortlisting & Resume Screening (Job ID: 344317)
(Verification of CS/IT/CA degree qualification, 0–2+ YOE, SQL proficiency, & India work eligibility)
↓
2. Oracle Online Technical Assessment (Coding & Database Test)
(Evaluation of SQL query writing, PL-SQL logic, Data Structures, Programming [Java/Python], & Aptitude)
↓
3. Technical Interview Round 1 (SQL, PL-SQL & Database Internals)
(Deep dive into SQL joins, subqueries, indexing, execution plans, PL-SQL cursors/triggers, & database design)
↓
4. Technical Interview Round 2 (Programming, Debugging & Data Modeling)
(Live coding session in Java/Python/C++, array/string algorithms, RCA debugging scenarios, & Git basics)
↓
5. Managerial & HR Discussion (Oracle Health Fitment & Work Culture)
(Discussion on 9 AM – 6 PM shift expectations, communication skills, IC1 compensation, & offer rollout)
Essential Technical Topics to Prepare
- Advanced SQL & PL-SQL: Complex
JOINqueries,GROUP BY/HAVING, Subqueries, Window functions (ROW_NUMBER,DENSE_RANK), PL-SQL anonymous blocks, Stored Procedures, Functions, Cursors (%FOUND,%NOTFOUND), Triggers, and Exception handling. - Database Optimization: Index types (B-Tree, Bitmap), execution plans,
EXPLAIN PLAN, query tuning, table partitioning, and database normalization (1NF to 3NF). - Programming & Debugging: Object-Oriented Programming (OOP) concepts in Java/Python, exception handling, string manipulation, and root cause analysis techniques.
Core Resume Keywords for ATS Optimization
- Database & Reporting: Database Management Systems, SQL, PL/SQL, Cursors, Stored Procedures, Triggers, Query Optimization, Data Processing, Data Analysis
- Healthcare & Millennium: Oracle Health, Cerner Millennium Data Model, Healthcare Workflows, CCL (Cerner Command Language), Business Intelligence, Power Insight, DA2
- Software Engineering: Application Software Engineer, IC1, Python, Java, C++, Debugging, Git, Unit Testing, Root Cause Analysis (RCA), SDLC
- Oracle Specifics: Requisition 344317, Oracle Bengaluru, Individual Contributor Level 1, Day Shift (9 AM – 6 PM)
Frequently Asked Questions (FAQs)
1. What is the Job Requisition ID for this Oracle opening?
The official Oracle job ID is 344317.
2. What is the Career Level and shift timing for this position?
The position is classified as Career Level – IC1 (Individual Contributor Level 1) operating on a general day shift (9:00 AM – 6:00 PM IST).
3. Does Oracle provide visa sponsorship for this job?
No. The job description explicitly specifies that visa / work permit sponsorship is not available for this position.
4. What domain-specific knowledge is valuable for this role?
Knowledge of healthcare workflows, the Cerner Millennium data model, and CCL (Cerner Command Language) is explicitly listed as a strong advantage.