SSIS Developer

Permanent
Montréal
Posted 3 weeks ago

Progression3 is in search of a SSIS Developer for a permanent role with our client in Montreal.

ESSENTIAL DUTIES AND RESPONSIBILITIES

  • Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified.
  • Design ETL processes and develop source-to-target data mappings, integration workflows, and load processes. Involved in gathering, understanding and validating the project specifications and participate in ETL architecture design reviews
  • Create and maintain databases, tables, stored procedures, indexes, database check constraints, and business rules using advanced knowledge of T-SQL.
  • Develop, deploy, and monitor SSIS Packages (for File Transfer from one location to the other using FTP task, data transfer from the Data Warehouse to other corporate systems such as CRM, etc.)
  • Help prepare and run unit, integration, UAT, regression, stress and performance plan documents and tests while documenting results
  • Identify problems, develop ideas and propose solutions within differing situations requiring analytical, evaluative or constructive thinking in daily work
  • Document designs and architect data maps, develop data quality components and establish and/or conduct unit tests
  • Ensure that the data architecture is scalable and maintainable
  • Perform reviews and quality checks after data has been loaded
  • Assist in the resolution of data quality or reconciliation issues post-loading

REQUIREMENTS

  • 5+ years of Data Integration/ETL development experience using SSIS/TSQL
  • Very good working experience of T-SQL queries, Complex Stored Procedures, User Defined Functions UDF
  • Experience in designing, configuring, deploying SSIS packages and providing security for packages.
  • Experience in Error handling, Debugging, error logging for production support in SSIS.
  • Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
  • Follows data standards, resolves data issues, completes unit testing and system documentation for Extract Transfer Load (ETL) processes
  • Familiarity with metadata management concepts, change management/version control concepts
  • Passionate about complex data structures and problem solving
  • Analytical mind with a problem-solving aptitude

Apply Online

A valid phone number is required.
A valid email address is required.