Offer summary

Qualifications:

Minimum 4 years of experience in Oracle ODI and PL/SQL., Strong knowledge of data modeling and ETL design., Hands-on experience with ODI components like mappings, load plans, and error handling., Proficiency in database development, SQL tuning, and performance optimization..

Key responsibilities:

Design and develop complex ETL mappings and process flows.

Set up ODI topology, build objects, and monitor operations.

Implement data quality frameworks and manage data migration tasks.

Optimize performance and troubleshoot ETL processes.

Job description

Greetings from Coders Brain Technology Pvt. Ltd.
Coders Brain is a global leader in its services, digital, and business solutions that partners with its clients to simplify, strengthen, and transform their businesses. We ensure the highest levels of certainty and satisfaction through a deepset commitment to our clients, comprehensive industry expertise, and a global network of innovation and delivery centers.

Experience: 4+ years
Location: Kolkata

Job Description:Xpertise in the Oracle ODI toolset and Oracle PLSQL,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 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 handson 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,PLSQL
Expertise in database development (SQL PLSQL) for PLSQL based applications.
Experience of creating PLSQL 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, importexport
Experience in SQL tuning and optimization using explain plan and Sql trace files.
Strong knowledge of ELTETL concepts, design and coding
Partitioning and Indexing strategy for optimal performance
Experience in understanding complex source system data structures preferably in Financial services (preferred) Industry

If you are interested then click on apply button else send your resume on bharti@codersbrain.com or connect with me on
7654745144

Thanks and regards
Bharti
HR Executive
7654745144