PL/SQL Developer

Company:IT Services Organization

Key Skills:Functions, Packages, Triggers, Ref Cursors, Collections, SQL*Loader, UTL_FILE, External Tables, Data Transformation, Query Optimization.

Roles & Responsibilities:

• Develop modular and reusable code blocks using PL/SQL.
• Implement business logic and automation within the database through packages and triggers.
• Handle complex data structures and multi-row operations using ref cursors and collections.
• Employ tools like SQL*Loader, UTL_FILE, and External Tables for efficient data import.
• Implement data transformation logic as per business requirements.
• Optimize performance and tune queries for enhanced database efficiency.

Experience Required:

• 6 - 8 years of strong experience in Oracle PL/SQL development and performance tuning.
• Proficient in creating complex stored procedures, functions, packages, and triggers.
• Hands-on experience with large-volume data processing using PL/SQL.
• Experience with performance optimization techniques and query tuning.
• Skilled in handling advanced data types, collections, and ref cursors.
• Exposure to tools such as SQL*Loader and UTL_FILE for data loading operations.
• Proven ability to work independently and deliver high-quality, scalable database solutions.

Education: M.B.A., M.E., B.Tech M.Tech (Dual), M.S., M.Des, B.E., B.Tech, M. Tech, M.Sc.