Oracle Database integrator

Skillset: Oracle Data Integrator

Experience: 5 to 10 Years (Relevant Experience only)

Location: Mumbai (WFO)

Notice Period: 15 to 30 Days

Position: Permanent

Budget: Experience*2.5

Job Description
• Minimum 5+ years of hands-on with end-to-end DWH Implementation experience using ODI.
• 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.
• Expertise in the Oracle ODI tool set and Oracle PL/SQL, ODI
• knowledge of ODI Master and work repository
• Knowledge of data modelling and ETL design
• Setting up topology, building objects in Designer, Monitoring Operator, different types of KMs, 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
• Ability to design ETL unit test cases and debug ETL Mappings
• Expertise in developing Load Plans, Scheduling Jobs
• Ability to design data quality and reconciliation framework using ODI
• Integrate ODI with multiple Sources / Target
• Experience in Error recycling/management using ODI, PL/SQL
• Expertise in database development (SQL/ PLSQL) for PL/SQL-based applications.
• Experience in creating PL/SQL packages, procedures, Functions, Triggers, views, Mat Views, and exception handling for retrieving, manipulating, checking, and migrating complex datasets in oracle
• Experience in Data Migration using SQL loader, import/export
• Experience in SQL tuning and optimization using explain plan and SQL trace files.
• Strong knowledge of ELT/ETL concepts, design, and coding

Partitioning and Indexing strategy for optimal performance