Implemented solutions for ingesting data from SQL sources and processing/storing the data by utilizing Big Data Technologies such as HDFS, Hive, Sqoop etc. Extensively worked with Partitions, Dynamic Partitioning and Bucketing tables in Hive and designed both Managed and External tables and also worked on optimization of Hive queries. Wrote Hive Queries to have a consolidated view of the provider data and Involved in troubleshooting errors in Hive scripts. Solved performance issues in Hive scripts with understanding of Joins, Group and Aggregation. Used Sqoop to import data from SQL server DB to Hive in HDFS. Exported the analyzed data to the relational databases using Sqoop to generate business reports. Actively participated in Data Migration Projects working closely with business users and stakeholders. Engaged in developing of mapping documents used for the development and designing of reports.

Engaged in developing of mapping documents used for the development and designing of reports. Designed Dashboards with required metrics to fulfill business needs and amplify business decisions. Involved in brainstorming, consultation and troubleshooting of several technical problems faced during the data migration and application development processes. Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, Slowly Changing Dimension, Merge Join and Union all. Responsible for Documenting the requirements, design and coding changes. Maintained versions for the code for every change. Followed approval process to migrate the changes from UAT (User acceptance Testing) environment to Production

Studied the client requirement and design. Developed mappings and workflows, prepared of unit test case, unit test data and data validation. Validated legacy source files before Job execution by using Informatica Power Exchange. Performed Data cleansing in the source and loaded into staging tables for each data conversion. Before data conversion, identified the risks in the various environments; defines the right probability, severity and impact for the risk and shares with management levels. Headed a team of 4 to complete a complicated time critical task. Interacted with Managers to analyze business needs and developed technical specifications. Identified the Risks, Mitigation and Contingency plan with target date. Responsible for performing the Unit and Integration Testing after implementation of Change Requests