Informatica PowerCenter Developer
First seen by Alion on Oct 12, 2026.
Role Overview :
We are looking for an experienced Informatica PowerCenter Developer with strong hands-on expertise in ETL development, data integration, and data warehousing.
The candidate will be responsible for designing, developing, maintaining, and supporting enterprise-scale ETL workflows using Informatica PowerCenter, while working closely with business and technical teams to deliver reliable data solutions.
Key Responsibilities :
- Design, develop, and maintain Informatica PowerCenter mappings, mapplets, workflows, and sessions.
- Develop robust and scalable ETL solutions based on business and technical requirements.
- Work with multiple source systems and target databases for data extraction, transformation, and loading.
- Write and optimize SQL queries for data validation, transformation, and troubleshooting.
- Monitor and troubleshoot Informatica workflows and resolve production issues.
- Perform performance tuning of Informatica mappings, workflows, and SQL queries.
- Conduct data validation and ensure data quality across ETL processes.
- Support deployment and migration of Informatica workflows across development, testing, and production environments.
- Analyze and resolve data-related incidents within defined SLAs.
- Work closely with business analysts, data architects, database teams, and other technical stakeholders.
- Prepare and maintain technical documentation for ETL processes and solutions.
- Participate in code reviews and follow development and data engineering best practices.
- Support enhancements, maintenance, and production support activities for existing data platforms.
Required Skills & Experience:
- 3 - 7 years of hands-on experience with Informatica PowerCenter.
- Strong understanding of ETL and data integration concepts.
- Strong experience with Informatica mappings, workflows, sessions, transformations, and scheduling.
- Good knowledge of SQL and relational databases.
- Experience with data warehousing concepts and dimensional modelling.
- Strong troubleshooting and debugging skills.
- Experience in performance tuning of Informatica workflows and SQL queries.
- Experience working in enterprise production environments.
- Good communication and stakeholder management skills.
Good to Have:
- Experience with Oracle databases.
- Exposure to Informatica BDM / IICS.
- Familiarity with Hadoop / Cloudera ecosystem.
- Exposure to Spark / PySpark.
- Experience working in Banking / Financial Services or other large enterprise environments.
- Knowledge of Unix / Linux scripting.
- Exposure to scheduling tools and version control systems.
Key Skills :
Informatica PowerCenter | ETL | SQL | Oracle | Data Warehousing | Data Integration | Performance Tuning | Production Support
Ideal Candidate :
A strong hands-on Informatica PowerCenter Developer with 3 - 7 years of experience who can independently develop and support complex ETL solutions, troubleshoot production issues, optimize workflows, and work effectively with enterprise data teams.
Skills
Data Engineering, ETL, SQL, Data Warehousing, Data Integration, Power Center, Informatica, IICS