Previous Job
Previous
ETL Developer
Ref No.: 18-14254
Location: Basking Ridge, New Jersey
JOB TITLE: Sr SQL Server / ETL Developer

JOB DUTIES:
- 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 or Teradata
* 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


* Bachelor's/Master's degree in Computer Science or relevant field

Regards
Hemin
HeminD@lancesoft.com
(703-889-6600)