Papigen Private Limited
Website:
papigen.com
Job details:
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.
Skills: windows azure,data warehousing,oracle 19c,etl,pl/sql
Click on Apply to know more.