7+ years of IT experience in Datawarehousing and ETL Development using Informatica, Teradata, Db2, SQl, Qlikview ,BO and Unix.
Self-motivated and result driven with vision of being the best in what I do and contributing to the success of the organization that I work for.
Professional Summary
*7+ years of IT experience in Analysis, Design, Development and Implementation with major focus on database and data warehousing applications for Banking and Finance Sector on Informatica/Teradata/DB2/MSSql/Qlikview/UNIX.
*Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
*Extensively worked on Relational and Dimensional Data modeling (Star / Snowflake models), FACT & Dimensions tables, Physical & logical data modeling, slowly changing Dimensions, Data cleansing and Data Staging of operational sources using ETL processes for data warehouses.
*Have extensively worked in developing ETL program for Data Extraction, transformations and loading using Informatica Power Center.
*Experience in implementing the complex business rules by creating transformations, re-usable transformations (Expression, Aggregator, Filter, Connected and Unconnected Lookup's, Router, Rank, Joiner, Update Strategy etc.) and developing complex Mapplets and Mappings.
*Expert in implementing business rules using Teradata SQL. I have extensively worked on Teradata Utilities such as FastExport, FastLoad, MultiLoad and BTEQ to move data from UNIX/flat files to Teradata and vice versa.
*Extensive experience in creation of Extract Transform and Load (ETL) process using Teradata SQL-Stored Procedure and Informatica PowerCenter clients such as Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
*Proven experience in Data Warehousing which includes analysis of Source Systems (DB2, VSAM, Flat File, etc.), Staging area & Target systems Data.
*Proven experience in Unix Shell Scripting in different projects.
*Experience in leading the teams in delivering the code with perfection in terms of Accuracy, Reusability, Maintenance, Performance, Low Complexity and Less Inventory, achieving maximum customer satisfaction.
*Actively involved in Performance SQL Tuning, ETL tuning and Error handling.
*Experience in Developing mapping design documents for ETL process.
*Proficient in understanding business processes/requirements and translating them into technical requirements and documents.
*Experienced in Test data preparation, building test cases and execution of testing scenarios for defect-free result oriented coding.
*Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.
*Efficient in following quality procedures for development and implementation.
*User facing skills and client relationship skills