ETL-Data Engineer in Woodbridge Township, NJ at Open Systems Technologies

Date Posted: 11/2/2019

Job Snapshot

Job Description

A financial services company is seeking an ETL/Data Engineer to join their team in Iselin, NJ.

Responsibilities

  • Design and Implement ETL solutions using SQL Server Integration Services 2012 and 2016, TSQL and Stored Procedures
  • Design and Implement Big Data/Data Lake applications on cloud platform
  • Provide advanced technical support in design and use of information systems technology including ETL Design and database management
  • Evaluate existing ETL architecture/design of information technology systems and providing alternative solutions and recommend appropriate path for a product/project
  • Evaluate, design and implement Data Warehouse applications on cloud platform
  • Develop and implement ETL strategies, providing technical guidance during all phases of the software development lifecycle
  • Conduct code reviews, analyze execution plans, and re-factor inefficient code
  • Adhere to data standards, resolve data issues, complete unit testing and system documentation for ETL processes
  • Perform system tests, troubleshoot customer issues, and correct database defects
  • Respond to bug fixes and enhancement requests

Qualifications

  • A Bachelor’s degree or higher in computer science or a related field
  • 4+ years of IT experience with 3+ years should be in data engineering
  • 2+ years of experience implementing Data Lake applications in cloud platform
  • 2+ working experience implementing ETL solutions using SSIS
  • Experience with Database Design and Data Modeling
  • Strong SQL skills
  • Experience in MS SQL Server; experience with other databases such as DB2 or Oracle a plus
  • Experience with Microsoft Business Intelligence Toolset
  • Experience in database-related performance tuning
  • Excellent communication skills
  • Able to work with and motivate diverse, globally distributed teams
  • Quality oriented with great attention to detail
  • Experience in financial services preferred
  • Experience with Microsoft Data Transformation Services (MS DTS) preferred
Job keywords: