Sonveer Singh

• 3.5 Years of experience in Migration (PowerCenter to IDMC AND DataStage to IDMC), Data Warehousing in analysis, design. • Convert PowerCenter Assets to Intelligent Data Management Cloud (IDMC) manually sing our automated tools & utilities. • Hands-on experience on ETL Tools like Intelligent Data Management Cloud (IDMC) & Informatica Power Center and has good experience in Migration and Implementation and Development. • Expertise in Data warehousing solutions using IDMC and Informatica Power Centre. • Currently Working on ETL tool like Intelligent Data Management Cloud (IDMC) and Informatica PowerCenter, IBM Tool DataStage. • Solid experience in Intelligent Data Management Cloud (IDMC) (Rx) Data Integration, Monitor and Administrator AND Informatica Power Centre 10.x/9.x including Designer, Workflow Manager, Workflow Monitor, Repository Manager. • Analysed different data sources using Source Analyzer in Informatica PC. • 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 and executing and monitoring the Task flow. • 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 in various levels like sources, targets, mappings and sessions. • Experienced at Creating effective Test data and development through Unit test cases to ensure successful execution of the data. • Worked on different source databases Oracle, Amazon Redshift, SQL Server and Flat files. • Optimizing Informatica Mappings and Sessions to improve the performance. • Experience in performance tuning of sources, transformations, targets, mappings, worklets, workflows, task flow, MCT and sessions. • Proficient in using Informatica workflow manager, workflow monitor, PMCMD (Informatica command line utility) to create, schedule and control workflows, tasks, and sessions. •I have been an integral part of our team, contributing significantly to six major projects four of which I managed from Start to End.