Country:

Malaysia

Cities:

Kuala Lumpur

Area of expertise:

Analytics

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.


Apply now

Share this job:

Share Facebook Twitter

About Avanade

Avanade is the leading provider of innovative digital, cloud and advisory services, industry solutions and design-led experiences across the Microsoft ecosystem. Every day, our 59,000 professionals in 26 countries make a genuine human impact for our clients, their employees and their customers. 


We have been recognized as Microsoft’s Global SI Partner of the Year more than any other company. With the most Microsoft certifications (60,000+) and 18 (out of 18) Gold-level Microsoft competencies, we are uniquely positioned to help businesses grow and solve their toughest challenges.


We are a people first company, committed to providing an inclusive workplace where employees feel comfortable being their authentic selves. As a responsible business, we are building a sustainable world and helping young people from underrepresented communities fulfil their potential. 


Majority owned by Accenture, Avanade was founded in 2000 by Accenture LLP and Microsoft Corporation. Learn more at www.avanade.com