- 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
- Solid 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