Company Description
Job Description
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)
Additional Information
Terms and conditions:
Joining time frame: maximum 4 weeks