Informatica Lead

Job Description Roles and Responsibilities: - Lead project team members through all activities required to successfully deliver Informatica. - Define technical specifications for workflows and business rules. - Prepare detailed design documents for data migration. - Configure, build and unit test Informatica components, including data structures, roles, workflows, and portals. - Train and mentor colleagues in Informatica implementation activities and best practices. - Support integration, system, and user acceptance testing. - Accountable for the Master Data Management, Technical Architecture, providing data modeling solutions and recommendations. - Profile & Analyze Source Data usage using ETL tool. - Automation, job scheduling, dependencies, monitoring. - Configure/Script Business rules and transformation rules in ETL - Data pipeline using IICS - Hands on experience in Informatica MFT, Data Exchange (DX),and Data Transform (DT) modules - Integration experience using various adapters (MLLP, SOAP, REST, SFTP, ODBC) will be essential. - Strong knowledge and experience with developing complex SQL Queries, stored procedures, and triggers for RDBMS systems. - Experience in administering, supporting, and performance tuning using Informatica.