Roles & Responsibilities

• Design, develop, and maintain data integration solutions using Informatica PowerCenter, PowerExchange, and CDC tools.
• Lead the design and development of data integration solutions, ensuring data quality and consistency across systems.
• Troubleshoot and resolve technical challenges, debugging, tuning, and optimizing code for performance improvements.
• Manage new requirements and enhancements, conduct gap analysis, and optimize existing jobs for better performance.
• Document ETL mappings, sessions, and workflows for future reference and compliance.
• Handle ticketing and problem resolution using an Agile/POD approach, ensuring timely resolution of technical issues.

Required Qualifications

• 7+ years of hands-on experience with Informatica tools (PowerCenter, PowerExchange, IICS), focusing on data pipeline implementation and data processing.
• Over 10 years of total experience, with a solid understanding of Data Warehouse (DW) concepts, Data Marts, Enterprise Data Warehouses (EDW), and Operational Data Stores (ODS).
• Extensive experience designing and implementing ETL pipelines, data marts, and real-time integration using open integration patterns.
• Proficiency in working with databases like Snowflake, DB2, PostgreSQL, and other related technologies.
• Strong background in resolving performance issues and optimizing code, with experience in parallelism and data modeling.
• Knowledge in Identity Management, Snowflake data sharing, and Client/Prospect Data Management.
• Experience working within Agile methodologies, collaborating with diverse business and technology teams.
• Proven experience in supporting production environments, troubleshooting, and resolving client-related issues associated with Informatica workflows.
• Familiarity with job scheduling, hosting, monitoring, and analyzing job failures to identify and resolve issues.

Posted By