SSIS Application Designer

Posted 11 January 2023
Job type Permanent

Company's Benefits

  • Paid Parental Leave

    Paid Parental Leave

  • Flexible Working Arrangements

    Flexible Working Arrangements

  • Mentorship Program

    Mentorship Program

  • Leadership Development Program

    Leadership Development Program

  • Raise Numbers Of Women In Leadership

    Raise Numbers Of Women In Leadership

  • Internal Women's Networking Group

    Internal Women's Networking Group

Job Description

Key Role Responsibilities:

• Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from numerous upstream systems for processing by QRM

• Builds data transformations with SSIS including importing data from files, moving data from one database platform to another

• Debug and tune SSIS or other ETL processes to ensure accurate and efficient movement of data

• Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process

• Design, implement and maintain database objects (tables, views, indexes) and database security

• Test and prepare ETL processes for deployment to production and non-production environments

• Support system and acceptance testing including the development or refinement of test plans

Skill & Capability Requirements:

• 4-7 years overall experience as SSIS designer

• Experience working with SSIS packages

• Proficient with ETL tools such as KingswaySoft

What we offer you

Come for the distinctive experiences you have helping forward-thinking corporations, non-profits, and governments push the boundaries of digital innovation.Stay for the limitless learning opportunities that encourage you to master Microsoft and pursue big ideas. Enjoy ambitious growth for yourself as part of Avanade’s people-first culture with benefits like employee share purchasing, flexible work arrangements, a commitment to diversity and inclusion, and competitive pay.