Informatica Developer

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 optimisation
• 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)