Previous Job
SQL Server Integration Developer
Ref No.: 18-02676
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.

Essential Responsibilities
  • Design and develop integrated data application solutions using SQL Server Databases, SSIS ETL/Integration packages, and stored procedures.
  • Test, document and deliver completed SSIS packages for QA/UAT validation.
  • Interpret and maintain business requirement integrity for external customer integration/EDI data projects and internal application integration data requirements
  • Document ETL mapping specifications.
  • Interpret and conduct test cases for Integration/EDI solutions to produce high quality application deliverables for customer and internal projects.
  • Create, optimize and maintain T-SQL as part of stored procedures, views, functions, and queries.
  • Analysis of existing code and database structure for reuse and improvements
  • Perform and maintain data extracts and imports.
  • Integrate applications with current databases.
  • Communication and analytical skills to effectively capture, develop and implement the business requirements.
  • Troubleshoot data issues, validate result sets, recommend, and implement process improvements.
  • Build SSIS ETL packages using solid integration design, data architecture, and high performance techniques.
  • Create, develop and maintain new SSIS integration packages that support EDI transaction sets including X.12, flat file, XML and web service integrations.
  • Collaborates with customers and internal business partners.
  • Maintains configuration settings for EDI/FTP interfaces and partner profiles including monitoring, troubleshooting, and scripting.
Required Skills and Experience
    • Excellent written and oral communication skills required.
    • Works well in collaborative team environment.
    • Self-starter with strong analytical and troubleshooting skills.
    • Maintains company core values – Customer-centric, Accountable, Curious and Collaborative.
    • Bachelor's degree in Computer Science or business experience equivalent required.
    • Minimum 3 years of IT/business experience.
    • 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.
    • Experience with integration of ERP, Warehouse Management, Transportation Management, and Accounting a plus.
    • Distribution, logistics, supply chain, and/or manufacturing industry experience a plus.