Careerschool HR Solutions
Location
Chennai | India
Job description
Create and implement SQL Server stored procedures functions views and triggers for utilization in the ETL process .
Design and execute SSIS /SQL ETL solutions to gather and preprocess data from various upstream systems for QRM processing.
Construct data transformations in SSIS encompassing tasks like importing data from files and transferring data across different database platforms.
Debug and optimize SSIS and other ETL processes to guarantee precise and efficient data movement.
Develop and maintain database objects such as tables views and indexes ensuring database security.
Possess expertise in working with SSIS packages and demonstrate proficiency in ETL tools like Microsoft SSIS.
Formulate strategies and approaches for importing and transferring data between source staging and ODS/Data Warehouse destinations.
Test and ready ETL processes for deployment in both production and nonproduction environments.
Provide support for system and acceptance testing including the creation or refinement of test plans.
Implementing end to end data integration solutions.
Effectively building data transformations with SSIS including importing data from files as well as moving data between database platforms.
Following correct data standards and successfully solving data issues.
Data cleansing between systems.
Completing unit testing and system documentation for ETL processes.
ssis,etl,sql
Job tags
Salary
