| Skill | Years of Experience | Proficiency Level (1-5) |
| IICS | | |
| Experience in writing SQL Basic and Advanced SQL queries | | |
| ETL & DWH skills | | |
| Experience with Unix shell scripting | | |
| Experience in Databases | | |
Development: Design and develop ETL/ELT pipelines using Informatica IDMC/IICS
Build and maintain mappings, mapping tasks, and taskflows etc
Develop reusable, parameterized components and integration frameworks
Implement complex transformations, data validation, and cleansing logic
Experience working with Snowflake, SAP connectors and other relational databases
Enable CI/CD using Informatica REST APIs
Support deployment and release activities across environments (DEV/QA/PROD, Sub-Orgs)
Collaborate with architects, analysts, and business teams in Agile environments
Follow Agile/Scrum methodologies for development and delivery
Administration: Strong knowledge of Informatica IDMC architecture including Org/Sub-Org design
Configure and manage Secure Agents and Runtime environments
Manage user access, roles and governance within the IDMC platform
Configure and maintain connections (cloud, DB, API, file-based)
Ensure platform performance, scalability, and security compliance
Hands-on experience with the RunAJob CLI utility for job execution and automation