Oracle Data Integrator -Nivita-codersbrain
Location
Mumbai | India
Job description
Skillset: Oracle Data Integrator
Experience 5 to 10 Years (Relevant Experience only)
Location Mumbai (WFO) Notice Period 15 to 30 Days
Position Permanent with Deloitte SPOC 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
Skills: oracle,sql,plsql
Job tags
Salary