• Experience in Hadoop and Data warehousing with business understanding of Health Insurance and Retail domain. • Expertise knowledge and hands on experience with Pyspark, Spark,Datastage, Bigintrgrate,Hive,Hbase,Cognos,Unix, Spark sql • Extensive experience in Extraction, Transformation and Loading (ETL) data from various Sources into Data Warehouses and Data Marts using Informatica and Datastage • Experience in debugging, troubleshooting and monitoring using Datastage Designer and Director. • Hands-on knowledge of creating parallel jobs using various stages Join, Merge, Lookup, Funnel, Sort, Transformer, Filter and aggregator in Datastage 8.6,11.3,11.5(Bigintrgrate) • Good understanding of relational database management systems like SQL, IBM DB2 and Teradata and writing HQL's in Hive. • Knowledge and Experience of a new cloud based BI tool-“BIRST” which is an integrated platform for Data Modeling, ETL, Reporting and Dashboard creation. • Interpersonal skills, ability to quickly grasp new concepts, both technical and business related and utilize as needed.