Oracle PL/SQL & SSIS Developer

Oracle PL/SQL & SSIS Developer

Summary

We are seeking a skilled Oracle PL/SQL & SSIS Developer to join our IT Services team. In this pivotal role, you will design, develop, and maintain robust data integration solutions and database procedures. Your expertise will be essential in ensuring data integrity, optimizing complex queries, and facilitating seamless system interoperability. This position is critical for driving our data infrastructure forward, supporting large-scale operations, and delivering high-quality technical solutions that meet rigorous business standards.

Responsibilities

• Design and construct SSIS packages for efficient data extraction, transformation, and loading (ETL) processes.
• Develop and optimize Oracle PL/SQL scripts, including complex packages, stored procedures, and triggers.
• Execute comprehensive unit testing and system integration testing to validate software functionality and performance.
• Perform thorough data validation activities to ensure accuracy and consistency across all datasets.
• Identify, troubleshoot, and resolve data defects and technical issues promptly.
• Utilize Oracle Data Integrator (ODI) for managing data integration workflows.
• Prepare and maintain detailed technical documentation and generate precise test reports.

Requirements

Requirements:

• Proven experience in Oracle database management, specifically with PL/SQL development and package maintenance.
• Strong proficiency in developing and maintaining SSIS packages for enterprise data solutions.
• Hands-on expertise with Oracle Data Integrator (ODI) for data integration tasks.
• Demonstrated ability to conduct unit testing and system integration testing effectively.
• Solid background in data validation techniques and systematic defect resolution.
• Excellent capability in creating technical documentation and formal test reporting.
• Relevant work experience ranging from 5 to 12 years in the specified domain.