BI Engineer – SSIS

Job Summary:
The experienced ETL Developer is a member of the project team who takes responsibility for implementing parts of the system architecture using best practices in an agile development environment. 
This will include   coding,   unit   testing,   using   design   patterns,   learning   new technologies, and becoming an expert in one part of the system.

Primary Responsibilities:
Responsible for design, development, and implementation of solutions to exchange data using the required ETL tool, SSIS. 
Exposure to ADF and implementation of Azure is nice to have.
Demonstrated experience working with Microsoft SSIS to create and deploy packages and deploy for ETL processes.
Demonstrated experience with Microsoft SSRS for creating and publishing reports.
Strong verbal and written communication and shall be able to work directly with client and business to understand the domain/requirements. 
SSRS report development
Strong in DWH concepts and good understanding of modern analytics tools and processes.
Strong in SQL/ TSQL/PL/SQL, writing effective SQL codes and stored procedures.
Experience in DBMS like SQL Server and knowledge of know-hows of the same and troubleshooting experience. 
Develop new code and/or support operations, maintenance, and enhancements/performance tuning of existing code.
Conduct multiple levels of testing including unit, system, integration and performance
Estimate and plan releases.
Understand the best practices and coding standards.