IICS Support Eng (BLR/HYD) 5+years

Job description

IICS Support Eng IICS Support Eng (BLR/HYD) 5+yearsJob Description & Summary: • Design, develop, test, and deploy complex data integration mapping tasks, task flows, and synchronization tasks using IICS/IDMC and Informatica PowerCenter.• Utilize advanced transformations within IICS to extract, transform, and load data from diverse sources (Oracle, SQL Server, Snowflake, REST APIs).• Develop and maintain API-based integrations using IICS Cloud Application Integration (CAI).• Create technical design documents, source-to-target mapping documents, and unit test cases.• Provide production support for IICS processes, troubleshooting job failures, and performing root cause analysis.• Optimize and tune Informatica IICS mappings and SQL queries for better performance and efficiency.• Monitor daily production loads, maintain data quality, and handle on-call support as needed.• Manage code migrations between environments (Dev, QA, Prod) using IICS deployment tools. Mandatory skill sets:Technical Expertise: Strong proficiency in IICS Cloud Data Integration (CDI) and Informatica PowerCenter.SQL Expertise: Advanced knowledge of SQL for querying and managing databases.Database Knowledge: Extensive knowledge of SQL, PL/SQL, and performance tuning within RDBMS (Oracle, Snowflake).Data Modelling: Good understanding of data warehousing concepts (Data Modeling, SCD Type II, Facts & Dimensions).Scripting: Experience in UNIX shell scripting for automation.