Informatica Developer

Key Responsibilities

• Design, develop, test, and deploy ETL workflows using Informatica PowerCenter and/or Informatica Intelligent Cloud Services (IICS).
• Analyze source systems and translate business requirements into technical ETL specifications.
• Build and maintain complex mappings, workflows, sessions, reusable transformations, and parameterized jobs.
• Develop data movement and transformation solutions for enterprise data warehouse initiatives.
• Implement data quality, validation, reconciliation, and auditing frameworks.
• Optimize ETL performance through workflow tuning, partitioning, pushdown optimization, and SQL tuning.
• Work with large-scale data volumes and ensure efficient data processing.
• Collaborate with database administrators, architects, business analysts, and reporting teams.
• Perform impact analysis and support production deployments.
• Investigate and resolve ETL failures, performance bottlenecks, and data integrity issues.
• Create and maintain technical design documents, deployment guides, and operational runbooks.
• Mentor junior developers and conduct code reviews to ensure adherence to best practices.
• Participate in estimation, planning, and release activities.

Mandatory Skills Informatica

• Informatica PowerCenter (9.x/10.x)
• Informatica IICS (preferred)
• ETL Design & Development
• Workflow & Mapping Development
• Performance Tuning
• Debugging & Production Support

Database & SQL

• Strong SQL and PL/SQL skills
• Oracle, SQL Server, PostgreSQL, or Teradata
• Query optimization and performance tuning
• Stored procedures, functions, and packages

Data Warehouse

• Data Warehousing Concepts
• Dimensional Modeling (Star/Snowflake)
• Fact and Dimension Design
• SCD (Slowly Changing Dimensions)
• Data Migration and Data Integration

Version Control & Deployment

• Git / SVN
• CI/CD concepts
• Deployment and release management

Preferred Skills

• Informatica Data Quality (IDQ)
• Informatica MDM
• Informatica Cloud Data Integration
• Azure/AWS data services
• Unix Shell Scripting
• Python
• Control-M or enterprise scheduling tools
• Banking, Financial Services, Insurance, or Retail domain experience