Informatica Powercenter Developer

3 days ago

Bengaluru, Karnataka, India Data Prowess Full time ₹ 9,00,000 - ₹ 12,00,000 per year

Job Description: Informatica PowerCenter Developer (with SQL Stored Procedure Expertise)

Position Overview

We are seeking an experienced Informatica PowerCenter Developer with strong expertise in SQL development and stored procedures. The candidate will be responsible for designing, developing, and maintaining ETL processes, ensuring data accuracy, performance, and scalability across complex data integration environments.

Key Responsibilities

  • Design, develop, and implement ETL workflows using Informatica PowerCenter.
  • Develop, optimize, and maintain SQL stored procedures, functions, and triggers to support business requirements.
  • Collaborate with business analysts, data architects, and stakeholders to understand requirements and translate them into technical solutions.
  • Perform data analysis, profiling, and validation to ensure data quality and integrity across multiple sources.
  • Troubleshoot, debug, and optimize Informatica mappings, sessions, and workflows for performance improvements.
  • Implement error handling, logging, and auditing within ETL processes.
  • Support data migrations, enhancements, and production deployments.
  • Provide BAU support and work on continuous enhancements of existing ETL solutions.
  • Document technical specifications, workflows, and support procedures.

Required Skills & Experience

  • 5+ years of hands-on experience with Informatica PowerCenter (mappings, workflows, transformations).
  • Strong proficiency in SQL (Oracle, SQL Server, or similar) with proven experience in writing and optimizing complex stored procedures.
  • Solid understanding of RDBMS concepts, data modeling, and performance tuning.
  • Experience with ETL performance optimization and debugging production issues.
  • Familiarity with data warehousing concepts, star/snowflake schema, and dimensional modeling.
  • Exposure to scheduling tools (Control-M, Autosys, or similar).
  • Strong problem-solving skills and ability to work in a fast-paced, team-oriented environment.
  • Excellent communication skills (verbal and written).

Nice-to-Have Skills

  • Experience with Informatica IICS / Cloud ETL.

  • Knowledge of Python, Shell scripting, or Unix commands for automation.

  • Experience with reporting/visualization tools (Tableau, Power BI).
  • Understanding of DevOps CI/CD pipelines for ETL deployment.

Education

Bachelors degree in Computer Science, Information Systems, or related field (or equivalent experience).

  • Consultant / Developer - Informatica Cloud (IDMC) & PowerCenter

    3 days ago

    Bengaluru, Karnataka, India Genxhire Services Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Role Consultant/Developer Informatica Cloud on the Data Integration and Application Integration modules of the IDMC platformExperience – 5-8 yearsLocation – BangaloreNotice Period – Immediate JoinersShift Timings - 6:30 AM IST to 3:30 PMKey ResponsibilitiesAs part of our project to migrate our Informatica PowerCenter platform to the Informatica Cloud...

  • Informatica Developer

    6 hours ago

    Bengaluru, Karnataka, India Datacore Technologies Full time ₹ 15,00,000 - ₹ 28,00,000 per year

    We are looking for a skilled and detail-orientedInformatica PowerCenter Developerto join our data engineering team. The ideal candidate will have experience in designing, developing, and implementing ETL solutions usingInformatica PowerCenterto support enterprise data warehouse and data integration initiatives.

  • Informatica Cloud developer

    3 days ago

    Bengaluru, Karnataka, India TechWise Digital Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Greetings from Techwise Digital Private LtdHiring for an Top Investment banking firmRole : INFORMATICA Consultant/developerLocation : Brookfield, BangaloreShift : 6.30 am to 3.30pm (both way cab will be provided)Years of experience : 5 to 7 YearsNotice period : Immediate to 15 days maxContact duration: 1 YearsRoles and ResponsibilitiesAs part of our project...

  • Lead Informatica Developer

    5 days ago

    Bengaluru, Karnataka, India beBeeInformatica Full time ₹ 1,80,00,000 - ₹ 2,50,00,000

    Lead Informatica DeveloperWe are seeking a skilled Lead Informatica Developer to spearhead the development of our ETL workflows and sessions using Informatica data cloud (IICS/IDMC) and PowerCenter.Responsibilities:Design, develop, and implement ETL workflows and sessions utilizing Informatica IDMC and PowerCenterCollaborate with cross-functional teams to...

  • Informatica Developer

    5 days ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Greetings from LTIMindtree We are currently hiring for a Informatica Leads. The position is ideal for professionals with 6–13 years of experience in Informatica Powercenter and related technologies. Note: We are looking for candidates who can join us in September month. Key Skills We're Looking For: Informatica Developer RDBMS/SQL PostgreSql database...

  • Informatica Developer

    2 days ago

    Bengaluru, Karnataka, India Diverse Lynx Full time

    Informatica Developer Must-Have Ideally should not be more than 3-5 IT experience in Analysis Design Development Implementation Testing of Data Warehousing and Data Integration Solutions using Informatica Powercenter and oracle pl sql Writing SAS SQL codes to create tables functionalities and reports according to client s requirement...

  • Informatica Developer

    2 weeks ago

    Bengaluru, Karnataka, India ITC Infotech Full time

    JD: Informatica Developer : "Develop and implement ETL processes using Informatica PowerCenter for data warehousing projects". "Design and develop ETL mappings to extract data from various sources and load it into a datalakehouse". "Troubleshoot and optimize existing ETL workflows for performance and reliability". "Collaborate with data architects, business...

  • Informatica Developer

    12 hours ago

    Bengaluru, Karnataka, India ITC Infotech Full time

    JD: Informatica Developer :"Develop and implement ETL processes using Informatica PowerCenter for data warehousing projects"."Design and develop ETL mappings to extract data from various sources and load it into a datalakehouse"."Troubleshoot and optimize existing ETL workflows for performance and reliability"."Collaborate with data architects, business...

  • Informatica Developer

    4 weeks ago

    Bengaluru, Karnataka, India LTIMindtree Full time

    Informatica IICS DeveloperWe are looking for a highly experienced Senior Informatica IICS Developer to lead the design development and optimization of cloudbased ETL solutions This role demands deep expertise in Informatica Intelligent Cloud Services IICS strong data integration skills and the ability to collaborate across business and technical teams to...

  • Informatica Admin

    50 minutes ago

    Bengaluru, Karnataka, India People Prime Worldwide Full time

    About Company Our client is a global technology consulting and digital solutions company that enables enterprises to reimagine business models and accelerate innovation through digital technologies Powered by more than 84 000 entrepreneurial professionals across more than 30 countries it caters to over 700 clients with its extensive domain and technology...