Sr SQL Server Data Engineer

  • location: Basking Ridge, NJ
  • type: Contract
easy apply

job description

Sr SQL Server Data Engineer

job summary:
Sr SQL Server Data Engineer is 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.

 
location: Basking Ridge, New Jersey
job type: Contract
work hours: 8am to 5pm
education: Bachelors
 
responsibilities:
JOB TITLE: Sr SQL Server Data Engineer

JOB DUTIES: Sr SQL Server Data Engineer is 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

 
qualifications:
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

 
skills: SQL Server Data Engineer

data pipeline automations

ETL tools

SSIS

Alteryx


Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.

easy apply

get jobs in your inbox.

sign up
{{returnMsg}}

related jobs

    .NET Development Lead

  • location: Florham Park, NJ
  • job type: Temp to Perm
  • salary: $59 - $61 per hour
  • date posted: 5/14/2020


    Sr. Manager PK/PD

  • location: Princeton, NJ
  • job type: Permanent
  • salary: $130,000 - $135,000 per year
  • date posted: 5/6/2020