Papigen is a world-class technology services business that incorporates industry insights and experience to deliver the digital solutions. As a Global IT Services and Solutions Company, Papigen can assist in bringing Technology Transformation and Modernization across Business Functions and Enterprises. Improving existing technology processes and platforms, Enterprise Digital Integration and Enablement, User Engagement through better Visualization and User Interface, Enterprise Mobility, Extensive Capability in Dynamic Technology areas such as Big Data, Java, React, MEAN/MERN, Cloud, DevOps and much more. 

We are fast growing company looking to deliver the best quality possible and achieve clients need by offering a unique mix of software products, consulting services, data science capabilities, and technology expertise. 

We work with our customers on Time and Material Engagements, Staff Augmentation, as well as SoW led Managed Services Models.

To learn more, visit www.papigen.com.

Papigen

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
<ul>
<li>Design, develop, and maintain Oracle database solutions using Oracle 19c, SQL, and PL/SQL.</li>
<li>Develop and support Data Warehouse (DWH), Operational Data Store (ODS), and ETL processes.</li>
<li>Create and optimize Stored Procedures, Functions, Packages, Triggers, and SQL scripts.</li>
<li>Perform query tuning and database performance optimization.</li>
<li>Translate business requirements into technical specifications and solutions.</li>
<li>Conduct code reviews and ensure adherence to development standards.</li>
<li>Troubleshoot and resolve production issues within SLA timelines.</li>
<li>Support UAT, deployments, and post-production activities.</li>
<li>Collaborate with Infrastructure, DBA, Integration, and Business teams.</li>
<li>Participate in Agile ceremonies and project status reviews.</li>
</ul>
Required Skills &amp; Experience Experience
<ul>
<li>8+ years of experience in Oracle Development.</li>
<li>Strong experience with Data Warehousing, ODS, and ETL solutions.</li>
<li>Experience working in enterprise applications, preferably within the financial domain.</li>
</ul>
Technical Skills
<ul>
<li>Oracle 19c</li>
<li>SQL and Advanced PL/SQL</li>
<li>Stored Procedures, Functions, Packages, Triggers</li>
<li>SQL Loader</li>
<li>Query Performance Tuning &amp; Optimization</li>
<li>Data Warehouse (DWH) Development</li>
<li>ETL Design &amp; Development</li>
<li>Data Modeling Concepts</li>
<li>Database Performance Monitoring</li>
</ul>
Preferred Skills
<ul>
<li>Azure DevOps</li>
<li>Web API Development</li>
<li>Banking / Financial Services Domain</li>
<li>MS Excel Reporting</li>
<li>Cloud-based data integration knowledge</li>
</ul>
Educational Qualification
<ul>
<li>Bachelor's Degree in Computer Science, Information Systems, IT, or related field.</li>
</ul>