Job Title : Senior Consultant - Informatica

Exp : 6+ Years

Location : Hyderabad, Bangalore

Client : facing exp is Mandatory

Shift : Morning shift and 2-11 PM

Mode : Hybrid

Responsibilities :

- Design, develop, test, and deploy complex data integration mapping tasks, task flows, and synchronization tasks using IICS/IDMC and Informatica Power Center.

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