Etl Informatica Developer

3 days ago

Navi Mumbai, Maharashtra, India Celebal Technologies Full time ₹ 6,00,000 - ₹ 18,00,000 per year

Job Description ETL Migration Specialist (Informatica to Databricks)

Position Overview

We are looking for an experienced ETL Migration Specialist with strong expertise in Informatica PowerCenter and Databricks (PySpark). The ideal candidate will be responsible for analysing and reverse engineering existing Informatica mappings/workflows, understanding the business logic implemented, and refactoring these pipelines into scalable, efficient data processing workflows on Databricks.

This role requires strong analytical skills, hands-on experience in ETL development, and the ability to collaborate with both business and technical teams to ensure seamless migration.

Key Responsibilities

  • Reverse Engineering: Analyze existing Informatica mappings, workflows, sessions, and variables to understand data flow, transformations, joins, filters, lookups, and aggregations.
  • ETL Refactoring: Translate Informatica logic into PySpark/Databricks workflows, ensuring accuracy and performance.
  • Data Modeling & Transformation: Design and implement transformation logic in Databricks aligned with business rules.
  • Performance Optimization: Refactor ETL logic for scalability and performance tuning in Databricks.
  • Documentation: Create detailed documentation for the converted pipelines, capturing both technical logic and business rules.
  • Testing & Validation: Collaborate with QA/Business teams to validate data correctness between Informatica outputs and Databricks outputs.
  • Best Practices: Ensure adherence to Databricks and cloud data engineering best practices, including modular coding, error handling, and reusability.
  • Collaboration: Work with stakeholders, data architects, and business SMEs to clarify requirements and resolve discrepancies.

Must Have Informatica Expertise

  • Strong knowledge of Informatica objects:

  • Mappings, Mapplets, Workflows, Worklets, Sessions

  • Hands-on experience with Informatica transformations:

  • Lookup, Joiner, Router, Aggregator, Expression, Sequence Generator, Filter, Stored Procedure, Update Strategy, etc.

  • Proficiency in handling Informatica parameters and variables:

  • Mapping variables and parameters

  • Workflow variables
  • Session parameters

  • Parameter files and variable scoping

  • Ability to debug and trace variable values across sessions and workflows.

  • Experience in designing reusable transformations and optimization techniques in Informatica.

Required Skills & Experience

  • 5+ years of hands-on experience in ETL development with Informatica PowerCenter (or IICS).
  • 2+ years of experience in Databricks (PySpark, SQL, Delta Lake) for ETL/ELT implementation.
  • Strong understanding of data warehousing concepts (SCDs, fact/dimension modeling, partitioning, indexing).
  • Hands-on experience with cloud platforms (Azure / AWS / GCP) and Databricks workspace setup.
  • Proficiency in SQL and performance tuning of large datasets.
  • Experience in reverse engineering ETL logic and re-implementing in modern platforms.
  • Excellent problem-solving, debugging, and communication skills.

Good to Have

  • Experience with DevOps/CI-CD pipelines for Databricks (e.g., GitHub Actions, Azure DevOps, Jenkins).
  • Exposure to Informatica to Spark migration tools or accelerators.
  • Knowledge of Medallion architecture or modern data lakehouse patterns.
  • Experience in Agile/Scrum delivery.

  • ETL Informatica + SQL

    2 weeks ago

    Mumbai, Maharashtra, India Synechron Full time ₹ 6,00,000 - ₹ 12,00,000 per year

    ETL Informatica + SQLKey ResponsibilitiesETL Development: Design, develop, and implement ETL workflows using Informatica PowerCenter to extract, transform, and load data from multiple sources into data warehousing solutions.Database Management: Utilize SQL for data manipulation, querying, and optimization in relational database systems (e.g., Oracle, SQL...

  • Etl Developer

    2 weeks ago

    Navi Mumbai, Maharashtra, India Xoriant Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    About the RoleWe are looking for a skilled ETL / Reconciliation Specialist to join our global Operations team. The role involves working on reconciliation solutions using Intellimatch, Informatica, and strong SQL expertise to ensure the accuracy of the Firms Books and Records while mitigating operational and systemic risks.This role requires proactive...

  • PLSQL & ETL developer with Banking Domain

    1 week ago

    Mumbai, Maharashtra, India Bahwan Cybertek Group Full time ₹ 6,00,000 - ₹ 18,00,000 per year

    Bahwan CyberTek Group is looking for a talented PLSQL & ETL Developer with experience in the Banking domain to join our innovative team. You will leverage your expertise in PLSQL and ETL processes to design, develop, and implement high-quality solutions that meet the evolving needs of our banking and financial services clients. Your role will be critical in...

  • ETL Developer

    5 days ago

    Mumbai, Maharashtra, India Zycus Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    About UsZycus, recognized by leading analyst firms in procurement technology, empowers teams to unlock deep value through its comprehensive Source-to-Pay (S2P) solutions. At the heart of our S2P solution is the Merlin Agentic Platform, which orchestrates intelligent AI agents to deliver simplified, efficient, and compliant processes.The Merlin Intake Agent...

  • Informatica Developer

    1 week ago

    Mumbai, Maharashtra, India Green clover Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    We are looking for Informatica Developer Responsibilities: · Develop new Standard Reports based on design specifications provided by the clients.  · Perform necessary Validation on developed reports. Perform peer review on developed reports on request. · Provide end user support in terms of report writing as requested by the clients. · Provide end...

  • ETL Developer

    3 days ago

    Mumbai, Maharashtra, India Zycus Infotech Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    About UsZycus, recognized by leading analyst firms in procurement technology, empowers teams to unlock deep value through its comprehensive Source-to-Pay (S2P) solutions. At the heart of our S2P solution is the Merlin Agentic Platform, which orchestrates intelligent AI agents to deliver simplified, efficient, and compliant processes.The Merlin Intake Agent...

  • ETL Consultant

    1 week ago

    Mumbai, Maharashtra, India Global Talent Track Private Limited (Global Talent Track)(231) Full time ₹ 5,00,000 - ₹ 12,00,000 per year

    About the Job : The ideal candidate will be responsible for designing, developing, and maintaining robust ETL processes. The role requires expertise in handling large-scale data integration, ensuring data accuracy, and delivering scalable solutions aligned with business requirements. Key Responsibilities : - Design, develop, and implement...

  • Informatica MDM Support Engineer

    1 week ago

    Mumbai, Maharashtra, India Persistent Full time ₹ 4,00,000 - ₹ 8,00,000 per year

    About Position:We are seeking for Informatica MDM support engineer with hands-on experience in SQL,ETL/Data Integration.Role: Informatica MDM Support EngineerLocation: Navi MumbaiExperience: 3yrs to 6yrsJob Type: Full Time EmploymentWhat You'll Do:Provide support for Informatica MDM applications and resolve production issues.Monitor jobs, troubleshoot data...

  • ETL Testing

    1 week ago

    Mumbai, Maharashtra, India Virtusa Full time ₹ 10,00,000 - ₹ 15,00,000 per year

    JOB Description:Strong Experience in ETL and BigData TestingSound knowledge in ETL DWH concepts Experience in any ETL tools like InformaticaGood knowledge in Building SQL Queries Expert in creation of test scenarios cases which meets the business requirements mapping documentsExperience in working with huge volumes of data analysing record sets for Data...

  • ETL Developer

    1 week ago

    Mumbai, Maharashtra, India Hatchtra Innotech Pvt. Ltd. Full time ₹ 1,32,000 - ₹ 1,50,000 per year

    Role -: ETL/SSIS DeveloperExp YearsBudget - 11 LPAShift Time: 1 pm to 10 pmLocation - Mumbai / Pune / ChandigarhNotice Period - Immediate Joiner - LWD Till 31 Oct ONLYJob Summary:We are seeking a skilled ETL/SSIS Developer to join our data engineering team. The ideal candidate will have hands-on experience in designing, developing, and maintaining ETL...