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.
Responsibilities:
SSIS Development (Primary):
Design, develop, and maintain SSIS packages for data extraction, transformation, and loading (ETL) processes.
Integrate data from various sources into Dynamics 365 and other internal systems.
Monitor, optimize, and troubleshoot SSIS jobs to ensure efficient and reliable data flow.
CRM Customization & Integration (Secondary):
Customize Dynamics 365 entities, attributes, views, forms, and workflows.
Use
C# Web APIs
to develop integrations between CRM and other systems.
Utilize tools like XRM Toolbox and REST APIs for CRM data manipulation.
Version Control & DevOps:
Use
Bitbucket
for version control and collaboration.
Participate in CI/CD pipelines using tools such as
Jenkins
for deploying data and CRM solutions.
Development & Testing:
Write clean, maintainable, and well-documented code in
C#
and
JavaScript
.
Conduct unit testing using frameworks that mock CRM Context and Http Context.
Requirements:
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.