Etl Informatica Developer

20 hours 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 Developer

    3 days ago

    Mumbai, Maharashtra, India Nelito System Full time ₹ 2,00,000 - ₹ 6,00,000 per year

    ETL Hi,GreetingsWe have an urgent opening for ETL Informatica for Mumbai Location with one of our client in Nelito System Pvt Ltd.About Nelito Systems Ltd:Nelito Systems Ltd. a group company of DTS Corporation Japan, is India's prominent financial technology company. The company is engaged in the business of providing software solutions and services for...

  • Etl Developer

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

  • Informatica Lead

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

  • Informatica Lead

    4 weeks 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

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

  • PLSQL & ETL developer with Banking Domain

    1 week ago

    Mumbai, Maharashtra, India Bahwan Cybertek Group Full time ₹ 9,00,000 - ₹ 12,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...

  • Informatica CDQ Lead

    4 days ago

    Mumbai, Maharashtra, India Suzva Software Technologies Full time ₹ 15,00,000 - ₹ 20,00,000 per year

    Job Title: Informatica CDQ Lead (Contract - Work From Office, Mumbai) We have an immediate requirement for an experienced Informatica CDQ Lead for a contract position in Mumbai. The ideal candidate should have expertise in Informatica Cloud Data Quality (CDQ) and strong data management skills. Key Responsibilities:Lead Informatica CDQ implementations for...

  • Informatica CDQ Lead

    3 days ago

    Mumbai, Maharashtra, India Suzva Software Technologies Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Job Title: Informatica CDQ Lead (Contract - Work From Office, Mumbai) We have an immediate requirement for an experienced Informatica CDQ Lead for a contract position in Mumbai. The ideal candidate should have expertise in Informatica Cloud Data Quality (CDQ) and strong data management skills. Key Responsibilities:Lead Informatica CDQ implementations for...

  • ETL Developer

    3 weeks ago

    Navi Mumbai, Maharashtra, India CSN Global IT Solutions Full time

    Job Description :Role : Amazon ETL Developer / AWS Cloud ETL developer L5Location : PAN IndiaJob Summary :We are looking for 5+ experience Amazon ETL Developer responsible for designing, developing, and maintaining ETL (Extract, Transform, Load) processes to manage data pipelines in Amazon Web Services (AWS) .Key Responsibilities and Technical Skills...

  • Informatica CDQ Developer

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