IICS Informatica-Bangalore

Job Title: IICS Informatica

Location: Bengaluru

Experience: 4 to 12 yrs

Job 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.