Premium Employer

i

This company page is being actively managed by Xoriant Team. If you also belong to the team, you can get access from here

Xoriant Verified Tick

Compare button icon Compare button icon Compare
filter salaries All Filters

44 Xoriant Jobs

Hiring For Oracle- PL/SQL Lead - 9- 12 years exp - Pune

9-12 years

Pune

1 vacancy

Hiring For Oracle- PL/SQL Lead - 9- 12 years exp - Pune

Xoriant

posted 17hr ago

Job Role Insights

Flexible timing

Job Description

Job Title: Oracle PL/SQL Developer

Experience: 9-12years

Location: Pune

Job Description:

We are seeking an experienced and highly skilled Oracle PL/SQL Lead to join our dynamic team. The ideal candidate will have strong expertise in Oracle PL/SQL development, performance tuning, and database optimization. If you have a passion for working with large datasets, designing efficient database solutions, and troubleshooting complex database issues, we want to hear from you!

Key Responsibilities:

  • Design, develop, and maintain complex stored procedures to handle data integration from 6-7 tables into a consolidated table.
  • Ensure high performance and efficiency of all database operations.
  • Analyze and optimize database queries and structures to improve performance.
  • Create indexes, partitions, and other database optimizations as necessary.
  • Implement data validation, transformation, and cleansing logic within stored procedures.
  • Collaborate with business analysts and data teams to understand requirements and ensure accurate data mapping.
  • Identify and resolve performance bottlenecks and errors in SQL code.
  • Conduct root cause analysis for production issues and provide timely fixes.
  • Work closely with cross-functional teams to deliver database solutions aligned with business goals.
  • Clearly communicate technical concepts and project progress to stakeholders.

Technical Skills Required:

  • 9-12 years of hands-on experience in Oracle PL/SQL development.
  • Proficient in designing and optimizing stored procedures, views, and materialized views.
  • Strong knowledge of database indexing, partitioning, and performance tuning techniques.
  • Experience in working with large datasets and integrating data from multiple tables.
  • Hands-on experience with Oracle SQL Plus (CLI).
  • Familiarity with Oracle Database 19c/21c.
  • Knowledge of ETL processes and tools.
  • Strong analytical skills to interpret data requirements and build database solutions.
  • Ability to troubleshoot complex database issues efficiently.

Preferred Skills:

  • Oracle Certification (e.g., Oracle Database SQL Certified Associate or higher) is a plus.
  • Familiarity with data migration, data warehousing, or similar projects is an advantage.
  • Experience with database administration and monitoring tools.
  • Knowledge of cloud database platforms (e.g., Oracle Cloud, AWS RDS) is a plus.

Qualifications:

  • Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
  • Strong communication and interpersonal skills.
  • Ability to work collaboratively in a team environment and deliver results.


Employment Type: Full Time, Permanent

Read full job description

Xoriant Interview Questions & Tips

Prepare for Xoriant roles with real interview advice

Top Xoriant SQL Lead Interview Questions

Q1. String is immutable but what happens if we assign another value to that string reference
Q2. What are the advantages of python over other programming languages?
Q3. Tell me some of the data types that are used in python?
View all 160 questions

What people at Xoriant are saying

What Xoriant employees are saying about work life

based on 1.9k employees
87%
96%
70%
84%
Flexible timing
Monday to Friday
No travel
Day Shift
View more insights

Xoriant Benefits

Submitted by Company
Education Assistance
Health Insurance
Soft Skill Training
Job Training
International Relocation
Giving Back to Community +8 more
Submitted by Employees
Work From Home
Health Insurance
Soft Skill Training
Job Training
Cafeteria
Team Outings +6 more
View more benefits

Compare Xoriant with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

Tech Mahindra

3.5
Compare

HCLTech

3.5
Compare

LTIMindtree

3.8
Compare

Mphasis

3.4
Compare

Persistent Systems

3.5
Compare

Hexaware Technologies

3.5
Compare

CitiusTech

3.4
Compare

HTC Global Services

3.6
Compare

HERE Technologies

3.9
Compare

Tietoevry

4.3
Compare

Collabera Technologies

3.5
Compare

Unisys

3.7
Compare

Slk Software Services

3.3
Compare

Altimetrik

3.8
Compare

Apexon

3.3
Compare

Brillio

3.4
Compare

TEKsystems

3.4
Compare

Similar Jobs for you

Plsql Developer at Eviden

Pune, Chennai + 1

6-11 Yrs

₹ 10-20 LPA

Oracle Developer at Relevantz Technology Services

Chennai

7-12 Yrs

₹ 14-24 LPA

Backend Developer at AXIS DIRECT

Navi Mumbai

5-8 Yrs

₹ 12-17 LPA

Senior Oracle PL SQL Developer at Dedalus Global

Noida

6-9 Yrs

₹ 18-22.5 LPA

Plsql Developer at Infosys Limited

Pune

5-8 Yrs

₹ 7-10 LPA

SQL Developer at PROOUNCE SOLUTIONS PRIVATE LIMITED

Chennai, Pune + 5

6-9 Yrs

₹ 8-11 LPA

Technical Architect at Tata Consultancy Services

Mumbai

10-17 Yrs

₹ 22.5-37.5 LPA

Plsql Developer at Qualtech Edge

Thane, Mumbai

7-12 Yrs

₹ 14-24 LPA

Plsql Developer at Fusion Plus Solutions Inc

Hyderabad / Secunderabad

7-12 Yrs

₹ 5-8 LPA

Professional at Fusion Plus Solutions Inc

Hyderabad / Secunderabad

7-12 Yrs

₹ 5-8 LPA

Xoriant Pune Office Locations

View all
Pune Office
6th Floor, Smartworks, Pan Card Club Road, Baner, Pune Pune
411045
Pune Office
7th Floor, IT-7 Building, Qubix Business Park Pvt. Ltd. SEZ, Phase - 1, Hinjawadi, Pune Pune
411057

Hiring For Oracle- PL/SQL Lead - 9- 12 years exp - Pune

9-12 Yrs

Pune

17hr ago·via naukri.com

SAP Finance & Controlling (FICO)

7-12 Yrs

₹ 6 - 16L/yr

Pune

17hr ago·via naukri.com

HR Business Partner

10-15 Yrs

Pune

18hr ago·via naukri.com

Java Full Stack Developer

7-12 Yrs

Bangalore / Bengaluru

1d ago·via naukri.com

React JS Developer With Maplelabs( A Unit Of Xoriant Company)3+ Years

3-7 Yrs

Bangalore / Bengaluru

1d ago·via naukri.com

L2/L3 Python Automation Testing

4-9 Yrs

Chennai, Bangalore / Bengaluru

2d ago·via naukri.com

Core Java Developer

3-7 Yrs

Pune, Gurgaon / Gurugram, Bangalore / Bengaluru

3d ago·via naukri.com

Python Developer Lead

11-15 Yrs

Gurgaon / Gurugram, Chennai, Bangalore / Bengaluru

5d ago·via naukri.com

Java Full Stack Developer ( Angular+AWS )

5-10 Yrs

Pune, Mumbai

5d ago·via naukri.com
write
Share an Interview