4-7 Years years of experience in ETL development, with at least 4+ years in Oracle Data Integrator (ODI 11g/12c).
- Strong knowledge of SQL, PL/SQL, and data modeling concepts.
- Experience integrating with Oracle databases, and other data sources like flat files, REST APIs, or ERP systems.
- Solid understanding of data warehousing concepts, star/snowflake schemas, and dimensional modeling.
- Familiarity with performance tuning of ETL jobs and SQL queries.
- Hands-on experience with error handling, logging, auditing, and exception management in ODI.
- Experience in using ODI Variables, Knowledge Modules (KM), and Load Plans.
- Knowledge of Oracle BI, OBIEE, or other BI tools is a plus.
Exposure to cloud platforms (e.g., OCI, Azure, AWS) is an advantage.