AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
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
1621 Ernst & Young Jobs
Oracle Advanced Engineering-ODI-PLSQL-Senior
Ernst & Young
posted 25d ago
Job Role Insights
Flexible timing
Key skills for the job
Job Description
- 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
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
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
Q3. Risk management experience and audit work experience?
asked in
Senior Consultant interview
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
21%
more
than the average Advanced Engineer Salary in India
View more details
What Ernst & Young employees are saying about work life
based on 10.8k 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 Noida Office Locations
Noida Office
Glycols Limited, Commercial Complex
4th & 5th Floor, Plot No 2B, Tower 2,
Sector 126
Noida (Glycols Ltd)
Noida
201-304
201-304
Noida Office
Glycols Limited, Commercial Complex,4th & 5th Floor,Plot No 2B, Tower 2,Sector 126,201-304 Noida (Glycols Ltd)
Noida
Uttar Pradesh 201313
Uttar Pradesh 201313
Graphic Designer-L and D Global-Contract For 3 months
1-6 Yrs
Kochi, Bangalore / Bengaluru
Oracle HCM Cloud Payroll Functional Consultant
3-7 Yrs
Hyderabad / Secunderabad, Bangalore / Bengaluru, Delhi/Ncr
Share an Interview