filter salaries All Filters

13 Advanced Engineer Jobs

GIG-Oracle Advanced Engineering-ODI PLSQL-Senior

3-15 years

Noida

1 vacancy

GIG-Oracle Advanced Engineering-ODI PLSQL-Senior

Ernst & Young

posted 5d ago

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 description

Prepare for Advanced Engineer roles with real interview advice

What Advanced Engineer at Ernst & Young are saying

Advanced Engineer salary at Ernst & Young

reported by 1 employee with 5 years exp.
Lock Unlock
₹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
73%
90%
53%
92%
Flexible timing
Monday to Friday
No travel
Day Shift
View more insights

Ernst & Young Benefits

Work From Home
Soft Skill Training
Health Insurance
Job Training
Team Outings
Cafeteria +6 more
View more benefits

Compare Ernst & Young with

Deloitte

3.8
Compare

PwC

3.4
Compare

EY Global Delivery Services ( EY GDS)

3.6
Compare

Accenture

3.8
Compare

Cognizant

3.7
Compare

TCS

3.7
Compare

Amazon

4.1
Compare

Wipro

3.7
Compare

Capgemini

3.7
Compare

IBM

4.0
Compare

Google

4.4
Compare

Microsoft Corporation

4.0
Compare

Infosys

3.6
Compare

KPMG India

3.5
Compare

Bain & Company

3.8
Compare

McKinsey & Company

3.8
Compare

BCG

3.7
Compare

ZS

3.3
Compare

Mercer

3.7
Compare

Willis Towers Watson

3.8
Compare

Similar Jobs for you

Advanced Engineer at Ernst Young

Noida

7-11 Yrs

₹ 14-19 LPA

Advanced Engineer at Ernst Young

Thiruvananthapuram

7-11 Yrs

₹ 14-19 LPA

Advanced Engineer at Ernst Young

Mumbai

7-11 Yrs

₹ 14-19 LPA

Advanced Engineer at Ernst Young

Hyderabad / Secunderabad

7-11 Yrs

₹ 14-19 LPA

Advanced Engineer at Ernst Young

Pune

7-11 Yrs

₹ 14-19 LPA

Advanced Engineer at Ernst Young

Bangalore / Bengaluru

7-11 Yrs

₹ 14-19 LPA

Advanced Engineer at Ernst Young

Kanayannur

7-11 Yrs

₹ 14-19 LPA

Advanced Engineer at Ernst Young

Kolkata

7-11 Yrs

₹ 14-19 LPA

Plsql Developer at EY

Pune, Chennai + 1

3-6 Yrs

₹ 5-13 LPA

Plsql Developer at BONbLOC Technologies Private Limited

Hyderabad / Secunderabad, Chennai

15-18 Yrs

₹ 17-20 LPA

Ernst & Young Mumbai Office Locations

View all
Mumbai Office
Ernst & Young, 14th Floor, The Ruby, 29, Senapati Bapat Marg, Dadar West Mumbai
Maharashtra 400028
Mumbai Office
6th Floor, Express Towers Nariman Point Mumbai Mumbai
400021

3-15 Yrs

Noida

5d ago·via naukri.com

3-8 Yrs

Navi Mumbai

12d ago·via naukri.com

7-11 Yrs

Bangalore / Bengaluru

1mon ago·via naukri.com

7-11 Yrs

Thiruvananthapuram

2mon ago·via naukri.com

7-11 Yrs

Mumbai

2mon ago·via naukri.com

7-11 Yrs

Noida

2mon ago·via naukri.com

7-11 Yrs

Hyderabad / Secunderabad

2mon ago·via naukri.com

7-11 Yrs

Pune

2mon ago·via naukri.com

7-11 Yrs

Kanayannur

2mon ago·via naukri.com

7-11 Yrs

Kolkata

2mon ago·via naukri.com
How was your last interview experience?

Recently Viewed

DESIGNATION

SALARIES

Jindal Industries Private Limited

No Salaries

COMPANY BENEFITS

Jindal Industries Private Limited

No Benefits

PHOTOS

Jindal Industries Private Limited

No Photos

LIST OF COMPANIES

Jindal Industries Private Limited

Overview

DESIGNATION

DESIGNATION

JOBS

Jindal Industries Private Limited

No Jobs

REVIEWS

Jindal Industries Private Limited

No Reviews

How was your last interview experience?
Rate your experience using AmbitionBox
Terrible
Terrible
Poor
Poor
Average
Average
Good
Good
Excellent
Excellent