Previous Job
SQL Server Integration Developer
Ref No.: 18-02625
Location: Wauconda, Illinois
Position Type:Full Time
SQL Server Developer - SSIS and ETL

We have a well established logistics firm in the far north burbs of Chicago. They are in the process of migrating to a new ERP system so the Data Engineering team is growing. Due to this growth they are looking for a SQL Server Developer who is well versed in SSIS, ETL and overall database integration and development. The SQL Server Developer's primary responsibilities include developing and supporting Integration / ETL solutions. Performs day-to-day monitoring, maintenance and development of integration between ERP, financial, warehouse management, and customers.

  • Design, develop, test, deliver integration and EDI solutions using SQL Server Databases, SSIS ETL/Integration packages, and stored procedures.
  • Analyze business requirements for external customer integration/EDI data feeds and internal application integration data requirements to define ETL mapping requirements.
  • Develop test cases for Integration/EDI solutions to support high quality deliverables
  • Write T-SQL code, build SSIS ETL Packages using sound Integration design, data architecture, and high performance techniques.
  • Creates new EDI and supports existing EDI transactions using SSIS, X.12, AS2, and FTP.
  • Develops and supports integration of Non X12 EDI files with trading partners using XML, Flat Files, AS2,FTP
  • Interacts with internal/external customers and trading partners on a daily basis in a professional manner.
  • Maintains configuration settings for EDI/FTP interfaces and partner profiles including monitoring, troubleshooting, and scripting.

  • Minimum 3 years of IT/business experience and Bachelor's degree in Computer Science or business experience equivalent required.
  • 3+ years SQL Server, T-SQL and SSIS experience required.
  • 2 or more years working with source control applications, Microsoft TFS preferred.
  • Windows EDI and cross platform Integration experience a plus.
  • Very good written and oral communication skills required.
  • Works well in team environment.
  • Experience with integration of ERP, Warehouse Management, Transportation Management, and Accounting a plus
  • Distribution, logistics, supply chain, and/or manufacturing industry experience a plus.