ETL Developer in Harrisburg, PA at D&H Distributing Co.

Date Posted: 10/24/2019

Job Snapshot

Job Description

ETL Developer       

Join a 101 Year old and growing electronics and technology company based in Harrisburg, PA that offers an employee stock ownership plan, competitive pay, an excellent benefits package and paid time off to volunteer in the community.

  • We are empowered by our employee co-owners who provide the industry’s best service and we promote a collaborative culture. 
  • We feel strongly about giving back to the community and promoting sustainable, eco-friendly business practices.
  • We offer an Employee Stock Ownership Plan, Paid Time Off, Medical, Prescription, Dental and Vision benefits as well as Gym Reimbursement and Tuition Assistance.
  • As a D&H Co-Owner you receive numerous discounts on services.

We are looking for an ETL Developer to support our FP&A Department.

Responsibilities: 

  • Supporting, optimizing and monitoring current data warehousing, data modeling, data integration, business intelligence and ETL processes
  • Developing ETL’s using mostly DataStage with some flavors of SSIS to facilitate Extraction, Transformation and Data Load from disparate systems
  • Maintaining methods and procedures for tracking data quality, completeness, redundancy, and improvement
  • Developing and maintaining Netezza and SQL stored procedures and views as part of a star database schema
  • Troubleshooting issues such as connections, failed jobs, application errors, server alerts, space thresholds, etc. within predefined SLAs
  • Proactively maintain and tune SQL code
  • Identifying and capturing lessons learned, best practices, and information gained during performance of tasks
  • Being part of a 24x7 on-call rotation for after hour and weekend production support

Job Requirements

Requirements:

  • High school diploma or general education degree (GED)
  • 3-5 years’ experience extracting and summarizing data from a variety of data source types using ETL tools
  • Experience in writing complex SQL using Netezza and SQL Server with a strong competency in T-SQL
  • Experience interfacing with business users and understanding their requirements
  • Experience with DataStage, QualityStage, DataDirector, SSIS, SSRS
  • Experience with Cognos , Powershell and ActiveBatch is a plus
  • Strong Project Management skills

Why Should You Apply?

  • Opportunities for growth and development
  • Great benefits
  • Competitive industry pay
  • Excellent Work/Life Balance

EOE

CHECK OUT OUR SIMILAR JOBS

  1. Software Engineer Jobs
  2. Project Engineer Jobs