hireejobs
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

EA-ODI/PLSQL Senior Consultant

3.00 to 4.00 Years   Kolkata   09 Jul, 2020
Job LocationKolkata
EducationNot Mentioned
SalaryNot Disclosed
IndustryBanking / Financial Services
Functional AreaOperations Management / Process Analysis
EmploymentTypeFull-time

Job Description

The opportunityWe re looking for Senior Consultant with expertise in ODI and PLSQL to join the leadership group of our Advisory Team. This is a fantastic opportunity to be part of a leading firm whilst being instrumental in the growth of a new service offering.Your key responsibilities

  • Support client needs by delivering ODI jobs and frameworks
  • Support client needs by delivering Various Integrations with third party application
  • Merge, Customize and Deploy ODI data model as per client business requirements
  • Experience working with clients throughout various parts of implementation lifecycle
  • Proactive with Solution oriented mindset, ready to learn new technologies for Client requirements.
Skills and attributes for success
  • Deliver large/medium DWH programmes, demonstrate expert core consulting skills and advanced level of ODI, SQL, PL/SQL knowledge and industry expertise to support delivery to clients
  • Perform an appropriate role in business development in terms of presales and practice development. for example, presales, internal engagement and / or knowledge management
  • Demonstrate management and an ability to conduct and lead consultancy assignments
To qualify for the role, you must have
  • 6+ years ETL Lead / developer experience and a minimum of 3-4 Years experience in Oracle Data Integrator (ODI)
  • Expertise in the Oracle ODI toolset and Oracle PL/SQL, 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.
  • knowledge of ODI Master and work repository
  • Knowledge of data modelling and ETL design
  • Design and develop complex mappings, Process Flows and ETL scripts
  • Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
  • 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
  • Integrate ODI with multiple Source / Target
  • Experience in Data Migration using SQL loader, import/export
Ideally, you ll also have
  • 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 Oracle object such as
  • Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functionsWorking knowledge of GIT or similar source code control system
  • 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.
What we look for
  • The incumbent should be able to drive ODI Infrastructure related developments. Additional knowledge of complex source system data structures preferably in Financial services (preferred) Industry and reporting related developments will be an advantage.
  • An opportunity to be a part of market-leading, multi-disciplinary team of 10000 + professionals, in the only integrated global transaction business worldwide.
  • Opportunities to work with EY Advisory practices globally with leading businesses across a range of industries
,

Keyskills :
data migrationsqlsapdeliverydata modelingsql loadersalescustomer relationsdata qualitydata structuresoracle data integratorfortune 500explain plansql tuningtest casesworking with clientseuropean works councils

EA-ODI/PLSQL Senior Consultant Related Jobs

© 2019 Hireejobs All Rights Reserved