Job Seekers, Please send resumes to resumes@hireitpeople.com

Must Have Skills:

• Informatica Intelligent Cloud Services
• Informatica Power Center
• Data Quality, ETL
• 3 years of hands on experience with Informatica IICS
• 5 years of hands on experience with Informatica PowerCenter
• Extensive experience working with various data sources (SQL and Oracle database, flat files (csv, delimited), Web API, XML,
• Advanced SQL skills required. Solid understanding of relational databases and business data; ability to write complex SQL queries against variety of data sources (OLTP, Data Warehouse) .
• Knowledge of Informatica Architecture
• User interface design skills working knowledge of data modeling (conceptual, logical and physical) as well as database design
• Solid experience with Business Intelligence/Analysis and Data Warehousing
• Solid understanding of relational and dimensional data models

Detailed Job Description:

Qualified candidates should have over 5 years of experience with Informatica PowerCenter and 3 years of experience with Informatica IICS. We are looking for a resource that is a self - starter and committed to customer satisfaction.

Job Responsibilities:

• Ability to define and design the best architecture to install Informatica Intelligent Cloud Services (IICS) Secure Agent components and subsystems for a multi-server platform capable of scaling with growing number of components and applications
• Proven ability to architect and build high volume, mission critical cloud native applications.
• Demonstrated success in building RESTful API Integration using IICS.
• Strong understanding across Cloud and infrastructure components (server, storage, network, data, and applications) to deliver end to end Cloud Infrastructure architectures and designs.
• Experience in IICS Application Integration components like Processes, Service Connectors and process object.
• Build Service connectors for Real Time integration with Third party applications.
• Build Business Services using JSON file to call web services.
• Experience in Integrating Informatica cloud with other applications like Salesforce, Workday, ServiceNow
• Experience in installing Add-on connectors and drivers for IICS
• Expertise in using methodologies for data extraction, transformation and loading data using various transformations like Expression, Router, Filter, Lookup, Update Strategy, Union, and Aggregator.
• Strong technical experience building data integration processes by constructing mappings, tasks, taskflows, schedules, and parameter files.
• Ability to write scripts for File watching and File transfer protocols.
• Experience leveraging and writing architectural patterns, best practices and guidelines for enterprise applications.
• History of working on multiple concurrent projects and performing in a variety of different roles in the software development life cycle
• Experience in RDMBS (SQL Server), including complex SQL constructs and DDL generation.
• Strong knowledge on either DOS scripting or Shell scripting.
• Communicate project status with management
• Ability to learn new technology and quickly adapt to technology changes
• The qualified candidate will display excellent problem solving, analytical, communication, coordination and task management skills

Minimum years of experience required: 10+