ETL Developer – Oracle PL/SQL

Job Description: ETL Developer – Oracle PL/SQL

Job Title: SSIS ETL Developer / Oracle PL/SQL Developer
Job Location: Hyderabad
Work Mode: Hybrid – 3 days per week from office
Experience: 5–12 Years
Salary: Up to ₹18 LPA for 5–7 years
Up to ₹24–25 LPA for 7–12 years
Notice Period: Immediate Joiners Preferred

Job Summary

We are looking for experienced SSIS ETL Developers with strong expertise in Oracle PL/SQL to work on a data migration project. The role involves migrating existing Oracle Data Integrator (ODI) ETL jobs to SSIS packages and converting SQL scripts and procedures into Oracle database packages and procedures.

Candidates should have hands-on experience in developing and maintaining SSIS packages, writing and optimising Oracle PL/SQL code, and performing data validation and testing.

Key Responsibilities

• Develop, maintain, and optimise SSIS packages, including control flows, loops, variables, connections, and configurations.
• Migrate existing ODI ETL jobs to SSIS packages.
• Convert SQL scripts and procedures into Oracle PL/SQL database packages and procedures.
• Troubleshoot and optimise PL/SQL jobs for improved performance.
• Perform unit testing, system integration testing, and data validation.
• Identify and resolve defects in converted code.
• Prepare and present test summary reports.
• Document ETL jobs, technical specifications, and process flows.
• Collaborate with team members to ensure successful ETL migration and delivery.

Required Skills and Qualifications

• 5–12 years of relevant experience in ETL development and database programming.
• Strong hands-on expertise in SSIS and Oracle PL/SQL.
• Experience developing, maintaining, and troubleshooting SSIS packages.
• Strong knowledge of Oracle SQL, PL/SQL procedures, functions, and database packages.
• Experience converting SQL scripts and procedures into Oracle database packages.
• Knowledge of ETL processes, data migration, and data validation.
• Experience in performance tuning, debugging, and defect resolution.
• Knowledge of Oracle Data Integrator (ODI) is an added advantage.

Preferred Candidate Profile

• Candidates who can join immediately or at short notice.
• Candidates comfortable working in a hybrid model from Hyderabad or Chennai.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to work effectively on ETL migration projects and meet delivery timelines.

Pay: ₹1,700,000.00 - ₹2,400,000.00 per year

Work Location: In person