Description

You will design and develop ETL solutions using Informatica Intelligent Cloud Services (IICS) and PowerCenter to manage large data volumes.

Responsibilities

• Develop complex mappings and ETL solutions using IICS Data Integration and Application Integration.
• Design ETL frameworks and specifications, including unit test plans, to meet business requirements.
• Manage data ingestion from various sources including XML, flat files, and databases using Informatica MFT and IICS.
• Implement change data capture (CDC) and manage slowly changing dimensions and fact tables within data warehouses.
• Handle administration and support activities, including incident and ticket management.

Required Skills

• 5+ years of experience with Informatica Intelligent Cloud Services (IICS) and Informatica PowerCenter.
• Proficiency in Snowflake, Oracle, and MS SQL Server.
• Advanced SQL skills, including performance optimization, table indexing, stored procedures, functions, and data partitioning.
• Hands-on experience with data warehousing concepts and ETL design.
• Experience managing integration, quality controls, and governance of golden source data.
• Ability to develop complex queries and handle large-scale data integration.
• Any Graduate degree.

Key Skills

Education

Any Graduate