12 Sep
|
HSBC
|
Hyderabad
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 effective 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 settings.
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.
📌 Ssis, Etl, Dynamics Crm, Kingswaysoft /senior Consultant Specialist Hyderabad
🏢 HSBC
📍 Hyderabad