PL/SQL Developer

Experience-3-6 Years

Mandate skills - Strong PL/ SQL and Unix Shell Scripting ( 60% in Support + 40% in Development Exp required).

Hands-on experience in PL/SQL and Unix Shell Scripting.

Deep understanding of Oracle database architecture and indexing strategies.

Proficiency in performance tuning and query optimisation techniques.

Experience with data warehousing concepts and dimensional modelling.

Excellent problem-solving, communication, and interpersonal skills.

Ability to work independently and as part of a team.

Key Responsibilities

Develop and maintain PL/SQL procedures, functions, and packages in Oracle.

Write and optimize complex SQL queries, including views and materialized views.

Implement analytical functions, hierarchical queries, pivot/unpivot operations.

Manage external tables, SQL Loader operations, and table partitioning strategies.

Perform query performance tuning using explain plans, hints, and parallel queries.

Work with fact and dimension tables in data warehouse environments.

Create and execute unit and integration test plans/scripts.

Document test results and track issues per SOPs or project requirements.

Support Quality Control (QC) activities and perform regression testing.

Analyse and fix code defects, ensuring robust and scalable solutions.

Collaborate effectively with cross-functional teams and stakeholders.

Required Skills

Strong hands-on experience in PL/SQL and Unix Shell Scripting.

Deep understanding of Oracle database architecture and indexing strategies.

Proficiency in performance tuning and query optimisation techniques.

Experience with data warehousing concepts and dimensional modelling.

Excellent problem-solving, communication, and interpersonal skills.

Ability to work independently and as part of a team.

Mode of work-Hybrid for now after Feb 2026 4 days WFO

Location-Bengaluru

Try not to take AP Candidates

Mode of Interview- First round-virtual, Final round- F2F.

CTC- 14 LPA (Max)

PL/SQL Developer