Previous Job
Previous
SQL/Hive Developer
Ref No.: 18-00333
Location: New York, New York
Position Type:Contract
Start Date / End Date: 07/31/2018 to 07/31/2019
Job Title: SQL/Hive Developer
Location: Midtown, NY
Job Type: Contract
Duration: 6-12 months
Contact Info: Ella Blank - eblank@techlink.com - 201-786-2414

Job Description:
  • We are looking for a SQL/Hive developer who will assist with development across our Hive based Hadoop stack.
  • In this role you would be working with a team of Big Data developers, data analysts, and business users to develop, implement and fully test the appropriate solutions on Big Data Platform.
Required Skills & Qualifications:
  • Intermediate to strong understanding of ANSI SQL (roughly 3+ years of experience)
  • Experience working with large data sets (basic understanding of a data warehouse design and principles)
  • Core SQL design & development (Schema design, Data Modeling, DML, DDL)
  • Performance tuning, analysis and optimization of SQL code, must be able to review and optimize large & complex SQL scripts.
  • Build & manage ETL jobs and new data pipelines from various structured and unstructured sources into Hadoop using Hive (SQL)
  • Foundational knowledge in Linux/Unix (filesystem understanding, permissions, automation, basic shell scripting)
  • Basic understanding of code management principles & best practices. Effective use of SCM technologies (BitBucket, Git etc.)
  • Must be able to work well within a fast-paced & skilled development team and able to provide and receive peer code review.
Nice to have skills:
  • Hands-on experience coding in Java and/or Python
  • Understanding of Hadoop eco-system tools/technologies: YARN, HDFS, Hive, Map/Reduce, Spark, Druid, Zeppelin, Ambari, Sqoop, Atlas, Ranger etc.
  • Big Data Application development using various big data technologies including Hive, Hbase, Phoenix, Java Map/Reduce and Sqoop
  • Experience with an orchestration tool (preferably Cisco TIDAL)
  • Basic understanding of an MPP system such as IBM Netezza or Redshift
All offers of employment at TechLink, Inc. are contingent upon clear results of a thorough background check.

Background checks will be conducted on all final candidates.

Background checks will include: Social Security Verification, Prior Employment Verification, Professional References, Educational Verification, Criminal History, Motor Vehicle Records and E-verify.