EY GDS Consulting_ODI Senior Technical Consultant 

Philippines, Taguig 

962709139

Qualifications:

Overall having 3-6 years of ETL Lead/Developer experience and a minimum of 2-3 years experience in ODI

Minimum 2-3 end to end Data Warehousing Implementation experience.

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.

Knowledge of ODI Master and work repository

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

Strong knowledge of ELT/ETL concepts, design and coding

Must have a 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.

Good-to-haves:

• 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 data modelling and ETL design
• Partitioning and Indexing strategy for optimal performance

You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees and you will be able to control your own development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer:

• Support, coaching and feedback from some of the most engaging colleagues around
• Opportunities to develop new skills and progress your career
• The freedom and flexibility to handle your role in a way that’s right for you

As a global leader in assurance, tax, transaction and consulting services, we’re using the finance products, expertise and systems we’ve developed to build a better working world. That starts with a culture that believes in giving you the training, opportunities and creative freedom to make things better.Whenever you join, however long you stay, the