Logo of Huzzle

Home

Matches

Explore

Manage

PL/SQL Developer

image

Oracle

9d ago

  • Job
    Full-time
    Senior Level
  • Software Engineering
    IT & Cybersecurity

AI generated summary

  • You need a CS degree, 5+ years of PL/SQL development, strong Oracle SQL skills, query fine-tuning expertise, banking domain experience, and UNIX knowledge is a plus.
  • You will analyze business requirements, estimate development efforts, create optimized queries/packages, review peer code, fix defects during testing, and enhance existing designs for scalability.

Requirements

  • Any Computer Science based graduation
  • 5+ years in software development
  • Excellent hands-on coding and design skills in Oracle SQL, PL/SQL with exposure to analytical functions and data modelling.
  • Expertise in Query fine-tuning to ensure optimized execution
  • Experience in Banking Domain
  • Knowledge of UNIX is an added advantage
  • 5+ years of experience in Oracle SQL, PL/SQL development
  • Pure development experience to be considered (to avoid support expertise where the requirement is more monotonous)
  • Experience in Query fine-tuning (not database tuning) for writing optimized code.

Responsibilities

  • Understand the business requirements from the functional team
  • Estimate the development efforts for the assigned functions.
  • Develop the functionalities based on Agile/ Water-Scrum-Fall model
  • Write optimized Queries or Packages that can handle high volume and performance
  • Perform peer-review of code written by other developers
  • Assisting in defect fix during System Testing, SIT, UAT and Non-Regression Testing.
  • Additionally, contribute to the upliftment of existing design/ code for alternates that can help in flexibility and scalability.

FAQs

What technologies should I be proficient in for this role?

You should have excellent hands-on coding and design skills in Oracle SQL and PL/SQL, with exposure to analytical functions and data modeling.

Is experience in the banking domain required?

Yes, experience in the banking domain is preferred for this role.

What is the expected career level for this position?

The career level for this position is IC2.

What kind of development methodologies will I be working with?

You will be working primarily with Agile and Water-Scrum-Fall models.

How many years of experience is required for this position?

A minimum of 5 years of experience in software development, specifically with Oracle SQL and PL/SQL, is required.

Will I be involved in the entire development life cycle?

Yes, you will be responsible for the entire development life cycle from development to production implementation.

What sort of work-life balance does the company offer?

The company promotes work-life balance and provides flexible medical, life insurance, and retirement options to its employees.

Is training provided for new tools and technologies?

Yes, we encourage team members to aspire to learn new tools as per project needs.

Are there opportunities for code review and collaboration?

Yes, you will be responsible for performing peer reviews of code written by other developers.

How does the company approach diversity and inclusion?

The company is committed to expanding its inclusive workforce by promoting diverse insights and perspectives at all levels.

Do I need any knowledge of UNIX for this role?

While knowledge of UNIX is an added advantage, it is not strictly required for this position.

Can you describe the team I would be working with?

You will be working within a team dedicated to one of the largest multi-national banks, focusing on enhancements in the Supply Chain Finance domain.

Are there any specific performance expectations for query writing?

Yes, you are expected to write optimized queries and packages that can handle high volume and performance.

What is the process for applying for this position?

You can apply for the position through the company’s careers page or the job posting platform where you found this listing.

Will there be flexibility in working hours?

Yes, the company promotes flexibility in working hours to support employee work-life balance.

image

Oracle

Information Technology & Services

Technology
Industry
10,001+
Employees
1977
Founded Year

Mission & Purpose

We’re a cloud technology company that provides organizations around the world with computing infrastructure and software to help them innovate, unlock efficiencies and become more effective. We also created the world’s first – and only – autonomous database to help organize and secure our customers’ data. Oracle Cloud Infrastructure offers higher performance, security, and cost savings. It is designed so businesses can move workloads easily from on-premises systems to the cloud, and between cloud and on-premises and other clouds. Oracle Cloud applications provide business leaders with modern applications that help them innovate, attain sustainable growth, and become more resilient. The work we do is not only transforming the world of business--it's helping defend governments, and advance scientific and medical research. From nonprofits to companies of all sizes, millions of people use our tools to streamline supply chains, make HR more human, quickly pivot to a new financial plan, and connect data and people around the world. At work, we embrace diversity, encourage personal and professional growth, and celebrate a global team of passionate people developing innovative technologies that help people and companies tackle real-world problems head-on.