MSBI Architect - Data Analytics

Job Title : MSBI Architect Job Location : Hyderabad Exp : 10 Years Job Mode : WFO Notice : Immediate Job Summary & Responsibilities : - 10 years of Overall experience - Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Package - Develop complex SQL scripts, Stored Procedures, Triggers, Functions, and Views. - Development experience with MS SQL Server, SQL Server Reporting Services and SQL Server Integration Services (SSIS) - Migrating data from various data formats into SQL Server databases using automated import processes (DTS and SSIS packages, etc.). - Develop, imports to and extracts from existing SQL databases - Able to implement row level security on data and understand application security layer models in Power BI. - Experience using Microsoft Technologies (SQL Server 2008/2008 R2/2012/2016, Visual Studio 2008/2010/2012/2015) - Data Exploration and ETL : Microsoft BI, Alteryx, Talend Data Integration, Informatica PowerCenter, IBM Infosphere Data Stage etc. - Able to properly understand the business requirements and develop data models accordingly by taking care of the resources. - Data Warehouse Solutions : Redshift, Snowflake, Postgres - Azure knowledge is essential - Strong problem-solving skills and able to handle PROD issues effectively. - Good verbal and written communication (ref:hirist.tech)

Location: hyderabad, IN

Posted Date: 11/21/2024