Oracle PL/SQL Developer

Overview

Job Title: PL/SQL Developer

Chennai, OMR

Interview Mode : 1) Virtual Interview

2) Telephonic Interview

3) Face to Face Interview

Gender: Male

Mandatory Skillset:

ETL

Datamigration

SQL Queries

Oracle Databased tool – Toad / SQL Developer

Key Responsibilities

Develop, test, and maintain complex PL/SQL packages, procedures, functions, and triggers

for data processing and ETL tasks. Design and implement database schemas and objects such as tables, indexes, and views. Analyze business requirements and translate them into technical solutions using PL/SQL. Optimize SQL queries and database performance for high efficiency. Perform data analysisto support report generation and modify existing reports as needed. Develop migration scripts for data transfer between systems. Ensure compliance with security standardsto protectsensitive data. Provide technicalsupport for production systems, including troubleshooting and resolving

issues. Documenttechnicalspecifications and create reusable code forscalability. Required Skills

Technical Skills:

Proficiency in Oracle PL/SQL programming with experience in developing stored procedures, functions, and triggers. Strong understanding of relational database concepts(RDBMS) and performance tuning

techniques. Experience with ETL processes and data warehouse integration. Knowledge of advanced PL/SQL features like collections, ref cursors, dynamic SQL, and

materialized views. Familiarity with toolslike SQL Developer, Toad, orsimilarIDEs. Exposure to Unix/Linux scripting is a plus. Soft Skills:

Strong analytical and problem-solving abilities. Excellent communication skillsto interact with stakeholders and team members effectively. Attention to detail with a focus on accuracy in coding and testing. Ability to work both independently and in a team environment. Qualifications

Bachelor’s degree in computerscience, Information Technology, or a related field (or

equivalent experience)

Proven experience (3.5 to 4+ years) in Oracle PL/SQL development.

Job Types: Full-time, Permanent

Pay: ₹300,000.00 - ₹700,000.00 per year

Benefits:

• Flexible schedule
• Health insurance
• Paid sick time
• Provident Fund

Schedule:

• Day shift
• Monday to Friday

Work Location: In person