Roles & 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.
Skills Required
Sql Queries, Soap, Triggers, Informatica, Stored Procedures, Odbc, IICS, Rest, Rdbms, Sftp, Etl