MSBI Architect - Data Analytics (10-15 yrs)

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