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

In this role, you will: 

• Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.
• Designing and developing SSIS / SQL ETL solutions to acquire and prepare data from various systems.
• 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, implement and maintain database objects (tables, views, indexes ) and database security.
• 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.
• Support system and acceptance testing including the development. Should be able to troubleshoot existing packages 

To be successful, you will:

• Proficient with SSIS ETL tools and MS CRM Data model, Kingswaysoft, Azure Data Factory. Min 8- 10 Years of experience.
• Should have hands on experience on different transform components like conditional split, derived column, data conversion, BDD, merge join, multicast, File system task,
• Experience on working on a Dynamics CRM Online Project. C# programming skills.
• Experience working on Agile projects.