GDS Consulting_ODI/PLSQL Senior Consultant
GDS Consulting_ODI/PLSQL Senior Consultant
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
At EY youll have the chance to build a career as unique as you are with the global scale support inclusive culture and technology to become the best version of you. And were counting on your unique voice and perspective to help EY become even better too. Join us and build an exceptional experience for yourself and a better working world for all.
**This hiring is for GDS Philippines location**
The opportunity
We are looking for 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 clients 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
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.
- Expertise in the Oracle ODI toolset and Oracle PL/SQL ODI (moderate knowledge)
- Setting up topology building objects in Designer Monitoring Operator different type of KMs 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
- Experience in SQL tuning and optimization using explain plan and Sql trace files.
- 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
What working at EY offers
At EY were dedicated to helping our clients from startups to Fortune 500 companies and the work we do with them is as varied as they are.
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 thats right for you
About EY
As a global leader in assurance tax transaction and consulting services were using the finance products expertise and systems weve 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 exceptional EY experience lasts a lifetime. And with a commitment to hiring and developing the most passionate people well make our ambition to be the best employer by 2020 a reality.
If you can confidently demonstrate that you meet the criteria above please contact us as soon as possible.
Join us as we shape the future with confidence.
!
EY Building a better working world
EY exists to build a better working world helping to create long-term value for clients people and society and build trust in the capital markets.
Enabled by data and technology diverse EY teams in over 150 countries provide trust through assurance and help clients grow transform and operate.
Working across assurance consulting law strategy tax and transactions EY teams ask better questions to find new answers for the complex issues facing our world today.
Required Experience:
Senior IC
Employment Type
Full Time
