Key Responsibilities

- Code Migration: Analyze and reverse-engineer existing ETL mappings, packages, and

load plans within Oracle Data Integrator (ODI).
- PL/SQL Development: Convert legacy ODI logic into effective, maintainable, and highly

optimized Oracle PL/SQL stored procedures, packages, functions, and triggers.
- Orchestration & Integration: Design, develop, and deploy SSIS packages tasked with

connecting to Oracle environments and triggering the newly created PL/SQL blocks.
- Performance Tuning: Optimize complex SQL queries and PL/SQL code to ensure peak

database performance during heavy ETL cycles.
- Testing & Validation: Conduct rigorous data validation, unit testing, and integration

testing to ensure zero data loss or logic drift between legacy and new architectures.
- Documentation: Provide thorough technical documentation outlining mapping logic,

structural changes, and SSIS control flow logic throughout the project lifecycle.





Required Skills & Qualifications

- Oracle Data Integrator (ODI): Strong conceptual understanding of ODI architectures

(Models, Mappings, Knowledge Modules, and Load Plans) to extract legacy logic.
- Oracle PL/SQL: Expert-level mastery of PL/SQL programming, database design, query

optimization, and performance tuning.
- SQL Server Integration Services (SSIS): Hands-on experience building and

maintaining SSIS projects, deployment to the SSIS Catalog, and managing control flow tasks (specifically Execute SQL Tasks interacting with Oracle providers).
- Database Connectivity: Demonstrated experience configuring heterogeneous data

source connections (e.g., Attunity, OLE DB, or ODBC drivers) between Microsoft and

Oracle ecosystems.

📌 PLSQL Developer (Bengaluru)
🏢 Randstad
📍 Bengaluru