Oracle Data Integrator (ODI) ETL Developer

VAM Systems is currently looking for  Oracle Data Integrator (ODI) ETL Developer for our UAE operations with the following skillsets & terms and conditions:

Experience and Professional Expertise

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

Certifications (Optional but Advantageous)

• Oracle Data Integrator (ODI) Certification
• Oracle Database SQL Certified Associate
• Certifications in data integration or related tools (e.g., Informatica, Talend) as complementary skills.

Technical Expertise

Core Expertise in Oracle Data Integrator (ODI):

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

Database Skills:

• Strong SQL and PL/SQL skills for querying, transforming, and managing data.
• Deep knowledge of Oracle Database concepts, including:
  • Indexing, partitioning, and materialized views.
  • Query optimization techniques.
• Familiarity with other databases like SQL Server, MySQL, or PostgreSQL is advantageous.

Data Warehousing and ETL Concepts:

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

Joining time frame: (15 - 30 days)

Terms and conditions: 

Joining time frame:   maximum 4 weeks