• Around 4 years of IT experience with experience in Design, Development and Implementation of Data warehouses as an ETL Developer. Expertise in Designing & Developing complex Extract, Transform and Load (ETL) applications using Informatica Power Center 9.1/9.6.
• Experienced in the Analysis, Design, Development, Testing of Data warehouses and Data marts. Extensive Knowledge of Dimensional Data Modeling of Star Schema/Snowflake and Relational database concepts.
• Experienced in using various Transformations such as Expressions, Filters, Aggregators, Lookups, Routers, Joiner and Sequence Generator etc. to load consistent data in to Oracle databases.
• Worked on multiple Data warehousing projects with complete Software Development Life Cycle process starting with Requirements Analysis, Technical Analysis, Design, Build, Test, Deploy and Production support.
• Analyzed, Designed and Implemented different stages of Data Warehouse.
• Experience in integration of data sources like Oracle, MS Excel and Flat Files into staging area.
• Good working experience on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in Audit, Balance checks and Error handling techniques.
• Implemented complex business rules in Informatica by creating re-usable transformations, and robust mappings/mapplets. Experience in loading data, troubleshooting, Debugging mappings, tuning mappings, etc.
• Designed and