Responsibilities :

● 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 non-production

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.

● Data cleansing between systems.

● Completing unit testing and system documentation for ETL processes.

Great to have:

COZYROC SSIS+ for fast and easy ETL

Educational background :

● UG:Any Graduate – Engineering, Computer Science, or any degree which enforces an analytical mindset

● PG:Any Postgraduate – Any Specialization