SSIS, ETL, Dynamics CRM, Kingswaysoft /Senior Consultant Specialist

We are currently seeking an experienced professional to join our team in the role of Senior Consultant Specialist. In this role, you will be responsible for designing and developing SSIS/SQL ETL solutions to acquire and prepare data from various systems.

Responsibilities:

• Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
• Build 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.
• Analyze and develop strategies and approaches to import and transfer data between source, staging and various destinations.
• Test and prepare ETL processes for deployment to production and non-production environments.

Requirements:

• Proficient with SSIS ETL tools and MS CRM Data model, Kingswaysoft, Azure Data Factory.
• Minimum 8-10 years of experience.
• Hands-on experience on different transform components like conditional split, derived column, data conversion, BDD, merge join, multicast, File system task.
• Excellent communication, presentation, training, client relationship and analytical skills.
• Experience working on Agile projects and CI/CD pipeline.
• C# programming skills.

Benefits:

• Opportunities for career growth and professional development.
• Flexible working arrangements.
• Inclusive and diverse work environment.