Business Intelligence Specialist

1. SQL Server - SQL, T-SQL and SSIS. 2. Good experience in writing optimized queries in SQL. 3. Good experience developing stored procedures, views and functions using Microsoft SQL Server. 4. Experience with relational datasets, data warehouses and ETL techniques. 5. Experience in database administration skills like indexing, tuning, optimization etc. 6. Ability to write efficient, complex queries against very large data sets. 7. Experience in Requirements gathering, development and deployment of SSIS 8. Expert in data validation, cleansing, analysis and Transforming 9. Experience in using SSIS Transformations like Lookup, Merge, Union ALL, Multicast 10. Experience in SSIS Error and Event Handling - Precedence Constraints, Check Points and Logging 11. Experience in Azure and Databricks with Pyspark (atleast knowledge/certification) is preffered