Informatica Developer with Databricks

4 days ago

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

Job Title: ETL Migration Specialist (Informatica to Databricks)

Location: Navi Mumbai

Experience: 5-7+ Years

Duration: Fulltime

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 Developer

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

  • Informatica Developer

    2 weeks 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...

  • Account Executive

    2 weeks ago

    Mumbai, Maharashtra, India Databricks Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    As an Account Executive your mission will be to help further build our India business, which is one of our fastest growing markets in APJ. The Databricks Sales Team is driving growth through strategic and innovative partnership with our customers, helping businesses thrive by solving the world's toughest problems with our solutions. You will be inspiring and...

  • Databricks Developer

    1 week ago

    Mumbai, Maharashtra, India Seaspan Corporation Full time ₹ 12,00,000 - ₹ 24,00,000 per year

    Seaspan teams are goal-driven and share a high-performance culture, focusing on building services offerings to become a leading asset manager. Seaspan provides many of the world's major shipping lines with alternatives to vessel ownership by offering long-term leases on large, modern containerships and pure car, truck carriers (PCTCs) combined with industry...

  • Manager, Field Engineering

    2 weeks ago

    Mumbai, Maharashtra, India Databricks Full time ₹ 12,00,000 - ₹ 36,00,000 per year

    FEQ326R99As a Manager, Field Engineering (Data & AI)  (Strategic Accounts, Data & AI) will lead a team of Solutions Architects (Data & AI) focusing on large enterprise & strategic customers in India. You will help lead our Global Accounts team in India expansion, you will build and lead a technical pre-sales team. You will guide and get involved to enhance...

  • Senior Azure Databricks Engineer

    1 week ago

    Mumbai, Maharashtra, India MLAI Digital Private Ltd. Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Company DescriptionMLAI_Digital is a GenAI_Agentic Specialised Organisation(8 Years old) providing Various Cognitive Products well suited for major BFSI Institutions.Offices in US(ohio) ,Singapore (PTE), Malaysia , India and Australia(MEL) Domain expertise:- FINANCIAL INSTITUTIONS(Banks & Insurance) and Fraud Analytics for Financial TransactionsRole...

  • Informatica/L2 Support

    2 weeks ago

    Mumbai, Maharashtra, India Talent21 Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Informatica /L2 L3 SupportExperience: 8+ yrsJob Location: Pan India(Hybrid)Notice Period: Only Immediate JoinersShift Timings: 6 AM to 3.30 PM & 12.30 PM to 9.30 PMMandatory Skills: L2 L3 Support Informatica, Tableau UNIX , SQLMust have 5 or more years of hands-on development experience and can deep dive into issues in the technologies related to:...

  • Data Engineer(Azure Databricks)

    2 weeks ago

    Navi Mumbai, Maharashtra, India Persistent Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    About Position:As a Data Engineer, you will design and manage robust data pipelines using Azure Databricks, Spark, and Kafka. You'll process large-scale datasets and implement CDC pipelines to power analytics platforms. Your role includes modeling data using the Medallion Architecture and ensuring data quality and governance. Collaboration with analytics...

  • Informatica MDM Support Engineer

    2 weeks 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...

  • Pyspark & Databricks certified Developer

    2 weeks ago

    Mumbai, Maharashtra, India PradeepIT Consulting Services Full time ₹ 5,00,000 - ₹ 15,00,000 per year

    About the jobAccelerate your career with PradeepITPradeepIT is one of the largest, globally recognized IT Consulting firm to connect India's deeply vetted talent team to global customer.Were headquartered in Bengaluru, Silicon Valley of India. PradeepITs customers include SAP Lab, Bosch, Rolls-Royce, Daikin, Daimler and J&J and hundreds of other Fortune 500...