Loaded the data in HDFS from local system • Writing the pig scripts for processing the data • Created hive table with schema and loaded the data using Sqoop • Implemented Partitioning, Buckets tables in Hive • Writing queries in hive on data resided in HDFS • Processed the data using Spark according to business requirement.

Responsibilities: Used Spring to develop light weight business component.  Used Spring IOC for dependency injection and Spring AOP for cross cutting concerns like logging, security, and transaction management.  Designed, developed and maintained the data layer using Hibernate, and used Spring ORM to integrate with Hibernate.  Used XML for the data MS Exchange and used SAX and DOM parser to extract and read the required information from the XML.  Developed Web services using REST, WSDL, UDDI and XML.  Developed Session Beans for the business logic.  Used JMS for asynchronous data communication.  Created Stored Procedures using PL/SQL.  Performed unit testing using JUnit and used test cases for testing action classes.  Monitored the logs using log4j and fixed the problems.  Used Ant to automate the build and deployment process

Roles & Responsibilities: Created MySQL Tables, Views, Constraints Load the data from MS Excel to MYSQL table and MYSQL table to MS Excel. Managed performance of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace. Loaded the data using the SQL loader, Imports database on file formats. Designed and implemented schema. Experience writing complex SQL Queries.