SQL Server, T-SQL, Power BI, SSIS, SSAS, SSRS, SDLC, Agile
Full Time
Preferred Qualifications:
• At least 1.5 years of experience in DW/BI/Reporting and related technologies and tools
• At least 1.5 years of hands on development experience in SSAS, SSRS, SQL, Power BI
• At least 1 end to end implementation experience required.
• Hands on experience in MS SQL to write complex, highly-optimized queries across large volumes of data, database design, data warehouse design, query performance tuning and writing stored procedures
• Knowledge and experience with full SDLC lifecycle
• Experience in working in Agile teams, and working independently with Business stakeholders providing solutions and regular updates
• Knowledge of data models, ETL and data warehouse processes
• At least 1 years of experience in SSAS module in designing and building DW, tabular, multidimensional cubes
• At least one-year experience with Power BI to create reports, visualizations, and interactive dashboards
• Experience in creating T-SQL Packages, Procedures, Functions, Triggers, Views and Exception handling for retrieving, manipulating, checking, and migrating complex data sets will be useful
• Exposure to Azure SQL, ADL, ADF, Azure analysis services is preferred