Add office photos
Engaged Employer
i
This company page is being actively managed by
Ernst & Young Team. If you also belong to the team, you
can get access from
here
Ernst & Young
Compare
All Filters
2013 Ernst & Young Jobs
GIG-Oracle Advanced Engineering-ODI PLSQL-Senior
3-8 years
Bangalore / Bengaluru
1 vacancy
GIG-Oracle Advanced Engineering-ODI PLSQL-Senior
Ernst & Young
posted 1mon ago
Job Role Insights
Flexible timing
Key skills for the job
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 descriptionPrepare for Advanced Engineer roles with real interview advice
People are getting interviews at Ernst & Young through
People are getting interviews through
(based on 759 Ernst & Young interviews)
Job Portal
Referral
Campus Placement
Company Website
Recruitment Consultant
Walkin
29%
21%
14%
8%
6%
4%
18% candidates got the interview through other sources.
High
Confidence
?
High Confidence means the data is based on a large number of responses received from the candidates.
What people at Ernst & Young are saying
Advanced Engineer salary at Ernst & Young
reported by
1
employee
with 5
years exp.
₹13.1
L/yr - ₹16.7
L/yr
22%
more
than the average Advanced Engineer Salary in India
View more details
What Ernst & Young employees are saying about work life
based on 10k employees
Flexible timing
Monday to Friday
No travel
Day Shift
Ernst & Young Benefits
View more benefits
Compare Ernst & Young with
Deloitte
Compare
PwC
Compare
EY Global Delivery Services ( EY GDS)
Compare
Accenture
Compare
Cognizant
Compare
TCS
Compare
Amazon
Compare
Wipro
Compare
Capgemini
Compare
IBM
Compare
Compare
Microsoft Corporation
Compare
Infosys
Compare
KPMG India
Compare
Bain & Company
Compare
McKinsey & Company
Compare
BCG
Compare
ZS
Compare
Mercer
Compare
Willis Towers Watson
Compare
Similar Jobs for you
Ernst & Young Bangalore / Bengaluru Office Locations
Bangalore Office
Ernst & Young, 3rd Floor, Tower C, RMZ Infinity Municipal No. 3, Survey No 1477/2 & 10, Old Madras Road, Benniganahalli, K.R. Puram
Bangalore
Karnataka 560016
Karnataka 560016
Bengaluru Office
Ernst & Young
Tower C, 3rd Floor, RMZ Infinity
Municipal No. 3, Old Madras Road
Survey No 1477/2 & 10
Benniganahalli, K.R. Puram
560016 Bengaluru
Ernst & Young
UB City, Canberra Block
12th & 13th Floor
No. 24, Vittal Mallya Road
Bengaluru
Bengaluru
560001
560001
GIG-Oracle Advanced Engineering-ODI PLSQL-Senior
3-8 Yrs
Bangalore / Bengaluru
SAC Planning Functional Consultant
3-7 Yrs
₹ 8 - 18L/yr
Kolkata, Hyderabad / Secunderabad, Bangalore / Bengaluru
Share an Interview