Job Title: Senior Oracle Developer (PL/SQL / Data Warehouse / ETL)

We are seeking a Senior Oracle Developer with robust expertise in Oracle 19c, PL/SQL, Data Warehouse, and ETL development to design, develop, and support enterprise data solutions. The role involves building scalable database solutions, optimizing complex queries, developing ETL processes, and supporting end-to-end SDLC activities in a financial services environment.

Key Responsibilities

- Design, develop, and maintain Oracle database solutions using Oracle 19c, SQL, and PL/SQL.
- Develop and support Data Warehouse (DWH), Operational Data Store (ODS), and ETL processes.
- Create and optimize Stored Procedures, Functions, Packages, Triggers, and SQL scripts.
- Perform query tuning and database performance optimization.
- Translate business requirements into technical specifications and solutions.
- Conduct code reviews and ensure adherence to development standards.
- Troubleshoot and resolve production issues within SLA timelines.
- Support UAT, deployments, and post-production activities.




- Collaborate with Infrastructure, DBA, Integration, and Business teams.
- Participate in Agile ceremonies and project status reviews.

Required Skills Experience Experience

- 8+ years of experience in Oracle Development.
- Strong experience with Data Warehousing, ODS, and ETL solutions.
- Experience working in enterprise applications, preferably within the financial domain.

Technical Skills

- Oracle 19c
- SQL and Advanced PL/SQL
- Stored Procedures, Functions, Packages, Triggers
- SQL Loader
- Query Performance Tuning Optimization
- Data Warehouse (DWH) Development
- ETL Design Development
- Data Modeling Concepts
- Database Performance Monitoring

Preferred Skills

- Azure DevOps
- Web API Development
- Banking / Financial Services Domain
- MS Excel Reporting
- Cloud-based data integration knowledge

Educational Qualification

- Bachelors Degree in Computer Science, Information Systems, IT, or related field.

📌 Senior Oracle Developer (PL/SQL / Data Warehouse / ETL) (Tamil Nadu)
🏢 Papigen
📍 Tamil Nadu