Oracle PL/SQL + SSIS Developer

• Create/maintain SSIS packages (control flow, loops, variables, connections, configs).
• Convert ODI SQL/procedures into Oracle DB packages and procedures.
• Troubleshoot and optimise PL/SQL jobs for improved performance.
• Participate in unit testing and system integration testing.
• Participate in data validation.
• Defect fixes on converted code.
• Prepare and present test summary report.
• Document ETL jobs, technical specifications, and process flows.
• Convert ODI jobs into Oracle PL/SQL database packages and procedures.

Required Skills and Experience

• Strong technical expertise in Oracle PL/SQL and SSIS.
• At least five years of experience developing Oracle PL/SQL and SSIS packages.
• Experience converting Oracle code into database packages and procedures.
• Hands-on experience developing and maintaining SSIS packages.
• Knowledge of ODI is desirable.Role & responsibilities

Preferred candidate profile