Sumit Mendiratta

Background

About Sumit Mendiratta

Over 13 years of strong IT experience in the Analysis, Design, Modeling, Development, Implementation and Testing of Data Warehouse applications and acquired excellent analytical, co-ordination, interpersonal skills. • Having strong 6 years of Onsite experience as an Informatica Lead/Developer experience.• Having strong 13 years of experience in UNIX/ Unix Shell Scripting and Data warehousing projects using ETL Tools especially Informatica 10.5/10.2/9.6 with Power Center, Informatica Power Exchange, Unix and Oracle Sql.• Development of complete Data warehouse including dimensional modeling (Star Schema and snowflake), FACT and Dimensions Tables from scratch.• Played a key role in the areas of Development,(Unit/Integration) Testing, Implementation post production Support for various project releases.• Extensive development, support and maintenance experience working in all phases of the Software Development Life Cycle (SDLC) especially in Data warehousing. Involved in all aspects of ETL-requirement gathering, coming up with standard interfaces to be used by operational sources, coming up with data load strategies, design, architecting the flow of data from various sources to target, developing mappings, unit testing, integration testing, regression testing and UAT in development