SQL Server Data Engineer

company banner
Judge Group, Inc.
SQL, Engineer, Teradata, Oracle, Excel, Microsoft Access, Analysis, OLAP, Modeling, VBA, Database, API, Supply Chain, Computer
Full Time
Travel not required

Job Description

Location: Bridgewater, NJ
Description: Our client is currently seeking a SQL Server Data Engineer

Title: Sr SQL Server Data Engineer

Location: Basking Ridge, NJ

Duration: 12+ Months

Description:

Responsible for developing various data pipeline automations using ETL tools like SSIS or Alteryx. This position will be responsible for getting data from various sources like SQL Server, Teradata, Hadoop/Hive, Oracle, Flat files, Excel, Microsoft Access etc. and loading it into SQL server, Teradata, AWS Redshift and Hadoop. - Work with business stakeholders to understand business problems - Identify the data sources needed to build BI solutions like interactive dashboards to solve those business problems - Build ETL workflows to automate data and reporting. - Pulling data from various sources including Microsoft SQL Server, Data Cubes (Analysis Service/OLAP), Oracle, Teradata, Hadoop and other - Modeling the data to be presented well in visual dashboard - Automate the ETL workflows and schedule it to run automatically and manage it by exception - Validate data accuracy - Maintain ETL processes on an ongoing basis.

MUST HAVE SKILLS:

7+ years of experience in working Databases like Microsoft SQL Server

5+ years of experience in working on more than one database technologies like Oracle, Teradata, AWS Redshift

5+ years of experience in building ETL processes using Microsoft SSIS and loading data from multiple sources like SQL Server, Teradata, Hadoop/Hive, Oracle, Flat files, Excel, Microsoft Access etc.

3+ years of experience in getting data in and out of Hadoop/Hive with expertise in Sqoop, Spark and HQL

DESIRED SKILLS:

Working understanding of Microsoft VBA

Experience in Database Administration is a strong plus

Experience with Google API is a Strong plus

Supply Chain background is preferred

EDUCATION/CERTIFICATIONS:

Bachelor?s/Master?s degree in Computer Science or relevant field

REQUIRED SHIFT:

Please indicate whether this position is standard 9-5, if weekend work is required, if the person need to be "on call" at any time, etc.

Contact:

This job and many more are available through The Judge Group. Find us on the web at www.judge.com


Company Information

The Judge Group, celebrating its 50th anniversary, is a leading professional services firm specializing in talent, technology, and learning solutions. We consult, staff, train, and solve. Through our work we make people and organizations better. Our services are successfully delivered through a network of more than 30 offices in the United States, Canada, and India. The Judge Group serves more than 50 of the Fortune 100 and is responsible for over 9,000 professionals on assignment annually across a wide range of industries.

Dice Id : cxjudgpa
Position Id : 656686
Originally Posted : 1 year ago

Similar Positions at Judge Group, Inc.

Database Applications Developer - III
  • Bridgewater, NJ
  • 1 day ago
Database Administrator - II
  • Bridgewater, NJ
  • 1 day ago
Data Scientist
  • Bridgewater, NJ
  • 1 day ago
Big Data Developer - I
  • Bridgewater, NJ
  • 1 day ago
ANALYST - SYSTEMS/ARCHITECTURE - I
  • New Brunswick, NJ
  • 1 day ago
Cloud Data Engineer
  • Woodcliff Lake, NJ
  • 1 day ago
ANALYST - SYSTEMS/ARCHITECTURE - II
  • Bridgewater, NJ
  • 1 day ago
.NET Developer - I
  • Bridgewater, NJ
  • 1 day ago
Data Engineer/Developer II
  • Malvern, PA
  • 1 day ago
Big Data Developer - II
  • Garden City, NY
  • 1 day ago