Informatica IICS (Walking Drive) 18 April Bangaluru

Informatica IICS (Walking Drive) 18 April\nBangaluru\nTata Consultancy Services Think Campus Plot No. 42(P) & 45(P), Hosur Road, Shanthi Pura, Electronic City, Bengaluru, Karnataka 560100\nJD:\n\n• Design, develop, test, and deploy complex data integration mapping tasks, task flows, and synchronization tasks using IICS/IDMC and Informatica PowerCenter.\n• Utilize advanced transformations within IICS to extract, transform, and load data from diverse sources (Oracle, SQL Server, Snowflake, REST APIs).\n• Develop and maintain API-based integrations using IICS Cloud Application Integration (CAI).\n• Create technical design documents, source-to-target mapping documents, and unit test cases.\n• Provide production support for IICS processes, troubleshooting job failures, and performing root cause analysis.\n• Optimize and tune Informatica IICS mappings and SQL queries for better performance and efficiency.\n• Monitor daily production loads, maintain data quality, and handle on-call support as needed.\n• Manage code migrations between environments (Dev, QA, Prod) using IICS deployment tools.\n\nMandatory skill sets:\nTechnical Expertise: Strong proficiency in IICS Cloud Data Integration (CDI) and Informatica PowerCenter.\nSQL Expertise: Advanced knowledge of SQL for querying and managing databases.\nDatabase Knowledge: Extensive knowledge of SQL, PL/SQL, and performance tuning within RDBMS (Oracle, Snowflake).\nData Modelling: Good understanding of data warehousing concepts (Data Modeling, SCD Type II, Facts & Dimensions).\nScripting: Experience in UNIX shell scripting for automation.