We are looking for an experienced Informatica Developer with 7+ years of hands-on experience in designing, developing, and supporting enterprise data integration and ETL solutions. The candidate should have strong expertise in Informatica, SQL, data warehousing, and performance optimization.

Key Responsibilities

- Design, develop, and maintain ETL/ELT workflows using Informatica.
- Develop mappings, mapplets, workflows, sessions, and reusable transformations.
- Work with Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC/IICS).
- Gather technical requirements and translate business requirements into scalable data integration solutions.
- Develop complex SQL queries, stored procedures, and database objects.
- Integrate data from multiple sources including relational databases, flat files, APIs, and cloud platforms.
- Perform data cleansing, transformation, validation, and reconciliation.
- Troubleshoot ETL failures and production issues and provide root-cause analysis.
- Optimize mappings and workflows for improved performance and scalability.
- Implement error handling, logging, restartability, and data quality checks.
- Participate in deployment activities across development, testing, and production environments.
- Work closely with data architects, business analysts, QA teams, and other technical teams.




- Prepare technical documentation and support knowledge-transfer activities.

Mandatory Skills

- 7+ years of experience in Informatica Development.
- Solid hands-on experience with Informatica PowerCenter.
- Experience with Informatica IICS/IDMC is highly preferred.
- Strong knowledge of ETL concepts and Data Warehousing.
- Strong SQL skills with experience in Oracle, SQL Server, PostgreSQL, or similar databases.
- Good understanding of Dimensional Modeling, Star/Snowflake Schema, Facts and Dimensions.
- Experience in performance tuning of Informatica mappings and workflows.
- Strong troubleshooting and production support experience.
- Good understanding of SDLC and deployment processes.

Good to Have

- Experience with AWS/Azure/GCP data platforms.
- Exposure to Snowflake, Databricks, or Azure Data Lake.
- Experience with Unix/Linux shell scripting.
- Knowledge of REST APIs and web-service integrations.
- Experience with scheduling tools such as Control-M, Autosys, or similar.
- Exposure to CI/CD and DevOps practices.
- Experience in Agile/Scrum environments.

Soft Skills

- Strong analytical and problem-solving skills.
- Good communication and stakeholder-management skills.
- Ability to work independently as well as collaboratively.
- Strong ownership of deliverables and production issues.

📌 Informatica Developer (Bengaluru)
🏢 Elfonze Technologies
📍 Bengaluru