Careers at Genpact


  • Facebook
  • Twitter
  • Linkedin
  • Email

Lead Consultant - ODI

With a startup spirit and 80,000+ curious and courageous minds, we have the expertise to go deep with the world’s biggest brands—and we have fun doing it. Now, we’re calling all you rule-breakers and risk-takers who see the world differently, and are bold enough to reinvent it. Come, transform with us.


Inviting applications for the role of ODI Consultant, BIDS
In this role, you will be responsible for ODI implementation for one of GENPACT customer.

Be part of a dynamic team working on various ODI projects under Corp Technologies.

Role and responsibilities include and are not limited to:

  • Responsible for development of ETL using Oracle Data Integrator (ODI) and setup of processing structures in order to facilitate periodic data loads or creation of batches for transmission to other applications. Responsible for supporting the ODI processes that continuously collect data from multiple upstream applications, and subsequent integration of data into Corp Tech repositories.
  • Responsible for optimizing, tuning, performance improvement to support near real time data processing.
  • Responsible for implementing data validation based on business requirements. Work collaboratively as part of the team responsible for the data collection applications to design develop, and support the end-to-end processes, taking the lead on strategy and design of all ETL processes. Provide highly responsive analysis of issues to diagnose and resolve with sense of urgency.
  • Works closely with various Corp Tech application teams and upstream applications to ensure that requirements for data collections and processing are met by the execution of ETL and scheduling solutions.


Required qualifications to be successful in this role:

  • Oracle Data Integrator experience a must. ODI expertise in Topology, Knowledge Modules, Change data capture, Interface, Package, Scenario, Model, Data Store, Master Repositories, Work Repositories, Agents, ODI Architecture..
  • Expertise on understanding, Tuning, Simplifying complex Oracle SQL queries/ views, Indexes.
  • Proficiency in PL/SQL stored Procedures, Functions, Exception Handling, Packages, Triggers, Table functions, Collections (Type Objects).
  • Proficiency in Unix commands, Shell Scripts – String manipulation, File Handling, IF THEN ELSE, LOOP, invoking WS or API calls/jar command etc.
  • Experience on Automic(UC4J) is an added advantage.
  • Experience setting up proper data integration processes, ability to influence the team to follow new processes, execute the project to completion Experience in resolving complex data related issues
  • Good communication skills with the ability to communicate effectively with senior management in non-technical way.
  • Organizational and problem solving skills.
  • Self-starter and self-motivator with proven sense of urgency
  • Required Skills: Oracle ODI (Data Integration) 11G, SQL/PL-SQL tuning and performance improvement, UNIX scripting, Automic/any scheduling software.


Genpact is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. Genpact is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation. For more information, visit www.genpact.comFollow us on Twitter, Facebook, LinkedIn, and YouTube.



Job: Lead Consultant

Job ID: ITO047812

Primary Location: India - Bangalore

Education Level: Bachelor's / Graduation / Equivalent

Job Posting: Feb 14, 2022

Master Skills List: Corporate

Job Category: Full Time