Data & Analytics – Consulting Job in Bangalore at EY

As part of our EY-DnA team, you will help clients in developing and implementing data analyses, data collection systems and other strategies that optimize statistical efficiency and quality. Working with latest tools available in the market you will help clients by acquiring data from primary or secondary data sources and maintain databases/data systems and help to identify, analyse, and interpret trends or patterns in complex data sets.

Using your expertise in data analytics you will help our clients to view data in context and make smarter business decisions to achieve improved products and services.

The opportunity

We’re looking for Senior Consultant with expertise in Oracle PLSQL and ODI to join our dynamic Consulting DnA 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 in Oracle application development/support

  • 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.

  • Interact with senior leaders, understand their business goals, contribute to the delivery of the workstreams

Skills and attributes for success

Oracle PL/SQL:

  • Deliver large/medium DWH programmes, demonstrate expert core consulting skills and advanced level of SQL, PL/SQL, ODI knowledge and industry expertise to support delivery to clients

  • Expertise in database development (SQL/ PLSQL) for PL/SQL based applications.

  • 5+ years’ experience in designing and developing Oracle object such as Tables, Views, Indexes, Partitions, Stored Procedures & Functions in PL/SQL, Packages, Materialized Views and Analytical functions

  • Working knowledge of GIT or similar source code control system

  • Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views, Collections 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, Hints and Indexing strategy for optimal performance

  • Experience in Direct Load & Conventional Load using SQL Loader

  • Should have good understanding Oracle Database Architecture

ODI 12C:

  • Strong knowledge of ELT/ETL concepts, design and coding

  • ETL developer with minimum of 2+ Years’ experience in Oracle Data Integrator (ODI 12C)

  • 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.

  • Design and develop complex mappings, Process Flows and ETL scripts

  • Packaging components, database operations like Aggregate pivot, union etc.

  • Using ODI mappings, error handling, automation using ODI, Load plans, Migration of Objects

  • Experience of performance tuning of mappings

  • Expertise in developing Load Plans, Scheduling Jobs

  • Experience in Data Migration using SQL loader, import/export

To qualify for the role, you must have :

  • Be a computer science graduate or equivalent with 6-8 years of industry experience

  • Flexible and proactive/self-motivated working style with strong personal ownership of problem resolution.

  • Excellent communicator (written and verbal formal and informal).

Ideally, you’ll also have :

  • Client management skills

  • 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 technical specifications and High- and Low-level design documents.

What we look for :

  • A Team of people with commercial acumen, technical experience and enthusiasm to learn new things in this fast-moving environment

  • An opportunity to be a part of market-leading, multi-disciplinary team of 550 + professionals, in the only integrated global Consulting business worldwide.

  • Opportunities to work with EY Consulting practices globally with leading businesses across a range of industries

Click Here : Apply

Contact Us at:
  • Instagram
  • telegram logo
  • LinkedIn

© 2020 The Referral Room