ODI Architect / PLSQL - Senior
EY
Gurgaon, Haryana, India
5d ago

EA-ODI / PLSQL Senior Consultant

The opportunity

We’re looking for Senior Consultant with expertise in ODI and PLSQL to join the leadership group of our GDS consulting 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 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.
  • Skills and attributes for success

  • Deliver large / medium DWH programmes, demonstrate expert core consulting skills and advanced level of ODI, SQL, PL / SQL knowledge and industry expertise to support delivery to clients
  • Perform an appropriate role in business development in terms of pre sales and practice development. for example, presales, internal engagement and / or knowledge management
  • Demonstrate management and an ability to conduct and lead consultancy assignments
  • To qualify for the role, you must have

  • 12+ years ETL Lead / developer experience and a minimum of 8-10 Years’ experience in Oracle Data Integrator (ODI) development modules and administration
  • Expertise in the Oracle ODI toolset and Oracle PL / SQL, ODI Architecture
  • Minimum 2-3 end to end DWH Implementation experience as an Architect
  • 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.
  • knowledge of ODI Master and work repository
  • Knowledge of data modelling and ETL design
  • Design and develop complex mappings, Process Flows and ETL scripts
  • Must be well versed and hands-on in using and customizing Knowledge Modules (KM)
  • 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 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
  • Integrate ODI with multiple Source / Target
  • Experience in Data Migration using SQL loader, import / export
  • Ideally, you’ll also have

  • Strong knowledge of ELT / ETL concepts, design and coding
  • Expertise in database development (SQL / PLSQL) for PL / SQL based applications.
  • 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, 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 and Indexing strategy for optimal performance
  • 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 ETL specifications and High- and Low-level design documents.
  • What we look for

  • The incumbent should be able to drive ODI Infrastructure related developments. Additional knowledge of complex source system data structures preferably in Financial services (preferred) Industry and reporting related developments will be an advantage.
  • An opportunity to be a part of market-leading, multi-disciplinary team of 10000 + professionals, in the only integrated global transaction business worldwide.
  • Opportunities to work with EY GDS consulting practices globally with leading businesses across a range of industries
  • What working at EY offers

    At EY, we’re dedicated to helping our clients, from start ups 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 that’s right for you
  • Report this job
    checkmark

    Thank you for reporting this job!

    Your feedback will help us improve the quality of our services.

    Apply
    My Email
    By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
    Continue
    Application form