TechOps-DE-CloudOps-AMS-ODI-Staff

At EY, you’ll 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 we’re 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.

EY-Consulting – ODI Staff, Senior
The opportunity
We are looking for Staff 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 client’s unique needs, one should be able to see the gap between where clients currently are and where they need to be. The candidate should have excellent problem solving and debugging skills.

Your key responsibilities:

• Overall having 2-5 years of ODI experience and a minimum of 2-3 Years’ experience in Oracle Data Integrator (ODI).
• Minimum 2-3 hands-on experience on DWH projects
• 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.
• Excellent debugging, problem-solving skills, monitoring jobs
• Knowledge on Scheduling tools like BMC Control-M is good to have
• Expertise in the Oracle ODI toolset and Oracle SQL, 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 ODI mappings, packages, procedures.
• 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 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.
• Willing to work in night shifts.

Education:

• BTech / MTech / MCA / MBA

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.