Exp – 5 to 10 years

Key Responsibilities

- Design, develop, test, and deploy ETL workflows using Informatica PowerCenter and/or equivalent ETL tool.
- 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 productive 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 or any equivalent ETL tool.

- Informatica PowerCenter (9.x/10.x) or equivalent ETL tool.
- 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

📌 Senior Software Engineer (Mumbai)
🏢 Crisil
📍 Mumbai