• 17+ years of overall IT experience with a strong background in software development and 6 Years of experience in Core Mainframe applications and 6+ Years of Experience in DataStage, Informatica & Teradata along with Mainframes and Business Intelligence solutions in Data Warehousing and decision support systems using the ETL tool DataStage.• Over 7+ years of experience with Enterprise Data Warehousing (EDW) projects and Proficient in Extract Transform and Load (ETL) processes involving Teradata, DataStage, Informatica, Mainframe and UNIX shell script.• Trained in Big data Technologies such as HIVE, PIG, SQOOP and SPARK to re-engineer the current Data ware house system.• Strong Knowledge in Data Warehousing methodologies of Star/Snow flake Schemas.• Worked with different DataStage stages like ODBC Connector, Teradata Connector, Transformer, Copy, Merge, Join, Filter, Look-up, and Aggregator stages in ETL.• Strong Data Warehousing ETL experience using SSIS and Informatica 9.6.1 PowerCenter Client tools - Mapping Designer, Workflow Manager/Monitor and Server tools .• Extensive working knowledge in Teradata utilities (TDLOAD, BTEQ, Fast Load, Fast Export, Multiload, TPT and Tpump) and various mainframe tools like ENDEVOR, Panvalet, FILE-AID, FILE-MASTER, OPC, CA-7, SAR, SAVRS, JMR, SPUFI & QMF. • Experience in integration of various data sources like Oracle, SQL Server and Sybase in to Teradata Enterprise Data warehouse using Mainframe Batch processes. • Strong understanding and experience in software development methodologies/concepts like SDLC, AGILE and CMMI process improvement.• Worked in various domains such as Insurance, Finance Retail and Publications, and for various clients namely Royal and Sun Alliance - USA, Merrill Lynch – USA, Marks & Spencer – UK, John Lewis – UK and LexisNexis – USA.• Wide experience in Client facing onsite roles(more than 2 years in London ,UK and 3 Years in Dayton, USA) and client interaction activities