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 effective 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 sc
📌 Informatica Developer (Mumbai)
🏢 Crisil
📍 Mumbai