CLDRSRC9298 - SQL Server Integration Services (SSIS) Developer- Remote - Long term Contract

Project Description

The successful candidate must deliver the following in order to successfully complete the engagement:

• Work with the architects and leads to analyze and clarify technical specifications to implement business logic;
• Help develop the infrastructure requirements for a data repository;
• Participate in application development and/or configuration activities to meet business requirements;
• Participate in data migration, cleansing and transformation (ETL) activities such as the design, development and deployment;
• Analyze functional requirements and transform into transformational code;
• Adhere to Guiding Principles and Developer Technical principles;
• Develop and version control SSIS packages for data migration activities
• Develop data views from a data repository as identified during the project
• Participate in defect triage meetings.

Mandatory Requirements

No.

Requirement

Quantity

M1

A University degree in either Computer Science or Information Technology is preferred but an equivalent combination of education and experience may be considered.

Yes

M2

A minimum of five (7) years of IM/IT experience.

7 years

M3

Demonstrated experience with data migrations (Extract-Transform-Load).

Yes

M4

Good verbal and written communication skills in English

Yes

Scored Requirements

SNB seeks resources who demonstrate the following scored requirements.

No.

Requirement

Desired

Experience

S1

Demonstrated experience in design, development, testing and deploying SSIS packages. Describe function, scope and size of the referenced experience.

5 Years

S2

Demonstrated experience in SQL with experience in complex query design. Describe function, scope and size of the referenced experience.

5 Years

S3

Demonstrated ability to work with a range of development methodologies (e.g. Agile, Scrum, Waterfall). Describe function, scope and size of the referenced experience.

5 Years

S4

Demonstrated ability to work in a fast-paced, team-focused environment; proven ability to manage time effectively and prioritize tasks/projects is essential. Describe function, scope and size of the referenced experience.

5 Years

S5

Demonstrated ability to understand, adhere to, and drive existing team processes and ongoing improvements. Describe function, scope and size of the referenced experience.

5 Years

S6

Demonstrated experience working within multi-vendor teams would be considered an asset. Describe role and responsibilities.

5+ years

Deliverables

The successful candidate must deliver the following in order to successfully complete the engagement:

• Work with the architects and leads to analyze and clarify technical specifications to implement business logic;
• Help develop the infrastructure requirements for a data repository;
• Participate in application development and/or configuration activities to meet business requirements;
• Participate in data migration, cleansing and transformation (ETL) activities such as the design, development and deployment;
• Analyze functional requirements and transform into transformational code;
• Adhere to Guiding Principles and Developer Technical principles;
• Develop and version control SSIS packages for data migration activities
• Develop data views from a data repository as identified during the project
• Participate in defect triage meetings.