Senior Oracle Developer (PL/SQL / Data Warehouse / ETL)

Papigen; India; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Papigen invites a Senior Oracle Developer to design, develop, and support enterprise data solutions in a financial services context. The role emphasizes Oracle 19c, PL/SQL, data warehousing, and ETL development to deliver scalable, high-performance database solutions.

You will translate business requirements into technical designs, optimize complex queries, and collaborate with cross-functional teams across infrastructure, DBA, integration, and data analytics.

Qualifications

• 8 years of experience in Oracle Development.
• Strong experience with Data Warehousing, ODS, and ETL.
• Experience in enterprise applications, preferably in the financial domain.

Responsibilities

• Design, develop, and support Oracle database solutions (Oracle 19c).
• Build and optimize Data Warehouse, ODS, and ETL processes.
• Develop Stored Procedures, Functions, Packages, and Triggers; write efficient SQL.

Skills

Oracle 19c

SQL

PL/SQL

Data Warehousing

ETL

Stored Procedures/Functions/Packages/4

Query Tuning

Data Modeling

Azure DevOps

Education

Bachelor’s Degree in Computer Science/IS/IT

Tools

Azure DevOps

Web API Development

Job description

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

We are seeking a Senior Oracle Developer with strong 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

• Bachelor’s Degree in Computer Science, Information Systems, IT, or related field.