Oracle Data Integrator (ODI)-cum-PLSQL
Bengaluru (Bangalore Urban) IT development
Job description
Expert on technical environment/ tools for own area of expertise
· Knowledge on business processes and procedures, as well as broader organizational issues and technology
· Should be able to assist with design, development, integration, performance tuning, rollout, support and optimization during implementation of data-mart build-out.
· Work with business users globally to clarify ETL requirements and business rules for the implementation of solutions and problem resolution.
· Understand pre-designed Financial Services -specific target data models, metadata layer, data marts and ETL processes
· Experience with Oracle database, SQL queries, stored procedures, for interfacing with the database and database designs
· Design, develop, implement, troubleshoot, optimize, and tune ETL processes
· Create and execute unit test plans based on system and validation requirements.
· Ensure that all timelines of loading/validating data are met
Requirements:
· Overall having 6+ years of ETL Lead / developer experience and a minimum of 3-4 Years’ experience in Oracle Data Integrator (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.
· Expertise in the Oracle ODI toolset 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 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
· 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 Source / Target
· Experience on Error recycling / management using ODI
PL/SQL
· Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
· Experience of 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
· Must have Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
· Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High and Low level design documents.
· Experience in understanding complex source system data structures preferably in Financial services (preferred) Industry
· Ability to work with minimal guidance or supervision in a time critical environment.
· Expert on technical environment/ tools for own area of expertise
· Knowledge on business processes and procedures, as well as broader organizational issues and technology
· Should be able to assist with design, development, integration, performance tuning, rollout, support and optimization during implementation of data-mart build-out.
· Work with business users globally to clarify ETL requirements and business rules for the implementation of solutions and problem resolution.
· Understand pre-designed Financial Services -specific target data models, metadata layer, data marts and ETL processes
· Experience with Oracle database, SQL queries, stored procedures, for interfacing with the database and database designs
· Design, develop, implement, troubleshoot, optimize, and tune ETL processes
· Create and execute unit test plans based on system and validation requirements.
· Ensure that all timelines of loading/validating data are met
Requirements:
· Overall having 6+ years of ETL Lead / developer experience and a minimum of 3-4 Years’ experience in Oracle Data Integrator (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.
· Expertise in the Oracle ODI toolset 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 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
· 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 Source / Target
· Experience on Error recycling / management using ODI
PL/SQL
· Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
· Experience of 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
· Must have Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
· Should have experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High and Low level design documents.
· Experience in understanding complex source system data structures preferably in Financial services (preferred) Industry
· Ability to work with minimal guidance or supervision in a time critical environment.