Senior Oracle Data Integrator (ODI) ETL Developer

Technical Expertise

Core Expertise In Oracle Data Integrator (ODI)

1. Proficiency in designing and implementing data integration solutions using ODI 12c or later versions.
2. Strong knowledge of:
3. Knowledge Modules (KM): Creating and customizing reusable components for data integration processes.
4. Mappings, Packages, and Scenarios: Designing complex data flows, workflows, and automating ETL processes.
5. Topology Configuration: Configuring physical and logical schemas, data servers, and agents.
6. Expertise in ODI's ELT framework and knowledge of performance optimization techniques.
7. Experience in error handling, reconciliation frameworks, and debugging ODI processes.

Database Skills

1. Strong SQL and PL/SQL skills for querying, transforming, and managing data.
2. Deep knowledge of Oracle Database concepts, including:
3. Indexing, partitioning, and materialized views.
4. Query optimization techniques.

Familiarity with other databases like SQL Server, MySQL, or PostgreSQL is advantageous.

Data Warehousing And ETL Concepts

1. In-depth understanding of:
2. Dimensional modeling (Star and Snowflake schemas).
3. Fact and dimension tables, surrogate keys, slowly changing dimensions (SCDs), and hierarchies.
4. Data profiling, data cleansing, and data validation practices.
5. Hands-on experience in building and maintaining data warehouses and data lakes.

Experience And Professional Expertise

1. 5+ years of hands-on experience in developing and managing ETL/ELT processes using ODI.
2. Proven experience in implementing large-scale, end-to-end data integration projects, including:
3. Requirements gathering
4. Data modeling
5. Designing scalable ETL/ELT solutions.
6. Experience in upgrading or migrating ODI environments (e.g., from ODI 11g to 12c).