Overall 10 years of IT experience in the Business Analysis, Design, Data Modeling, Coding, Implementation and Testing of Applications using wide range of Technologies including Data Warehousing, Database and reporting systems for Sales, & Distribution, Retail and Finance Industries.
• Having good expertise in migrating various Informatica sessions and mappings from one version to another.
• Well versed with Informatica 8.1, 8.6, 9.1, 9.5, 9.6 64 bit.
• Experience in working with all the transformations in Informatica and applying the logic with the requirement.
• Data warehousing experience using InformaticaPowerCenter 9.x/8.x/7.x/6.2/5.0, Informatica Power Exchange 8.1 and extracting data from Db2, Oracle, MS SQL Server, MS Access, AS400.
• Extensive experience on Data Quality by creating checks to know the Quality of Data in AmeriCredit project.
• Sound knowledge on Informatica Data Qualityconceptsand IDQ tool.
• Extensive experience in using various Informatica Designer Tools like Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer and Warehouse Designer.
• Knowledge on reporting tool Business Objects.
• Experience in integration of various data sources from Databases like MS Access, Oracle, SQL Server and file formats like flat-files, CSV files, COBOL files and XML files.
• Sound knowledge of Oracle 10g/9i/8i/8.0/7.x, MS SQL Server 2000, MS Access 2000, PL/SQL, SQL*Plus, DB2 8.0.
• Worked on various database tools like Toad, SQL Developer, PL/SQL Developer, Rapid SQL developer.
• Extensively executed SQL queries on Oracle using Toad and SQL server tables in order to view successful transaction of data and to validate data.
• Good knowledge of Data warehouse concepts and principles (Ralph Kimball / Inman), Star Schema, Snowflake, SCD.
• Experience in integration of various data sources with multiple Relational Databases like Oracle, SQL Server, IBM DB2 and XML filesand worked on integrating data from flat files like fixed width and delimited.
• Used informatica NORMALIZER Transformation to convert the data from Legacy systems.
• Expertise in several key areas of Enterprise Data Warehousing such as Change Data Capture (CDC), Data Quality, and lookup Tables and ETL data movement.
• Experience in identifying Bottlenecks in ETL Processes and Performance tuning of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization/ Denormalization strategies.
• Experience in database performance tuning.
• Experience in using the Informatica command line utilities like pmcmd to execute workflows in non-windows environments.
• Experience in debugging mappings. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Good knowledge in Informatica BIG data concepts and BDE tool.
• Experience in ETL testing, involved in QA testing with various teams.
• Highly Motivated to take independent responsibility as well as ability to contribute and be a productive team member
• Ability to work in multiple projects simultaneously.