Role & Responsibilities • To analyze the user requirements (new / change requests) and develop solutions for ETL implementation. • To follow the Microsoft framework • To understand the existing data source setup and plan for ETL using SSIS and SQL server. • Implementing and maintaining ETL process in platform recommended by client using SSIS • Monitoring performance of the ETL jobs in Platform and provide recommendations (where necessary) • To perform batch and real time production support • SSIS experience ingesting and doing complex transformations. Requirements • Experience in ETL by analyzing source data and providing transformation logic • Experience in SSIS for ETL implementation • Experience in DBs like SQL server • Experience in writing scripts for transformation if required • Experience in suggesting tools for client’s new requirement • Provide support for production runs and improve performance if required