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