- Were Hiring | Oracle PL/SQL & SSIS Developer.

Job Location: - Hyderabad & Chennai (Hybrid, 3 days in week from office).

Experience Required: - 7+ Years.

Notice Period: - Immediate Joiners or = 30 Days Preferred.

Skills (Required): - 6+ years in Oracle PL/SQL & SSIS development.

Job Requirements & Skills: -

- 6+ years of hands-on experience in Oracle PL/SQL and SSIS development.
- Strong expertise in Oracle PL/SQL, including packages, procedures, functions, cursors, collections, exception handling, and performance tuning.
- Strong hands-on experience developing and maintaining SSIS packages.
- Good understanding of SSIS components such as: - Control Flow, Data Flow, Execute SQL Task, For Each Loop, Variables and Expressions, Connection Managers, Configurations/Parameters & Error Handling and Logging.
- Experience converting Oracle/ODI code into Oracle database packages and procedures.
- Strong SQL development and debugging skills.
- Experience in ETL development, data migration, data validation, and defect resolution.
- Valuable understanding of ETL testing and reconciliation processes.
- Ability to analyse existing ETL workflows and translate them into SSIS packages and Oracle PL/SQL solutions.
- Good documentation and communication skills.

Job Key Responsibilities: -

- Develop,



maintain, and enhance SSIS packages, including control flows, data flows, loops, variables, connections, configurations, and error handling.
- Migrate and convert existing ODI ETL jobs into SSIS-based solutions.
- Convert ODI SQL, mappings, and procedures into Oracle PL/SQL database packages and stored procedures.
- Develop and maintain robust, reusable Oracle PL/SQL packages and procedures.
- Troubleshoot, debug, and optimize PL/SQL jobs for improved performance and reliability.
- Perform unit testing, system integration testing (SIT), and data validation for migrated ETL processes.
- Analyse and resolve defects identified during development and testing.
- Validate source-to-target data and ensure accuracy of migrated ETL processes.
- Prepare and present test summary reports and provide status updates to project stakeholders.
- Document ETL jobs, technical specifications, mappings, process flows, and migration details.
- Collaborate with technical and functional teams to understand existing ODI workflows and translate them into SSIS/Oracle solutions.
- Support production deployment, post-deployment validation, and issue resolution as required.

📌 Oracle PL/SQL & SSIS Developer (Hyderabad)
🏢 Eduplex Consultancy Services
📍 Hyderabad