Job Description – Senior Oracle PL/SQL Developer

Designation: Senior Oracle PL/SQL Developer

Experience: 5 - 7+ Years

Work Location: Hyderabad / Chennai / Bangalore

Work Mode: Hybrid

Job Overview

We are looking for an experienced Senior Oracle PL/SQL Developer with strong hands-on expertise in Oracle database development, SQL performance tuning, ETL processes and Unix/Linux Shell Scripting.

The ideal candidate should have experience developing and maintaining complex PL/SQL programs, handling large volumes of data, implementing data-loading processes, automating database operations and providing production support.

Candidates should be comfortable working on database-driven enterprise applications, data integration, migration and performance optimisation projects.

Key Responsibilities

• Design, develop, enhance and maintain Oracle PL/SQL database objects, including stored procedures, functions, packages, triggers and views.
• Write complex SQL queries involving joins, subqueries, analytical functions, aggregations and data transformations.
• Perform SQL and PL/SQL performance tuning using execution plans, indexing, query optimisation and database performance analysis techniques.
• Develop and maintain ETL processes involving data extraction, transformation, validation and loading.
• Implement data-loading processes using SQL*Loader, external tables, UTL_FILE and flat-file processing.
• Develop and maintain Unix/Linux Shell Scripts to automate database operations, batch processes and data-processing activities.
• Monitor scheduled jobs, identify failures, troubleshoot issues and implement appropriate fixes.
• Perform database migration, data reconciliation, data validation and bulk data processing.
• Analyse production issues, perform root-cause analysis and provide timely resolutions.
• Work closely with functional teams, business analysts, QA teams and other technical stakeholders.
• Participate in code reviews, unit testing, integration testing and production deployment activities.
• Maintain technical documentation and follow development standards and best practices.

Mandatory Technical Skills

1. Oracle SQL & PL/SQL

• Strong hands-on experience in Oracle SQL and PL/SQL development.
• Stored Procedures, Functions, Packages and Triggers.
• Cursors, Collections, Dynamic SQL and Exception Handling.
• Bulk processing techniques such as BULK COLLECT and FORALL.
• Complex SQL queries, joins, subqueries and analytical functions.
• Database objects such as Tables, Views, Indexes and Materialized Views.

2. SQL Performance Tuning

• SQL query optimisation and execution-plan analysis.
• Index creation and optimisation.
• Performance troubleshooting for complex SQL queries and PL/SQL programs.
• Experience with Explain Plan and database performance analysis.

3. ETL & Data Processing

• Hands-on experience in ETL development and data integration.
• Data extraction, transformation, validation and loading.
• Experience handling large datasets and batch-processing activities.
• Data migration, source-to-target mapping and reconciliation.

4. Unix/Linux Shell Scripting

• Hands-on experience developing Unix/Linux Shell Scripts.
• Automating database operations and repetitive tasks.
• File handling, batch execution, job monitoring and troubleshooting.

5. Data Loading & File Processing

• SQL*Loader.
• External Tables.
• UTL_FILE.
• Flat-file data processing and database loading.

Good-to-Have Skills

• Experience with Informatica, Oracle Data Integrator (ODI) or other ETL tools.
• Knowledge of database migration and data warehousing.
• Experience with Autosys, Control-M or other job-scheduling tools.
• Experience in production support and enterprise application environments.
• Knowledge of Oracle database administration concepts.

Candidate Requirements

• Minimum 7+ years of relevant hands-on experience in Oracle SQL/PLSQL development.
• Strong practical knowledge of ETL and Unix/Linux Shell Scripting.
• Experience in SQL performance tuning and database troubleshooting.
• Good analytical, debugging and problem-solving skills.
• Ability to work independently and collaborate with cross-functional teams.
• Good communication and stakehold