Etl Informatica Developer

Advance Career Solutions; Bengaluru, Mumbai; Hybrid; INR 1,500,000 - 2,100,000; Full time

Job summary

Advance Career Solutions in Bengaluru is seeking an experienced ETL Informatica & Databricks Developer to design, develop, and support scalable data pipelines using Informatica and Databricks.

The ideal candidate has 8–12 years of ETL/Data Engineering experience with hands-on Informatica PowerCenter, Databricks, PySpark, SQL, and cloud data platforms such as Azure. You will collaborate with data engineers and architects to ensure data quality and performance.

Qualifications

• 8–12 years of experience in ETL/Data Engineering.
• Strong hands-on experience with Informatica PowerCenter / Informatica ETL.
• Strong experience with Databricks and PySpark.
• Good expertise in SQL and relational databases.
• Experience with ETL/ELT development, data warehousing, and data integration.
• Understanding of data lake/lakehouse architectures and cloud data platforms.
• Experience in debugging, performance tuning, and production support.
• Good communication and problem-solving skills.

Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines using Informatica.
• Develop and optimize data processing solutions using Databricks, PySpark, and SQL.
• Perform data extraction, transformation, cleansing, validation, and loading across multiple data sources.
• Work with Azure/cloud data platforms, data lakes, and data warehouses.
• Develop and optimize complex SQL queries and data transformation logic.
• Monitor ETL jobs and troubleshoot performance, data quality, and production issues.
• Implement data integration workflows and ensure data accuracy and consistency.
• Collaborate with Data Engineers, Architects, Business Analysts, and other stakeholders.
• Participate in code reviews, testing, deployment, and production support.
• Follow best practices for performance optimization, security, and scalable data processing.

Skills

ETL/Data Engineering

Informatica PowerCenter / Informatica

Databricks

PySpark

SQL

Data warehousing

Data integration

Communication skills

Problem-solving skills

Tools

Git

CI/CD

Job description

ETL Informatica & Databricks Developer

Experience: 812 Years
Location: Mumbai / Bengaluru
Shift Timing: 2:30 PM – 11:00 PM

Job Summary

We are looking for an experienced ETL Informatica & Databricks Developer with strong expertise in data integration, ETL development, and cloud-based data engineering. The candidate will be responsible for designing, developing, and supporting scalable data pipelines using Informatica and Databricks.

Key Responsibilities

• Design, develop, and maintain robust ETL/ELT pipelines using Informatica.
• Develop and optimize data processing solutions using Databricks, PySpark, and SQL.
• Perform data extraction, transformation, cleansing, validation, and loading across multiple data sources.
• Work with Azure/cloud data platforms, data lakes, and data warehouses.
• Develop and optimize complex SQL queries and data transformation logic.
• Monitor ETL jobs and troubleshoot performance, data quality, and production issues.
• Implement data integration workflows and ensure data accuracy and consistency.
• Collaborate with Data Engineers, Architects, Business Analysts, and other stakeholders.
• Participate in code reviews, testing, deployment, and production support.
• Follow best practices for performance optimization, security, and scalable data processing.

Required Skills

• 8–12 years of experience in ETL/Data Engineering.
• Strong hands‑on experience with Informatica PowerCenter / Informatica ETL.
• Strong experience with Databricks and PySpark.
• Good expertise in SQL and relational databases.
• Experience with ETL/ELT development, data warehousing, and data integration.
• Understanding of data lake/lakehouse architectures and cloud data platforms.
• Experience in debugging, performance tuning, and production support.
• Good communication and problem-solving skills.

Preferred Skills

• Experience with Azure Data Lake, Azure Data Factory, or Azure Synapse.
• Knowledge of Delta Lake and Databricks workflows.
• Experience with Git and CI/CD practices.
• Exposure to cloud migration or modernization projects.
• Knowledge of Agile development methodologies.