Oracle Data Integrator_Deepashi_Techfour

Published date: 2024/01/10
  • Location: West Bengal, West Bengal, India
Full–time
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 deep-set commitment to our clients, comprehensive industry expertise, and a global network of innovation and delivery centers.

Location: Kolkata (Work From Office)

Position: Permanent with Coders Brain Technology Pvt. Ltd.

Notice Period: 20 Days Maximum.

Experience- 4 + Yrs

Skill-Oracle Odi, Pl Sql, Etl

JD-

xpertise 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 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 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

Experience in understanding complex source system data structures preferably in Financial services (preferred) Industry.

Skills: oracle odi,pl sql,etl
Company Name: CodersBrain

Contact seller

0 page views

Related listings

  • Data Administrator
    Database Administrator
    Database Administrator
    Full–time We’re hiring a Database Admin for our client, a to join their growing team. This is a 12 months and extendable contractual position for Gurgaon location and Travel to Barmer as required by client Your Tasks • Roles and Responsibility: • Ass...
    2024/01/10
  • Interesting Job Opportunity: Database Engineer/Senior Engineer - SQL
    Database Administrator
    Database Administrator
    Full–time Job Description • Strong algorithm and logic building capability • Ability to Prototype rapidly • Deep understanding of Entity-Relationship concept and Normalization/Denormalization • Experience in indexing and performance monitoring and tu...
    2024/01/10
  • Microsoft SQL Server Database Administration Cloud Platform Engineer
    Database Administrator
    Database Administrator
    Full–time About Accenture: Accenture is a global professional services company with leading capabilities in digital, cloud and security. Combining unmatched experience and specialized skills across more than 40 industries, we offer Strategy and Consu...
    2024/01/10