Job Description :
Experience in design and implementation of various BI & ETL projects Experience in End TO End DW life cycle including requirement gathering, gap analysis, dimensional modeling , reporting & dashboard solution design and development using Micsrostrategy, IBM Infosphere DataStage 9.1 , Informatica 9.5.1 , Microsoft BI stack( SSIS,SSAS,SSRS ), PowerBI. Expertise in Data Modeling for small to large scale businesses and handling complex business needs Design and Implementation of ETL solutions with effective resign and optimized performance ETL Development with industry standard recommendations for jobs recovery, fail over, logging, alerting mechanisms Excellent analytical and problem solving skills. Expertise in transform business requirement into Functional and Technical document. Expertise in different databases like SQL, Oracle, and Teradata. Hands on experience for complex query writing and query optimization in different databases.

Hands on in different BI and ETL tools.

Hadoop Technologies - AbInitio, Linux, BigData components - HDFS, Pig, Scoop, HiveQL

Experience in creating ETL data mapping document to load the data in Hadoop environment.