Oracle PL/SQL & SSIS Developer

Summary

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.
  

• 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.