Job Description :
SQL/ ETL Data Engineer
Morristown, NJ
1+ year
Responsibilities:
Work with stakeholders to access business concerns, gather requirements, understand processes and validate project requirements
Identify data sources and build pipelines using various ETL tools such as but not limited to, SSIS, and Alteryx. Data sources including but not limited to SQL Server, Teradata, Hadoop\Hive, PostgreSQL, Oracle and flat files.
Create and optimize data models to support data visualizations.
Expert knowledge of data warehousing.
Test and validate data.
Automate and support workflows to ensure timely delivery.
Must Have
7+ years of SQL Server database development experience
5+ years of ETL experience
5+ years of experience in working on more than one database technologies Oracle, Teradata, AWS Redshift
2+ years big data experience, Hadoop, Hive, Spark
5+ years of experience in building ETL processes using Microsoft SSIS and Alteryx loading data from multiple sources like SQL Server, Teradata, Oracle, Flat files, Excel, Microsoft Access etc.
DESIRED SKILLS
BI Lifecycle management
Working understanding of Microsoft VBA, Python
Experience with Google API is a Strong plus
Supply Chain background is preferred
Hands on exposure to Tableau or other visualization tools
EDUCATION/CERTIFICATIONS
Masters in Computer Science or rel