Careers at Genpact


  • Facebook
  • Twitter
  • Linkedin
  • Email

Consultant - Informatica & SQL developer

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.

Are you the one we are looking for?

Inviting applications for the role of Informatica and SQL Developer

In this role, you will be responsible for working as Informatica and responsible for running ETL projects. To support Engineer using Agile Methodology and should have an end to end understanding of business use cases, to transform them into an effective and strategic solution. Work with business people to have a real time understanding of business problem and, craft the solution which really fits into customer needs.


  • Engage with Client to participate in requirement gathering, Status update on work, UAT and be the key partner in the overall engagement.
  • Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.
  • Builds ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter
  • Write complex SQL queries with performance tuning and optimization.
  • Handle task independently and own the team
  • Installing, upgrading, configuring Informatica PowerCenter in Linux OS
  • Identifying in the eliminating spool spaces, skewness issues along with Understanding various indexes and using appropriately in the queries.
  • Develop, implement and optimize stored procedures and functions using SQL
  • Analyze existing SQL queries for performance improvements & suggest new queries

Minimum qualifications

  • BE/B Tech/MCA
  • Proficient with crafting Informatica mappings, sessions, workflows, mapplets
  • Worked with large data sets and proficient using of Analytical functions
  • Experienced in running an ETL project interacting with users globally
  • Should be able to understand requirements analysis then, build and deliver the solution
  • Experience in developing complex ETL solution

Preferred qualifications

  • Worked on Informatica, DB
  • Perform development role in Informatica, DB
  • DW/BI experience with implementation of ETL solutions using Informatica and Oracle
  • Must have experience in writing SQL in Oracle. Confident to write and understand queries

We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

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: Consultant

Job ID: ITO041813

Primary Location: India - Bangalore

Education Level: Bachelor's / Graduation / Equivalent

Job Posting: Aug 2, 2021

Master Skills List: Corporate

Job Category: Full Time