Sr. Oracle Pl/SQL Developer

Role: Sr. Oracle PL/SQL Developer

Location: Armonk, NY - Fulltime Position

Job Description:

We are looking for an experienced Senior PL/SQL Developer with a minimum of 10+ years of experience to join our team. The ideal candidate will play a pivotal role in a high-impact transformation program that involves the design, development, and implementation of complex financial routines within Valuations area aimed at automating and simplifying existing manual processes.

Responsibilities:

• Collaborate with stakeholders to gather and understand business requirements, ensuring that solutions align with organizational goals, particularly in the reinsurance domain.
• Lead the design and development of complex Oracle PL/SQL packages, procedures, and queries, with a strong focus on performance tuning and scalability.
• Manage data transformation and migration processes, ensuring data integrity and consistency, while handling large data volumes using advanced partitioning techniques.
• Drive the performance optimization of PL/SQL code by tuning queries and procedures to efficiently manage high data volumes and resolve performance bottlenecks.
• Implement and debug intricate financial routines, working closely with cross-functional teams to deliver robust solutions.
• Provide expert insights into PL/SQL best practices, data management strategies, and integration solutions, contributing to technical discussions and solutioning efforts.
• Work with the change management team to ensure smooth implementation of system changes, adhering to project timelines and maintaining high-quality standards.
• Communicate technical concepts and solutions effectively to both technical and non-technical stakeholders.

Qualifications:

• Extensive hands-on experience with Oracle PL/SQL, including performance tuning, dynamic SQL, and advanced query development.
• Proven ability to manage large volumes of data, with expertise in data partitioning and performance optimization.
• Strong background in Data Warehousing projects with a deep understanding of Data Warehousing concepts, including ETL processes, data modeling, and data integration.
• Experience with ETL tools is a plus, with a preference for Informatica PowerCenter.
• Solid background in data transformation and migration, particularly with complex financial datasets.
• In-depth understanding of reinsurance processes and valuation systems is highly desirable.
• Demonstrated leadership in technical discussions and effective collaboration with business stakeholders.
• Excellent problem-solving skills with a proactive approach to identifying and addressing challenges.