Careers at Genpact


  • Facebook
  • Twitter
  • Linkedin
  • Email

Principal Consultant -Pentaho Sr ETL Developer / SME


With a startup spirit and 90,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  Pentaho PDI + BI Principal Consultant


  • ETL using Pentaho Data Integration (Kettle and Spoon)
  • Having good BI Implementation experience by design
  • Expertise in designing and troubleshooting Pentaho data integration (kettle) jobs, transformations, steps
  • Strong expertise in writing SQL, PL/SQL queries.
  • Big Data + Pentaho Integration and Architecting is a great Plus
  • Expert in design and development of jobs to capture CDC (Change Data Capture) from source systems.
  • ETL Best practices and proper design patterns
  • Experience with ETL loads for Facts and Dimension tables.
  • Expert in designing and setting up exception handling and performance tuning of jobs.
  • Analyzing, designing, testing and coding of BI front end applications and backend engines

according to business requirements.

  • Good DW Concepts and designing
  • Other BI ETL related tools is a plus
  • Exposure to BI Reporting is a plus


Responsible for developing transformations to ingest and manipulate data from various sources. Responsibilities also include defining user needs, providing input to functional design, testing and troubleshooting.

Minimum Experience / Relevance

Experience in implementing large scale Enterprise Data Warehouse Projects. Should have worked in DW space in terms of Delivery, Solutioning, Architecture etc.

Preferred Skills

  • Defining and Driving Over all BI and ETL Solutioning / Architecture Standards
  • Architecture Solutioning in Pentaho PDI landscape
  • Driving BI and ETL Development by adhering the Customer specific standards
  • Analytical, problem-solving, and conceptual skills and ability to work with a technical team

Comprised of internal and external resources

  • Performing Code Review with industry known best practices
  • Performance Tuning
  • Designing or Defining BI and ETL strategy
  • Gathering requirements from Business Users
  • Conversion of business requirements to Pentaho PDI designs
  • Managing End to End BI and ETL activities (analyze, build, test and deploy)
  • Developing re-usable framework / methodology / components for ETL environment
  • Pentaho PDI Job governance – Consolidation / Recommendations
  • Good Knowledge on Data warehousing Design approach
  • Excellent Knowledge in ETL Testing Methodologies
  • Performance Improvements for Pentaho PDI Jobs
  • Understand Change control Management and drive changes by performing Impact Analysis
  • Ownership of all the deliverables such as Pentaho PDI Job designs, process improvements  and consolidation exercises
  • Controlling Configuration Management to take care of multiple Pentaho PDI code versions  and their management
  • Monitoring History data, Initial Loadings  and data reconciliation by working closely with Business users/stakeholders for validations
  • Strong Customer Mgt/Documentation/time/team management and organizational skills
  • Strong communication skills
  • Strong leadership skills

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 Follow us on Twitter, Facebook, LinkedIn, and YouTube.


Job: Principal Consultant

Job ID: ITO049017

Primary Location: India - Hyderabad

Education Level: Bachelor's / Graduation / Equivalent

Job Posting: Feb 16, 2022

Master Skills List: Corporate

Job Category: Full Time