Oracle PL/SQL + SSIS Developer

Agile Turn Technology; Hyderabad, Chennai District; On-site; INR 1,000,000 - 1,800,000; Full time

Job summary

Agile Turn Technology in Hyderabad, India seeks a senior ETL developer with strong Oracle PL/SQL and SSIS expertise to convert ODI jobs to Oracle packages and maintain existing ETL workloads. You will troubleshoot PL/SQL, participate in testing, and document data workflows.

The role requires 5+ years of hands-on SSIS experience and ODI knowledge for conversion projects, with an emphasis on performance tuning and accurate reporting.

Qualifications

• Strong technical expertise in Oracle PL/SQL and SSIS
• 5+ 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

Responsibilities

• 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
• Document ETL jobs, technical specifications, and process flows
• Defect fixes on converted code
• Prepare and present test summary report
• Convert ODI jobs into Oracle PL/SQL database packages and procedures

Skills

Oracle PL/SQL

SSIS

Job description

• 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