Informatica Powercenter Solutions Specialist

12 hours ago

Mumbai, Maharashtra, India beBeeDataIntegration Full time ₹ 15,00,000 - ₹ 20,00,000

We are seeking a skilled ETL Developer/Administrator to design, develop, and manage robust data integration solutions using Informatica PowerCenter. This role is ideal for a professional with hands-on experience in the full lifecycle of Informatica PowerCenter implementations.

Key Responsibilities
  • ETL Development & Design:
  • Design, develop, and implement complex ETL mappings, transformations, and sessions using Informatica PowerCenter.
  • Create and manage workflows, worklets, and tasks within Informatica Workflow Manager.
  • Develop and optimize SQL queries for source/target systems and transformation logic.
  • Ensure data quality, consistency, and integrity throughout the ETL process.
  • Administration & Support:
  • Install, configure, and maintain Informatica PowerCenter environments (Repository Service, Integration Service, Web Services Hub, Node).
  • Perform user and group management, folder permissions, and security configurations.
  • Monitor ETL job executions, troubleshoot failures, and ensure timely data loads.
  • Manage code deployments across development, QA, and production environments.
  • Performance Tuning & Optimization:
  • Identify and resolve performance bottlenecks in ETL mappings and workflows.
  • Implement performance tuning techniques at the source, target, and transformation levels to optimize data load times.
  • Conduct capacity planning and ensure the scalability of the Informatica environment.
  • Troubleshooting & Debugging:
  • Provide expert-level support for Informatica PowerCenter-related issues, including debugging complex mappings and workflows.
  • Analyze session logs and workflow logs to diagnose and resolve data integration problems.
  • Collaboration & Documentation:
  • Work closely with data architects, business analysts, and report developers to understand data requirements and deliver effective solutions.
  • Create and maintain comprehensive technical documentation for ETL processes, data lineage, and system configurations.
Qualifications
  • A bachelor's degree in Computer Science, Information Technology, or a related field.
  • Proven experience as an Informatica PowerCenter Developer and/or Administrator.
  • Strong proficiency in designing, developing, and optimizing Informatica ETL mappings, transformations, and workflows.
  • Solid understanding of data warehousing concepts, including star schema, snowflake schema, and slowly changing dimensions (SCDs).
  • Expertise in SQL and relational databases (e.g., Oracle, SQL Server, Teradata).
  • Familiarity with Linux/Unix scripting for automation of ETL processes.
  • Excellent analytical, problem-solving, and debugging skills.
  • Strong communication and collaboration skills to work effectively in a team environment.
Preferred Skills
  • Informatica PowerCenter Developer/Administrator certification.
  • Experience with other Informatica products (e.g., Data Quality, Data Governance).
  • Knowledge of cloud data warehousing solutions (e.g., Snowflake, AWS Redshift, Azure Synapse).
  • Familiarity with version control systems (e.g., Git, SVN).

  • Informatica PowerCenter Developer Role

    7 days ago

    Mumbai, Maharashtra, India beBeeDataIntegration Full time ₹ 9,00,000 - ₹ 12,00,000

    Job Description:As a Data Integration Specialist, you will play a crucial role in designing, developing, and implementing ETL mappings, workflows, and sessions using Informatica PowerCenter. Your primary objective will be to extract data from various sources, transform it to meet business requirements, and load processed data into target data warehouses or...

  • Experienced Informatica Developer

    4 days ago

    Mumbai, Maharashtra, India beBeeInformatician Full time ₹ 20,00,000 - ₹ 25,00,000

    Job Title: Experienced Informatica DeveloperJob DescriptionAre you a skilled Informatica developer seeking a challenging opportunity? We are currently looking for professionals with experience in Informatica Powercenter and related technologies.This role is ideal for individuals who can analyze complex business problems and develop creative solutions using...

  • Informatica Solutions Engineer

    7 days ago

    Mumbai, Maharashtra, India beBeeinformatics Full time ₹ 15,00,000 - ₹ 18,00,000

    Job OverviewWe are seeking an experienced Informatica solutions engineer to help our organization improve its data management and integration capabilities.Key Responsibilities:Design and implement efficient ETL processes using Informatica PowerCenter and IDMC (IICS)Develop API-based integration and cloud data pipelinesMaintain and enhance existing workflows...

  • Informatica Lead

    3 weeks ago

    Mumbai, Maharashtra, India Smart Analytica Full time

    Role : Informatica Lead Mode : Onsite 5 days(Rotational Shift 24*7) Location : Mumbai (Kurla) About the Company: Smartavya Analytica Private limited is niche Data and AI company. Based in Pune, we are pioneers in data-driven innovation, transforming enterprise data into strategic insights. Established in 2017, our team has experience in handling large...

  • Informatica Lead

    4 days ago

    Mumbai, Maharashtra, India Smart Analytica Full time

    Role : Informatica Lead Mode: Onsite 5 days(Rotational Shift 24*7) Location: Mumbai (Kurla) About the Company: Smartavya Analytica Private limited is niche Data and AI company. Based in Pune, we are pioneers in data-driven innovation, transforming enterprise data into strategic insights. Established in 2017, our team has experience in handling large datasets...

  • Informatica Lead

    2 days ago

    Mumbai, Maharashtra, India Smart Analytica Full time

    Role : Informatica Lead.Mode : Onsite 5 days(Rotational Shift 24-7).Location : Mumbai (Kurla).Required Skills : - 6-10 years of experience in ETL development and data integration, with at least 3 years in a lead role.- Proven experience with Informatica PowerCenter, Informatica Cloud Data Integration, and large-scale ETL implementations.- Experience in...

  • 15h Left: Informatica Lead

    5 days ago

    Mumbai, Maharashtra, India Smart Analytica Full time

    Role : Informatica LeadMode: Onsite 5 days(Rotational Shift 24*7)Location: Mumbai (Kurla)About the Company:Smartavya Analytica Private limited is niche Data and AI company. Based in Pune, we are pioneers in data-driven innovation, transforming enterprise data into strategic insights. Established in 2017, our team has experience in handling large datasets up...

  • Unlock Your Potential as a Senior Data Integration Specialist

    5 days ago

    Mumbai, Maharashtra, India beBeeData Full time ₹ 1,80,00,000 - ₹ 2,25,00,000

    Job Title: Data Integration LeadAbout the Role:A highly skilled professional with expertise in designing and implementing data integration solutions using Informatica PowerCenter and Cloud Data Integration is required. The ideal candidate will lead a team of ETL developers, collaborate with architects and business stakeholders, and ensure seamless...

  • Developer with Informatica

    2 weeks ago

    Mumbai, Maharashtra, India Argyll Scott Full time

    We are looking for a skilled .NET Developer with strong experience in C# and Informatica Data Integration Platform. This is a 12 months contract position to start with to support long term client projects. The ideal candidate will be responsible for designing, developing, and maintaining robust, scalable applications and data pipelines that support critical...

  • Lead Informatica Intelligent Cloud Services Developer

    15 hours ago

    Mumbai, Maharashtra, India beBeeInformatica Full time ₹ 18,00,000 - ₹ 24,00,000

    Job OverviewWe are seeking a highly skilled Informatica Developer to join our team.This is an exceptional opportunity for a talented professional to take their career to the next level by working with a leading organization in the industry.The successful candidate will have a proven track record of delivering end-to-end projects and possess excellent...