This job has expired.
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: rkumar@judge.com
This job and many more are available through The Judge Group. Find us on the web at www.judge.com
This job has expired.
Get Hired Faster
Subscribe to job alerts and upload your resume!
*By registering with our site, you agree to our
Terms and Privacy Policy.
More IT jobs
|
|
|
|
|
|