Senior SSIS Software Engineer

Kyiv, Ukraine

(82604973)

Striving for excellence is in our DNA. Since 1993, we have been helping the world’s leading companies imagine, design, engineer, and deliver software and digital experiences that change the world. We are more than just specialists, we are experts.

DESCRIPTION


Our client is US leading provider of business information and analytics. It is a global company with proven experts in the areas like risk assessment, underwriting support, investment and marketing decisions, preventing fraud, and business performance improvement in daily operations.

The current project stage is aimed for migration MS SQL Server 2005 to MS SQL Server 2014. Majority of the migration is done, however there are still small pieces need to be migrated in the nearest future. Customer is also in a process to migrate DTS packages into SSIS.

Project plans for 2018 are to rewrite/refactor criminal reports generation. The volume of the data is quite big.

Responsibilities

  • Ensure SQL agent jobs, scheduled tasks, ETL processes and services run successfully;
  • Review SQL code and recommend optimizations while enforcing best practices;
  • Generate and deliver reports on a scheduled basis;
  • Develop best practices, evaluate, recommend, and apply alternate/new technologies/best practices.

Requirements

  • Expertise in SQL Server Integration Services;
  • Proficiency in MS SQL Server (2005/2008/2012/2014);
  • DTS expertise;
  • Deep knowledge of T-SQL;
  • Practical expertise in performance tuning and optimization, bottleneck problems analysis;
  • Solid technical expertise and troubleshooting skills;
  • Strong communication skills;
  • Good verbal and written English (Intermediate or higher);
  • Readiness to go extra mile;
  • Experience in SSRS is a big plus;
  • Experience in Pentaho Data Integration is a big plus;
  • Experience in AS400/DB2 is a big plus.

We offer

  • Competitive compensation depending on experience and skills;
  • Individual career path;
  • Social package - medical insurance, sports;
  • Sick leave and regular vacation;
  • Partial coverage of costs for certification and IT conferences;
  • English classes with certified English teachers;
  • Flexible work hours.