Oracle Advanced Engineering-ODI PLSQL-Senior

As a Staff or Senior level candidate with experience in Data warehousing and Data Integration using ETL tool Oracle Data Integrator (ODI), Oracle SQL and PL/SQL, you will play a crucial role in helping clients achieve their end goals. **Key Responsibilities:** - Overall 3-15 years of ETL Lead/developer experience with a minimum of 2-3 years experience in Oracle Data Integrator (ODI). - Minimum 2-3 end-to-end Data Warehouse Implementation experience. - Development of ETL processes including ETL control tables, error logging, auditing, and data quality. Implementation of reusability, parameterization, workflow design, etc. - Expertise in Oracle ODI toolset, Oracle PL/SQL, ODI Master, and work repository. - Proficiency in data modelling, ETL design, setting up topology, building objects in Designer, monitoring operator, and using different types of KMs, Agents, etc. - Design and development of complex mappings, Process Flows, and ETL scripts. - Hands-on experience in using and customizing Knowledge Modules (KM), performance tuning of mappings, designing ETL unit test cases, debugging ETL Mappings. - Development of Load Plans, Scheduling Jobs, designing data quality and reconciliation framework using ODI. - Integration of ODI with multiple Source/Target systems, error recycling/management using ODI, PL/SQL. - Database development using SQL/PLSQL for PL/SQL based applications, creating PL/SQL packages, procedures, Functions, Triggers, views, Mat Views, and exception handling. - Data Migration using Sql loader, import/export, SQL tuning, optimization, partitioning, and Indexing strategy for optimal performance. - Strong knowledge of ELT/ETL concepts, design, and coding. - Good verbal and written communication in English, Strong interpersonal, analytical, and problem-solving abilities. - Experience in interacting with customers, understanding business requirements, and translating them into ETL specifications and design documents. - Understanding complex source system data structures preferably in Financial services industry. - Ability to work independently with minimal guidance or supervision in a time-critical environment. **Education:** - BTech / MTech / MCA / MBA Join EY to be part of a diverse global team that exists to build a better working world, providing trust through assurance, helping clients grow, transform, and operate across various sectors.,