Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Engaged Employer

Ernst & Young

Compare

3.4

based on 11.1k Reviews

Video summary

2179 Ernst & Young Jobs

GIG-Oracle Advanced Engineering-ODI PLSQL-Senior

Ernst Young

3.4

based on 11.1k Reviews

3-8 years

Bangalore / Bengaluru

1 vacancy

GIG-Oracle Advanced Engineering-ODI PLSQL-Senior

Ernst & Young

posted 4mon ago

Job Role Insights

Flexible timing

Key skills for the job

Medical Coding Consulting Oracle Automation Testing CCTV Monitoring Data Structures and Algorithms

+ 3 more

Job Description

EY-Consulting - ODI Staff, Senior

The opportunity

We are looking for Staff and Senior level candidates with a good working experience in Data warehousing, Data Integration using ETL tool Oracle Data Integrator (ODI), Oracle SQL and PL/SQL. Knowledge on other ETL tools and databases is an added advantage. As a problem-solver with the keen ability to diagnose a client s unique needs, one should be able to see the gap between where clients currently are and where they need to be. The candidate should be capable of creating a blueprint to help clients achieve their end goal.

Your key responsibilities :

Overall having 3-15 years of ETL Lead / developer experience and a minimum of 2-3 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.

Education:

BTech / MTech / MCA / MBA

Employment Type: Full Time, Permanent

Read full job description

Prepare for Advanced Engineer roles with real interview advice

Top Ernst & Young Advanced Engineer Interview Questions

Q1. 1. What is Virtual DOM? How does it work & Its algorithm? 2. React component life cycle in detail? 3. Higher-order components? 4. Basic ... read more

asked in Senior Consultant interview

View answer (1)

Q2. Covid Vaccination Distribution Problem As the Government ramps up vaccination drives to combat the second wave of Covid-19, you are tasked ... read more

asked in React Developer interview

View answer (1)

Q3. If a 30 gms of gold was bought at London what will be duty charged on it

asked in Tax Analyst interview

View answers (2)

View all 657 questions