Role: Oracle PLSQL Developer - Healthcare domain preferred
Location: Bangalore | Pune | Gurgaon | Noida | Hyderabad | Mumbai | Chennai
Experience: 6+ Years
Immediate Joiners Only
Key Responsibilities
- Design, develop, and maintain complex SQL and PL/SQL programs, including procedures, functions, packages, and triggers
- Implement advanced PL/SQL features such as collections, ref cursors, dynamic SQL, and large objects (LOBs)
- Perform query optimization and performance tuning to improve execution efficiency
- Work on data warehousing systems, including data validation, transformation, and reporting support
- Handle production support activities (L2/L3) including incident and problem management
- Participate in database migration projects (e.g., Greenplum to Amazon Redshift)
- Develop and migrate reports (e.g., SAP BO, TIBCO Spotfire)
- Collaborate with business stakeholders to understand requirements and translate them into technical solutions
- Ensure data integrity, consistency, and high availability of database systems
- Work on regulatory and financial reporting systems
Required Skills
- Strong expertise in Oracle SQL and PL/SQL development (6+ years)
- Advanced PL/SQL concepts:
- Collections, Ref Cursors (strong/dynamic), LOBs
- Packages, Procedures, Functions, Triggers
- Strong knowledge of SQL fundamentals:
- Joins, Subqueries, Set Operators, DML/DDL/TCL/DCL
- Experience in performance tuning and query optimization
- Hands-on experience with Oracle 10g/11g databases
- Experience with data warehousing concepts and large datasets
- Exposure to incident management and production support (L2/L3)
- Domain experience in Healthcare is preferred
