L B Email & Phone Number

 Having 3+ years of experience in all phases of Analysis, Design, Development ,Implementation and support of Data warehousing Applications using tools like Informatica, PDI (Spoon),oracle. Working experience in Production support projects to monitor the failing jobs and identify the issues to resolve. Main areas of expertise are analyzing, developing, and testing the data warehousing projects.  Experience in Development of mappings using needed Transformations using Informatica and pentagon Spoon tool.  Experience in Data Warehousing using Data Extraction, Data Transformation and Data Loading. Used ETL process to Extract, Transform and Load the data into stage area and data warehouse. Performing data validation and loads by writing the complex SQLs Preparing Documentation for the mappings according to the Business Requirements. Strong knowledge in Dimensional Data Modeling Technique, Multi Dimensional Database Schemas like Star schema and Snowflake schema (Fact Tables, Dimension Tables), and handling SCD’s. Optimizing Informatica Mappings and Sessions to improve the performance. Extensively worked on Session partitioning techniques using different Informatica Partitioning techniques to optimize the load times. Proven Experience in Complete life cycle of Design, Development, Documentation and Maintenance of the Data marts and Data warehouse.