Senior Specialist

Found in: beBee S IN - 4 weeks ago


Mahape, India LTIMindtree Full time

SPOC - Shravya Gone

Experience - 7 to 12 years

Location - Mumbai/Chennai/Pune/Bangalore/Hyderabad

Key skills - MSBI , SQL, SSIS

 

"SSIS developer provides development experience using Microsoft SSIS and SQL Server.

SSIS Developer Duties & Responsibilities

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 numerous upstream systems for processing by QRM

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

Experience working with SSIS packages

Proficient with ETL tools such as Microsoft SSIS

Analyze and develop strategies and approaches to import and transfer data between source, staging, and ODS/Data Warehouse destinations

Test and prepare ETL processes for deployment to production and non-production environments

Support system and acceptance testing including the development or refinement of test plans""""

"""