Premkumar B Email & Phone Number

 Having 8+ years of IT experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence solutions using ETL Informatica Power Center tool. Extensively worked on Data Analysis, Design, Development, Implementation and Testing of ETL mappings, workflow and session. Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Oracle, Sql Server and flat files. Expertise in implementing complex Business rules by creating complex mappings/mapplets, shortcuts, reusable transformations. Strong Experience on Workflow Manager Tools - Task Developer, Workflow & Worklet Designer. Used actively Mapping Parameters, Mapping Variables and Workflow variable wherever it is applicable. Design and developed the incremental load strategy, Error handling strategy and Surrogate key generation strategy. Implemented the slowly changing dimensions as pre requirement. Good experience in designing and implementing Star Schema and Snow Flake Schemas.  Expertise in Control-M Scheduler Tool for Job Scheduling in Informatica Workflows using Control-M workload automation. Well versed exposure on RDBMS like Oracle, SQL Server and as well as External Sources. Good working knowledge windows batch files and unix shell scripts. Proven track record on successfully completion of Long Term and Short term projects within deadline while adapting to rapidly changing environments and priorities.