SSIS Developer, ETL, Dynamics CRM, Kingswaysoft / Senior Consultant Specialist
HSBC View all jobs
- Pune, Maharashtra
- Permanent
- Full-time
- 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 team’s 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
- 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,
- 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
- Experience on working on a Dynamics CRM Online Project. C# programming skills. Experience working on Agile projects. Experience working with CI/CD pipeline