SSIS Developer

Come join us

We are looking for a seasoned Senior SSIS Developer with a strong background in data integration and ETL development, particularly using SQL Server Integration Services (SSIS). While the primary focus of this role is SSIS development, a working knowledge of Dynamics 365 CRM is highly desirable. The ideal candidate will bring deep expertise in SSIS and related technologies, with the ability to support CRM integrations, customizations, and enhancements as needed. You'll solve problems using CRM solutions as you liaise between Avanade clients and project teams made up of Project Managers, Back-End and Front-End (UX) Architects, and other CE professionals. This role provides the opportunity to work for Microsoft's #1 partner with an unrivalled focus on personal development and training in both technology and softer consulting skills.

Skills and experiences

• 6+ years of experience with SSIS and ETL processes in enterprise environments.
• Strong command of SQL Server , including T-SQL, stored procedures, and performance tuning.
• Proficient in C# and object-oriented programming .
• Familiarity with Dynamics 365 CRM customization and solution management.
• Experience with Bitbucket , Web API , JavaScript , and RESTful services .
• Understanding of DevOps practices , especially with Jenkins pipelines.
• Solid problem-solving skills and ability to work in a collaborative team environment.

Good to Have:

• Microsoft Power Platform or Dynamics certifications.
• Experience with SSIS and KingswaySoft tools.
• ReactJS experience for front-end development.

About you

Characteristics that can spell success for this role

· Analytical, curious, agile

· Team player and good communicator

· Problem-solver, patient, quality-driven

· Self-motivating

· Innovative mindset

What you'll do

· SSIS Development (Primary):

o Design, develop, and maintain SSIS packages for data extraction, transformation, and loading (ETL) processes.

o Integrate data from various sources into Dynamics 365 and other internal systems.

o Monitor, optimize, and troubleshoot SSIS jobs to ensure efficient and reliable data flow.

· CRM Customization & Integration (Secondary):

o Customize Dynamics 365 entities, attributes, views, forms, and workflows.

o Use C# Web APIs to develop integrations between CRM and other systems.

o Utilize tools like XRM Toolbox and REST APIs for CRM data manipulation.

· Version Control & DevOps:

o Use Bitbucket for version control and collaboration.

o Participate in CI/CD pipelines using tools such as Jenkins for deploying data and CRM solutions.

· Development & Testing:

o Write clean, maintainable, and well-documented code in C# and JavaScript .

o Conduct unit testing using frameworks that mock CRM Context and Http Context.

Enjoy your career

Some of the best things about working at Avanade

• • Opportunity to work for Microsoft's Global Alliance Partner of the Year, with exceptional development and training (minimum 80 hours per year for training and paid certifications)
• Real-time access to technical and skilled resources globally
• Dedicated career advisor to encourage your growth
  Engaged and helpful coworkers genuinely interested in you

Find out more about some of our benefits

Employee Benefits at Avanade | Avanade

A great place to work

As you bring your skills and abilities to Avanade, you'll get distinctive experiences, limitless learning, and ambitious growth in return. As we continue to build our diverse and inclusive culture, we become even more innovative and creative, helping us better serve our clients and communities. You'll join a community of smart, supportive collaborators to lift, mentor, and guide you, and to lean on your expertise . You get a company purpose-built for business-critical, leading-edge technology solutions, committed to improving the way humans work, interact, and live. It's all here, so take a closer look

We work hard to provide an inclusive, diverse culture with a deep sense of belonging for all our employees. Visit our Inclusion & Diversity page.

Create a future for our people that focuses on

• Expanding your thinking
• Experimenting courageously
• Learning and pivoting

Inspire greatness in our people by

• Empowering every voice
• Encouraging boldness
• Celebrating progress

Accelerate the impact of our people by

• Amazing the client
• Prioritizing what matters
• Acting as one