Payal Bhandari Email & Phone Number

1.8 years of experience in using Informatica Power Center (9.6.1 ,10.1 & 10.2) 2.Proficiency in developing SQL with various relational databases like Oracle, Teradata, Netezza.3.Knowledge in Full Life Cycle development of Data Warehousing.4.Have extensively worked in developing ETL program for supporting Data Extraction,transformations and loading using Informatica Power Center.5.Understand the business rules completely based on High Level document specifications andimplements the data transformation methodologies.6.Strong with relational database design concepts.7. Developed various mappings using Informatica Designer and worked with Aggregator, Lookup,Filter, Router, Joiner, Source Qualifier, Expression, Sorter and Sequence Generatortransformations.8.Created complex mappings which involved Slowly Changing Dimensions (SCD1 and SCD 2),implementation of Business Logic9.Have worked on Teradata BTEQ scripts, have worked on Unix shell scripting have goodknowledge of Unix commands10.Ability to troubleshoot the Errors related to Hyperion Interactive Reporting Client.11. Optimizing the Long Running SQL's using best practices.12.Performed deployments using the Version Control Tool Bitbucket.13.Worked on JIRA & PDSM tickets (Creating/Assigning/Done) along with the requiredattachments.14.Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities,flexible in work schedules and possess good communication skills.15.Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.