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
Solid 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