Around 4.6 years of extensive experience in Data Integration and Data Warehousing using Informatica and Qlikview technologies.
Excellent Knowledge of Data Warehousing.
Expertise and experience in the following areas – ETL design, ETL Performance tuning.
Extensive experience in developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica Power Center 9.X in Windows and UNIX environment.
Good Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence (BI), Decision Support Systems (DSS) and OLAP, ETL tools, product development and Reports Generation.
ETL Data warehousing using Informatica Power Center 9.X Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
Worked with multiple transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedure transformations.
Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions. Hands on experience in optimizing SQL scripts and improving performance loading warehouse.
Familiar with writing SQL joins, unions, and multi-table joins.
Scheduling the batch jobs using Workflow Monitor.
Worked with Dimensional Data warehouses in star and snowflake schemas, and creating slowly