Divakar Sangala

Over all 5+years of experience in Data warehousing by using Informatica with strong background.  Worked on both Agile and Development projects in client location, SWEDEN and Saudi Arabia.  Excellent Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica Power Center.  Expertise in Data Warehousing Concepts such as Star Schema, Snow Flake Schema, Fact and Dimension Table  Strong Data warehousing experience specializing in ETL Concepts to load data from different sources into Data warehouse using Informatica Power Center.  Extensively worked on Informatica Power Center and DataStage Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Rank, Aggregator, Sorter, stored procedure and Sequence Generator.  Good knowledge in SQL,PL/SQL and UNIX Shell Scripting.  Expert in designing and developing Workflows, Sessions and other tasks using Work flow manager tools Task Developer, Workflow & Work let Designer to handle different load scenarios.  Extensively worked with Slowly Changing Dimensions (Type I and Type II).  Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, work lets and workflows in  Windows environments.  Knowledge in Performance tuning.  Expertise in configuring Error Handling and Auto restart solutions in Informatica for all application workflows or sessions.  Experience in configuring different adapters/connections like PowerExchange , External Loader and Relational  Efficient on relational database systems like SQL Server, Oracle, DB2 and Sybase.  Extensive experience in loading High volume of data, requirement gathering, analysis, design, development and implementation.  Excellent Team member with good Communication, analytical, interpersonal skills and ability to learn new concepts.  Expertize in Manufacturing and Banking domain.  Working Experience on Agile methodology.