What are the responsibilities and job description for the Oracle PL/SQL Developer position at Ztek Consulting?
Job Details
Job Role Oracle PL/SQL Developer
Job Type - Full-Time Employment
Location Armonk, NY
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 the 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.
- Led 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.
- An 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.
ABOUT Ztek:
Website:
Ztek Consulting Inc is a minority- and woman-owned business enterprise that leverages a unique blend of human talent, machine learning algorithms, and artificial intelligence to provide customized talent management solutions for clients. Ztek s diversity-focused hiring models have proven successful, particularly in hiring veterans. The company's veteran-focused hiring and deployment program, Z-V.E.T, matches skilled veterans with clients' needs in various areas.
Ztek Consulting | Talent Matters
Ztek is a minority and woman-owned business enterprise that provides customized talent management solutions for clients.
