Multiple - MS BI (SSIS/T-SQL) SQL Server (Only Joiners)

Only Immediate Joiners

2 Position SQL Tech Lead

5 position SQL Server Developer Strong (BI stack SSIS/SSRS/SSAS)

Location: Pune, MH

SQL Server Strong (BI stack SSIS)

Roles and Responsibilities:

1. 5+ years of hands on experience in Database design and SQL programming, preferably at least 5 years on Microsoft SQL Server designing databases for large enterprise custom applications ensuring high performance, data integrity and security.

2. Strong database design concepts, designing for application transaction performance and for optimal reporting performance for reports built in .Net as well as Power BI

3. BE(Comp)/MCS/MCA or equivalent degree in Computer Science

4.T-SQL: Working experience on writing Complex SQL queries

5. T-SQL: Working experience of Function/SPs/Trigger Cursor etc.

6. T-SQL: Working experience of identifying and writing indexes against query.

7. T-SQL: Experience in Performance Tuning

8. SSIS: Working Experience in developing complex SSIS packages, Configuration file, Variables, Parameters

9. SSIS: Working Experience in Error Handling, Logging, Error Notifications, Complex Data Flow Tasks. Deployment techniques

10. SSIS: Working experience in Transformations – LookUp, conditional Split, Data Conversion, Union, Merge, Pivot/UnPivot, Execute SQL

11. Hands on experience on SSAS would be added advantage