Oracle PL/SQL Developer

Job description

<p><p><b>About Client : </b><br/><br/></p><p><br/>Our client is a French multinational information technology (IT) services and consulting company, headquartered in Paris, France.<br/><br/>Founded in 1967, It has been a leader in business transformation for over 50 years, leveraging technology to address a wide range of business needs, from strategy and design to managing operations.<br/><br/></p><p><br/>The company is committed to unleashing human energy through technology for an inclusive and sustainable future, helping organizations accelerate their transition to a digital and sustainable world.

They provide a variety of services, including consulting, technology, professional, and outsourcing Details : </b></p><p><br/></p><p>Location : Pune.</p><p><br/></p><p><br/>Mode Of Work : Hybrid.<br/><br/></p><p><br/>Notice Period : Immediate Joiners.<br/><br/></p><p><br/>Experience : 5 - 8yrs.<br/><br/></p><p><br/>Type Of Hire : Contract to Description : </b></p><p><br/></p><p>Oracle PL/SQL Developer (Capital Markets/Finance/Regulatory Reporting).</p><p><br/></p><b><br/>Role Overview : </b></p><p><br/></p><p>We are looking for a talented and experienced Oracle PL/SQL Developer with 5 to 8 years of experience in the Capital Markets, Finance, or Regulatory Reporting domains.

The ideal candidate will possess strong expertise in Oracle PL/SQL, with hands-on experience in both on-premise and cloud environments.<br/><br/></p><p><br/>This role involves designing, developing, and maintaining robust database solutions to support critical financial applications and regulatory reporting Responsibilities : </b></p><p><br/></p><p>- Database Development : Design, develop, and optimize complex Oracle PL/SQL stored procedures, functions, packages, triggers, and views to support business requirements.</p><p><br/></p><br/>- Performance Tuning : Identify and resolve database performance bottlenecks, including query optimization, indexing strategies, and PL/SQL code tuning.<br/><br/></p><p><br/>- Data Modeling Design : Collaborate with data architects and business analysts to understand data requirements and contribute to logical and physical data model designs.<br/><br/></p><p><br/>- On-Premise Cloud Operations : Work with Oracle databases deployed in both traditional on-premise data centers and cloud platforms (e.g., Oracle Cloud Infrastructure (OCI), AWS RDS for Oracle, Azure SQL for Oracle).<br/><br/></p><p><br/>- Data Integration : Develop and maintain ETL processes using PL/SQL to facilitate data movement and integration between various financial systems.<br/><br/></p><p><br/>- Regulatory Financial Data Handling : Ensure data integrity, accuracy, and security for financial data, particularly in the context of </p><p>regulatory reporting or core finance operations.<br/><br/></p><p><br/>- Troubleshooting Support : Provide technical support for database-related issues, perform root cause analysis, and implement </p><p>effective solutions.<br/><br/></p><p><br/>- Documentation : Create and maintain technical documentation, including design specifications, data flow diagrams, and support procedures.<br/><br/></p><p><br/>- Collaboration : Work closely with cross-functional teams, including application developers, business analysts, QA engineers, and project Skills and Experience : </b></p><p><br/></p><br/>- Experience : 5-8 years of hands-on experience as an Oracle PL/SQL Developer.<br/><br/></p><p><br/>- Oracle PL/SQL Expertise : Strong proficiency in writing, optimizing, and debugging complex Oracle PL/SQL code, including advanced SQL, stored procedures, functions, packages, and triggers.<br/><br/></p><p><br/>- Database Performance : Demonstrated experience in Oracle database performance tuning, including AWR/ADDM analysis, SQL tuning, and index optimization.<br/><br/></p><p><br/>- On-Premise Cloud Experience : Practical experience working with Oracle databases in both on-premise environments and cloud platforms (e.g., OCI, AWS, Azure).

Familiarity with cloud-specific Oracle services is highly desirable.</p><p><br/></p><p><br/>- Domain Knowledge : Solid understanding of concepts and processes within one or more of the following domains : <br/><br/></p><p><br/>- Capital Markets : Financial instruments (equities, fixed income, derivatives), trading, risk management, post-trade processing.<br/><br/></p><p><br/>- Finance : General ledger, accounting, financial reporting, budgeting, forecasting.<br/><br/></p><p><br/>- Regulatory Reporting : Experience with data requirements and processes for regulatory submissions (e.g., Basel, MiFID, Dodd-Frank, EMIR).<br/><br/></p><p><br/>- Data Analysis : Strong analytical skills with the ability to analyze complex data sets and translate business requirements into technical solutions.<br/><br/></p><p><br/>- Communication : Excellent verbal and written communication Skills and Experience:</b></p><p><br/></p><br/>- Scripting : Experience with shell scripting or Python for database automation tasks.<br/><br/></p><p><br/>- Version Control : Familiarity with version control systems (e.g., Git, SVN).<br/><br/></p><p><br/>- Data Warehousing : Knowledge of data warehousing concepts and ETL tools.<br/><br/></p><p><br/>- Financial Certifications : Relevant certifications (e.g., Oracle Certified Professional, FRM, CFA).<br/><br/></p><p><br/>- Cloud Certifications : Certifications related to cloud platforms (e.g., OCI, AWS, Azure).</p><br/></p> (ref:hirist.tech)

Required Skill Profession

Computer Occupations