CRISIL
Website:
crisil.com
Job details:
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
Click on Apply to know more.
