SSIS Application Designer
- Posted 11 January 2023
- LocationMalaysia
- Job type Permanent
- DisciplineTechnology
- Reference55534
Company's Benefits
-
Paid Parental Leave
-
Flexible Working Arrangements
-
Mentorship Program
-
Leadership Development Program
-
Raise Numbers Of Women In Leadership
-
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.