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