shalina shaik

• 1+ years of experience in Data Warehousing in analysis, design, development of software applications. • Expertise in Data warehousing solutions using Informatica Power Centre • Possess complete domain and development Life Cycle knowledge of Data Warehousing. • Currently Working on ETL tool Informatica 10.2.0 • Solid experience in Informatica Power Centre 10.x/9.x including Designer, Workflow Manager,Workflow Monitor, Repository Manager. • Analyzed different data sources using Source Analyzer in Informatica. • According to transformation logic, we used various transformations like Filter, Sorter, Aggregator,Lookup, Expression, Router, Update strategy, Joiner, Sequence generator etc. in the Mappings. • Experience in creating, executing and monitoring Workflows Manager and Workflow Monitor. • Expertise in handling slowly changing dimensions by using Type I and Type II and strategies. • Worked on Informatica Reusable objects like Reusable transformations and Mapplets. • Worked on Connected and Un-connected, dynamic lookups as part of mapping logic. • Hands on experience in tuning mappings, identifying and resolving performance bottlenecks invarious levels like sources, targets, mappings and sessions. • Experienced at Creating effective Test data and development through Unit test cases to ensuresuccessful execution of the data. • Worked on different source databases Oracle and Flat files. • Optimizing Informatica Mappings and Sessions to improve the performance. • Experience in performance tuning of sources, transformations, targets, mappings, worklets,workflows, and sessions. • Proven Experience in Complete life cycle of Design, Development, Documentation and Maintenance of the DataMarts and Data warehouse. • Knowledge with UNIX Shell Commands. • Proficient in using Informatica workflow manager, workflow monitor, server manager, PMCMD(Informatica command line utility) to create, schedule and control workflows, tasks, and sessions.