Design, develop, and maintain ETL/ELT processes using Oracle Data Integrator (ODI).
Develop, enhance, and optimize complex PL/SQL packages, procedures, functions, triggers, and scripts.
Build and support data integration workflows between multiple source and target systems.
Perform data extraction, transformation, and loading activities for enterprise data warehouse environments.
Analyze business and technical requirements and translate them into robust data solutions.
Monitor and troubleshoot data pipelines, ETL jobs, and database performance issues.
Implement performance tuning strategies for Oracle databases and PL/SQL programs.
Ensure data quality, consistency, integrity, and security across data platforms.
Collaborate with data architects, business analysts, reporting teams, and application developers.
Create and maintain technical design documents, ETL specifications, and operational runbooks.
Support production environments and participate in incident resolution and root cause analysis.