SQL ETL Developer in Cincinnati, OH at Vaco

Date Posted: 12/3/2019

Job Snapshot

Job Description

Looking for an integration engineer to develop ETL processes between front office, back office and downstream systems. Analyze, plan, and execute ETL development, monitoring and enhancement

• Experience designing, developing, and deploying SSIS packages that load data from multiple sources into centralized database.

• Identify and test for bugs and bottlenecks in the ETL solution

• Proficient in how to deploy to and debug a production SSIS packages.

• Experience in writing advanced SQL including some query tuning

• Knowledge of Informatica is preferred

Requirements:

3 to 5 years working with relational databases - modeling, stored procedures, functions and triggers. Preferred knowledge: SQL Server 2014

Experience with obtaining data from external API's in JSON format

Experience:

  • SQL: 2 years (Required)
  • ETL: 4 years (Required)
  • SSIS: 2 years (Required)