Candidate should have 5 to 8 years of experience on Informatica PowerCenter tool .
Should have L2/L3 level enhancement and support experience on Informatica PowerCenter 10.0
Should know how to design & develop ETL processing framework to automate error handling, restart-ability and file processing
Should be proficient in the Integration of various data sources like Salesforce, Flat Files, Oracle, Microsoft SQL Server and Web services with multiple relational databases like Oracle, Microsoft SQL server and IBM DB2 as staging area
Good understanding of ETL Packages Optimization, and Query Optimization
Strong knowledge of DB, ETL and DW concepts
Should have good knowledge of writing SQL commands, queries and stored procedure
Resolve critical and high priority issues as per the client requirement.
Should be able to perform analysis of defects/issues and fixing of the same in Production
Coordinating with onshore and offshore team to keep them aligned, and ensure that there are no delays in project.
Good communication skills are required.
Capability to work in a distributed team environment with minimal supervision