Informatica Developer with Databricks

3 weeks ago

Navi Mumbai Maharashtra India, Maharashtra Celebal Technologies Full time

Job Description – 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:

o Mappings, Mapplets, Workflows, Worklets, Sessions

• Hands-on experience with Informatica transformations:

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

• Proficiency in handling Informatica parameters and variables:

o Mapping variables and parameters

o Workflow variables

o Session parameters

o 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.

  • 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 MumbaiExperience: 5-7+ YearsDuration: FulltimePosition 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...

  • Etl Informatica Developer

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

  • Data Engineer

    3 weeks ago

    Navi Mumbai, Maharashtra, India, Maharashtra Celebal Technologies Full time

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

  • Senior Azure Databricks Engineer

    3 weeks ago

    Mumbai, Maharashtra, India, Maharashtra MLAI Digital Private Ltd. Full time

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

  • Databricks Developer

    2 weeks ago

    Pune, Maharashtra, India, Maharashtra Vista Applied Solutions Group Inc Full time

    Job Summary:Client is looking for Databricks Developer and this is hybrid position from Pune.Responsibilities:Maintain comprehensive knowledge of industry standards, methodologies, processes, and best practices.Promptly report any known or suspected loss, theft or unauthorized disclosure or use of PI to the General Counsel/Chief Compliance Officer or Chief...

  • Informatica CDQ Developer

    1 week ago

    Mumbai, Maharashtra, India Suzva Software Technologies Full time ₹ 9,00,000 - ₹ 12,00,000 per year

    Immediate Job Opening Informatica CDQ Developer (Contract Position) We are hiring Informatica CDQ Professionals with 4 to 8 years of experience for a contract position (6 months to 1 year). This is a Work from Office opportunity based in Mumbai. Job Details:Role: Informatica CDQ DeveloperType: Contract (6 months to 1 year)Start Date: Immediate joiners...

  • Informatica SQL Developer

    9 hours ago

    Mumbai, Maharashtra, India Infocus Technologies Full time ₹ 15,00,000 - ₹ 28,00,000 per year

    Job Description: Informatica Developer with SQLLocation: MumbaiKey Responsibilities:Design analytical SQL (Window Functions)Design and construct databases in both Netezza SQL ServerDeploying code from one environment to anotherDesigning & Develop Informatica MDM User Exits, Match rulesShare knowledge and expertise with teamConsulting &...

  • Field Engineering Manager

    6 hours ago

    Mumbai, Maharashtra, India Databricks Full time ₹ 20,00,000 - ₹ 60,00,000 per year

    Manager, Field Engineering FEQ326R99 As 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...

  • Delivery Solutions Architect

    15 hours ago

    Mumbai, Maharashtra, India Databricks Full time ₹ 10,00,000 - ₹ 25,00,000 per year

    Delivery Solutions Architect CSQ426R270 At Databricks, we are on a mission to empower our customers to solve the world's toughest data problems by utilizing the Databricks Data Intelligence Platform. As a Delivery Solutions Architect (DSA), you will play an important role during this journey. You will collaborate with our sales and field engineering...

  • Databricks Developer

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