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 scheduling tools

- Banking, Financial Services, Insurance, or Retail domain experience

📌 Informatica Developer (Mumbai)
🏢 Crisil
📍 Mumbai