hireejobs
Register for Job
Hyderabad Jobs
Banglore Jobs
Chennai Jobs
Delhi Jobs
Ahmedabad Jobs
Mumbai Jobs
Pune Jobs
Vijayawada Jobs
Gurgaon Jobs
Noida Jobs
Oil & Gas Jobs
Banking Jobs
Construction Jobs
Top Management Jobs
IT - Software Jobs
Medical Healthcare Jobs
Purchase / Logistics Jobs
Sales
Ajax Jobs
Designing Jobs
ASP .NET Jobs
Java Jobs
MySQL Jobs
Sap hr Jobs
Software Testing Jobs
Html Jobs
IT Jobs
Logistics Jobs
Customer Service Jobs
Airport Jobs
Banking Jobs
Driver Jobs
Part Time Jobs
Civil Engineering Jobs
Accountant Jobs
Safety Officer Jobs
Nursing Jobs
Civil Engineering Jobs
Hospitality Jobs
Part Time Jobs
Security Jobs
Finance Jobs
Marketing Jobs
Shipping Jobs
Real Estate Jobs
Telecom Jobs

Data Integrator (ODI 12c)cumPLSQL Developer

3.00 to 4.00 Years   Bangalore   13 Aug, 2019
Ernst & Young
Job LocationBangalore
EducationNot Mentioned
SalaryNot Disclosed
IndustryBanking / Financial Services
Functional AreaGeneral / Other Software
EmploymentTypeFull-time

Job Description

  • 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.
,

Keyskills :
sqlsqlserverssisssrsdatabaseadministrationlowleveldesigntestcasessqltuningsqlloaderdataqualityexplainplanleveldesigndatamodelingcledataintegrateuropeanwkscouncils

APPLY NOW

Data Integrator (ODI 12c)cumPLSQL Developer Related Jobs

© 2019 Hireejobs All Rights Reserved