Key Responsibilities :

- Design, develop, and support ETL solutions using Informatica PowerCenter

- Design and develop cloud and hybrid data integration solutions using IICS Data Integration

- Design and develop application integrations using IICS Application Integration, including Salesforce and other SaaS applications

- Build and manage end- to-end integrations including mappings, tasks, processes, error handling, and performance optimization

- Perform ETL and integration migrations, including PowerCenter to IICS and on- premise to cloud transitions

- Support migration activities including redesign, data validation, reconciliation, and post- migration optimization

- Develop and tune SQL Server / T- SQL (stored procedures, functions, views, complex queries)

- Perform ETL and database performance tuning and resolve production issues

- Gather business requirements and translate them into technical integration solutions

- Provide production support, root cause analysis, and system enhancements

- Ensure data security, role- based access, and compliance standards

Required Skills:

- 8-10 years of overall experience in data integration related technologies, 5+ years of relevant experience on Informatica PowerCenter and IICS

- Strong hands- on experience with Informatica PowerCenter Development

- Strong hands- on experience with IICS Data Integration

- Strong hands- on experience with IICS Application Integration

- Experience with ETL and integration migrations

- Advanced SQL Server / T- SQL skills

- Strong understanding of data warehousing and ETL concepts

- Experience in production support

- Strong analytical and communication skills

Good to Have :

- SSAS (Multidimensional) model design and maintenance

- SSRS report development and support

- Informatica PowerCenter Administration experience

- IICS Administration (connections, security, scheduling)