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 endtoend integrations including mappings, tasks, processes, error handling, and performance optimisation
Perform ETL and integration migrations, including PowerCenter to IICS and onpremise to cloud transitions
Support migration activities including redesign, data validation, reconciliation, and postmigration optimization
Develop and tune SQL Server / TSQL (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, rolebased 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 handson experience with Informatica PowerCenter Development
Strong handson experience with IICS Data Integration
Strong handson experience with IICS Application Integration
Experience with ETL and integration migrations
Advanced SQL Server / TSQL skills
Strong understanding of data warehousing and ETL concepts
Experience in production support
Strong analytical and communication skills

Good to Have:

Informatica Developer