Technical CRM Developer (SSIS)

Job Title:- Technical Consultant/ Developer CRM

Experience in SSIS is Mandatory

Work Location:- LTIM Pan India

Experience:- 5+ Years

Qualification

Must have skill

Proficient with SSIS ETL tools. Min 4- 5 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,

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. Good to have CRM knowledge.

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

Preferred Skills

Experience on working on a Dyanmics CRM Online Project

C# programming skills

Experience working on Agile projects

Experience working with CI/CD pipeline

Requirements

Working knowledge of process development and industry specific best practices

High degree of insight and analytical skill

Ability to work independently, prioritize and solve problems proactively

Creative problem solving and conflict resolution

Excellent facilitation, discovery, analysis, and prototyping skills

Team-oriented; willing to align work with teams priorities and goals

Creates high-quality deliverables

Excellent communication, presentation, training, client relationship and analytical skills

Places emphasis on project value and client satisfaction

Successful completion of applicable product certification exams