Informatica developer

Well versed with ETL fundamentals and good command working with various ETL tools such as Talend, Informatica components like Source Analyzer, Target Designer, Mapping and Mapplet Designer - Designed & developed mappings for SCD-1, SCD- 2 implmentations - Ability to work with complex mappings using Informatica Power Center Designer & associated job scheduling tools. - Vast hands-on experience in working with development to production code migration using XML models - Extensively worked with flat file mappings and handled scenario based challenges - Strong hold with respect to joins, aggregates, indexing, fine tuning, optimization - Worked in creation/maintenance of various stored procedures, triggers, views - Ability to work with complex logics and formulate optimized queries for generating database outputs - Worked on debugging and troubleshooting of various business/technical problems - Familiar with various database warehousing concepts and techniques like Star, Snowflake schema - Strong verbal & interactive skills - UNIX skills to support various technical implementations would be handy - Efficient team handling skills along with project end to end implementation lead experience would be ideal for candidates above 4 years of experience