Consultant- Production Support with Informatica
Genpact
Bangalore, India
4d ago

Responsibilities

  • 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
  • Crafts ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter
  • Write complex SQL queries with performance tuning and optimization
  • Should be able to handle task independently and lead the team
  • Responsible for unit testing, integration testing and UAT as and when required
  • Good communication Skills
  • Qualifications we seek in you Minimum qualifications

  • BE / B Tech / M Tech / MCA / BCA
  • Excellent written and verbal communication skills
  • Preferred qualifications

  • Worked on Informatica, Oracle and Unix Senior Developer
  • Perform development role in Informatica, Oracle and Unix
  • DW / BI experience with implementation of ETL solutions using Informatica and Oracle
  • Proficient with crafting Informatica mappings, sessions, workflows, mapplets and hands on Experience on crafting CDC, SCD2 implementation
  • Should have good knowledge on performance tuning in Informatica and Oracle
  • Worked with large data sets and proficient using of Analytical functions
  • Experienced in running an end to end 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
  • Experience in shall scripting
  • Must have experience in writing SQL in Oracle. Should be able to write and understand queries
  • Experience in Autosys is preferable but not a must
  • Basic Knowledge in Hadoop and DataLake
  • 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