About Me

Over 5 years of IT industry experience and 3.5 years in Datawarehouse analysis, development, implementation and support of Data integration with ETL Informatica. Worked with all phase of Software Development Life Cycle involving ETL and databases. Ex...nformatica. Worked with all phase of Software Development Life Cycle involving ETL and databases. Experience with ETL Informatica Power Center 9.x /10.x Strong work experience with Business Users to analyze the business process model and made necessary changes to schema objects to cater users reporting needs. Sound Knowledge in Data Warehousing Concepts. Experience in integration of data sources like Oracle and Flat Files. Proficient in using Informatica PowerCenter Designer Tool Transformation Developer, Mapplet Designer, Mapping designer and Workflow Manager Tools Task Developer, Workflow and Worklet Designer. Experience in designing and developing from varied transformation logic like Unconnected and connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy, Joiner, Union and Source Qualifier. Experience on implementing the types of Slowly changing dimensions (SCDs)- Type I and II in different mappings to load the dimension tables. Experience in working on Incremental load by using mapping variables. Experience in working on Parameterization also created parameter files. Created Mapplets and Re-usable Transformations for applying few logics. Created Connected, Un-Connected & Dynamic lookups. Experience in working on different tasks like Assignment, Event-wait, Email and Command task available in workflows manager, Informatica PowerCenter. Involved in Deployment activities to deploy multiple informatica object from DEV to QA. Involved in Debugging and Troubleshooting Informatica mappings. Extensively used various Performance Tuning techniques to investigate various bottlenecks in informatica to improve the performance for data loads. Worked on Versioning Concepts on Informatica PowerCenter. Perform unit testing at various levels of the ETL. Experience in working with Tables, Views Knowledge with UNIX Commands. Excellent interpersonal, analytical skills, communication skills, self-motivated, quick learner, team player and leadership abilities.