Oracle Data Integration FDI & ODI
.Oracle Data Integrator (ODI):
• 6+ years ETL Lead / developer experience and a minimum of 3-4 Years’ experience in Oracle Data Integrator (ODI)
• Expertise in the Oracle ODI toolset and Oracle PL/SQL, ODI
• Minimum 2-3 end to end DWH Implementation experience.
• Should have experience in developing ETL processes - ETL control tables, error logging, auditing, data quality, etc. Should be able to implement reusability, parameterization, workflow design, etc.
• knowledge of ODI Master and work repository
• Knowledge of data modelling and ETL design
• Design and develop complex mappings, Process Flows and ETL scripts
• Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
• Setting up topology, building objects in Designer, Monitoring Operator, different type of KM’s, Agents etc.
• Packaging components, database operations like Aggregate pivot, union etc.
• Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects
• Design and develop complex mappings, Process Flows and ETL scripts
• Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
• Experience of performance tuning of mappings
Oracle Analytics Cloud (OAC)/ Fusion Data Intelligence (FDI) Specialist:
• Excellent development skills utilizing all aspects of OAC
• Strong knowledge of RPD, OAC reports, Data Visualizations, SQL
• Strong knowledge of SQL and PL/SQL is foundational to optimize query performance
• Experience with one or more relational databases on Oracle
• Exposure to Oracle cloud migrations and OBIEE upgrades
• Experience in developing applications on Oracle Cloud infrastructure
• Experience working with ODI tool
• Fair understanding of the agile development process
• Exposure to Oracle Cloud scripts using CURL
• Excellent understanding of Oracle Cloud platform and services
• Familiarity working with DevOps tools, deployment and orchestration technologies
• Familiarity in developing applications on OAC Cloud infrastructure.
• Familiarity with Business Continuity and Disaster Recovery design and implementation for cloud infrastructures