Informatica Powercenter Developer

1 week 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).

  • Informatica PowerCenter ETL professional

    2 weeks ago

    Bengaluru, Karnataka, India IDESLABS PRIVATE LIMITED Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Looking for associate with 5+ years of hands on experience in Informatica Power Center/ETL Experience in batch monitoring and trouble shooting, impact analysis and batch recovery Good hands on experience in SQL and RDBMS/teradata Proficient in working on scheduler Autosys/TWS/Control-M Basic knowledge of Unix Strong analytical skills, triaging engaging...

  • Informatica Developer

    7 days 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

    1 week ago

    Bengaluru, Karnataka, India TechWise Digital Full time ₹ 15,00,000 - ₹ 25,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...

  • Hiring for Informatica Powercenter Administrator with IICS/IDMC

    2 weeks ago

    Bengaluru, Karnataka, India, Karnataka Atos Full time

    Notice Period: Immediate to 30 DaysExperience: 8+ yearsMax CTC: 28 LPAPrimary Skills: Informatica Powercenter Admin, IICS Admin/IDMCJob Location: Pune, Mumbai, Bangalore & ChennaiJob Description:This is a strong technology and support service delivery operations to Process definition, setup, configuration, support for Informatica Power Centre and IDMC...

  • Informatica Developer

    2 weeks ago

    Bengaluru, Karnataka, India, Karnataka Insight Global Full time

    Insight Global is seeking a seasoned Senior Level Informatica Developer to help re-design the ETL workflows for a new Ratings Platform for a financial services firm focused on ratings. Key Responsibilities:Re-Design, develop ETL workflows using Informatica PowerCenterWrite and optimize complex SQL queries for data extraction, transformation, and...

  • ETL Informatica Developer

    1 week ago

    Bengaluru, Karnataka, India ApplogiQ Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Job Description :Design, develop, and optimize ETL workflows using Informatica PowerCenter or IICS for critical banking data systems.Build and maintain data virtualization layers in Denodo to integrate structured and unstructured data from core banking, payments, risk, and regulatory platforms.Collaborate with data architects, business analysts, and...

  • Informatica Administrator

    5 days ago

    Bengaluru, Karnataka, India HireAlpha Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    Job Description : Key Responsibilities : - Install, configure, and administer complex Informatica platform environments, specifically covering Informatica PowerCenter, Data Engineering Integration (DEI), and Big Data Management (BDM) components across development, testing, and production landscapes. - Take full ownership of managing platform...

  • Informatica Power Center

    2 weeks ago

    Bengaluru, Karnataka, India Talent Worx Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Technical Skill Set:Hands-on experience with Informatica PowerCenter as an ETL tool. Proficiency in AWS cloud services: RDS, Redshift, S3. Strong knowledge of Database Concepts – Indexing, Partitioning. Understanding of Data Warehousing concepts – Normalization, Denormalization, Star/Snow-flake schemas. Proficient in creating tables, DDL, DML, and...

  • Informatica ETL Developer

    1 week ago

    Bengaluru, Karnataka, India Infonex Technologies Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Experience implementing large-scale ETL processes using Informatica PowerCenter.Design high-level ETL process and data flow from the source system to target databases.Strong experience with Oracle databases and strong SQL.Develop & unit test Informatica ETL processes for optimal performance utilizing best practices.Performance tune Informatica ETL mappings...

  • Informatica Developer

    7 days ago

    Bengaluru, Karnataka, India Wissen Infotech Full time ₹ 8,00,000 - ₹ 12,00,000 per year

    Role & responsibilitiesPreferred candidate profileRole Summary:seeking an Informatica developer who will be an excellent addition to the forBusiness Intelligence team.Responsibilities:This role is for BI KPI portal operations and Development.Domains including: Data Integration, Data Extraction from Legacy systems, Data Warehousing,efficient in...