Objective :Continue working on Data Engineering initiatives in close collaboration with business. Presently, I am working with Chubb Insurance since Apr 2022. Prior experiences with corporates such as Trianz Consulting (11+ years), WIPRO (8 + years), IGATE (1 year) and TISCO Ltd. (2+years). My global onsite work experience includes US (9 years) and UK (two and half years). Over 24 years of experience in IT of which for past 22 years in Data Warehousing and BI implementation as a Consultant, Technical Lead, Designer and Developer with Primary focus on ETL designing and development with the tool IICS/Informatica Power center, Oracle & Teradata Database programming, Data Analysis and Data Modeling. Extensive experience in the tool Informatica Power center, Data validation options and Test data management (TDM). Equipped with knowledge in Hadoop-Big data implementations using technologies such as, Hadoop, HDFS, HIVE, PIG, Apache-SPARK, FLUME, MAP-R concepts, Hbase, Sqoop, Impala, YARN , Scala and Python programming. Experienced in Data Modeling, ETL architecture, strategy for data movement and transformation and data cleansing Self-trained on Snowflake and Azure cloud  Global/Onsite working experience with USA (9 years) and UK (2 and half years) customers  Extensive experience in implementing multiple DW projects and integrating them for implementing global Data Warehouse solutions Extensive experience with Informatica power center and Oracle SQL, PL/SQL (function/procedure/package/trigger) in implementing DW solutions for complex business scenarios. Experienced in Data modeling using the tool Erwin Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like Multiple Relational Databases and Flat Files Extensive experience in working on the Insurance domain projects, with the customers such as Prudential Plc, AVIVA Plc, Nationwide Insurance, Zurich North America, Liberty Mutual and CHUBB insurance. Experience with IBM DB2 UDB and Teradata database and Teradata Utilities such as Fastload, Multiload and FastExport and TPT loaders. Working knowledge of reporting tool Business Objects. Working knowledge of the reporting tool Cognos Framework Manager. Have worked on Data warehousing projects across various business domains (Finance, Insurance, Retail Banking, Securities, Healthcare, Manufacturing and Telecom) Knowledge in UNIX basic, UNIX command line executables, parameters and shell scripts.