Extensively worked on data extraction, Transformation and loading data from various sources like Oracle, SQL Server and Flat files.
Responsible for all activities related to the development, implementation, administration and support of ETL processes for large scale data warehouses using Informatica Power Center.
Strong experience in Data Warehousing and ETL using Informatica Power Center 8.6.
Had experience in data modeling using Erwin, Star Schema Modeling, and Snowflake modeling, FACT and Dimensions tables, physical and logical modeling.
Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL processes.
Had knowledge on Kimball/Inmon methodologies.
Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
Extensive experience in ETL design, development and maintenance using Oracle SQL, PL/SQL, SQL Loader, Informatica Power Center v 5.x/6.x/7.x/8.x.
Experience in testing the Business Intelligence applications developed in Qlikview.
Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).
Well versed in UNIX shell scripting.
Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used pager for notifying the alerts after successful completion.
Excellent communication, documentation and presentation skills using tools like Visio and PowerPoint.