Chief Technical Manager-Data Engineer

Job Description

Job Description

Oracle Data Integrator (ODI 12C) Senior Consultant Job Description

The opportunity

We're looking for Senior Consultant with expertise in Oracle Data Integrator with 10 years of experience. Experience in Banking Industries and a good understanding of Core Banking systems/flow is preferred.

• Support client needs by delivering ODI jobs and frameworks
• Support client needs by delivering Various Integrations with third party application
• Merge, Customize and Deploy data model as per client business requirements
• Experience working with clients throughout various parts of implementation lifecycle
• Proactive with Solution oriented mind-set, ready to learn new technologies for Client requirements.

• Deliver large/medium DWH programmes, demonstrate expert core consulting skills and advanced level of ODI 12C knowledge and industry expertise to support delivery to clients

• Minimum of 10 Years experience in Oracle Data Integrator (Development + Admin) and DWH concepts
• Minimum 4-6 end to end DWH Implementation experience.
• Should have experience in using Python codes in ODI.
• Auditing, data quality, etc. Should be able to implement reusability, parameterization,

• Integrate with multiple Source / Target (through APIs, Webservices etc.)
• Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
• Knowledge of data modelling and ETL design
• Design and develop complex mappings, Process Flow, Load Plans and ETL scripts
• 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 ETL mappings, error handling, automation, Load plans, Migration of Objects
• Design and develop complex mappings, Process Flows and ETL scripts
• Experience of performance tuning of mappings
• Ability to design ETL unit test cases and debug ETL Mappings
• Expertise in developing Load Plans, Scheduling Jobs
• Experience in Data Migration using SQL loader, import/export

• Strong knowledge of ELT/ETL concepts, design and coding
• Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.
• Experience in designing and developing ODI objects such as
• Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions. Experience of creating PL/SQL packages, procedures, Functions, Triggers, views, and exception handling for retrieving, manipulating, checking and migrating complex datasets in oracle
• Experience in SQL tuning and optimization using explain plan and SQL trace files
• Partitioning and Indexing strategy for optimal performance
• Good verbal and written communication in English, Strong interpersonal, analytical and problem-solving abilities.
• Experience of interacting with customers in understanding business requirement documents and translating them into ETL specifications and High- and Low-level design documents.
• BFSI functional knowledge is an added advantage.
• The incumbent should be able to drive ODI related developments.
• Additional knowledge of complex source system data structures preferably in financial services (preferred) Industry and reporting related developments will be an advantage.