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
Budget: Experience2.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
Experience: 5 to 10 Years (Relevant Experience only)
Location: Mumbai (WFO)
Notice Period: 15 to 30 Days
Position: Permanent
Budget: Experience2.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
💡 Quick Summary
Seeking a career-building opportunity? The Oracle Database integrator position is now open for candidates interested in the Database Administrator sector. This role in Pune offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.