: ETL Developer – Oracle PL/SQL

Job Title: SSIS ETL Developer / Oracle PL/SQL Developer

Job Location:Chennai

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

📌 ETL Developer – Oracle PL/SQL (Chennai)
🏢 GlobalConsultings
📍 Chennai