*Job Title :: B**ig Data/Hadoop Consultant*
*Location :: Houston, TX* *Mode of hire: Contract (C2C/W2) * *Duration :: 6+ Month contract* *Rate :: $50/hr on C2C * *Detailed Job Description :* - Big data Analyst - Hive - Import data from a MySQL database into HDFS using Sqoop . - Export data to a MySQL database from HDFS using Sqoop. - Move data between tables in the metastore . - Transform values, columns, or file formats of incoming data before analysis - Use Data Definition Language (DDL) statements to create or alter structures in the metastore for use by Hive and Impala. - Create tables using a variety of data types, delimiters, and file formats . - Create new tables using existing tables to define the schema . - Improve query performance by creating partitioned tables in the metastore . - Alter tables to modify existing schema . - Create views in order to simplify queries . - Use Query Language (QL) statements in Hive and Impala to analyze data on the cluster. - Prepare reports using SELECT commands including unions and subqueries . - Calculate aggregate statistics, such as sums and averages, during a query . - Create queries against multiple data sources by using join commands. - Transform the output format of queries by using built-in functions. - Perform queries across a group of rows using windowing functions. *Atulit Tripathi* Team Recruitment US: 678-496--7809 atulit.tripa...@acsicorp.com -- You received this message because you are subscribed to the Google Groups "CorptoCorp" group. To unsubscribe from this group and stop receiving emails from it, send an email to corptocorp+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/corptocorp/81aecd01-f503-4a10-b1b1-b73e8807eac7%40googlegroups.com.