MS Fabric Architect

Job Description – MS Fabric Architect

Location : Chennai (Onsite)

Experience : 8 – 10 Years

Joining : Immediate

Role Overview

We are seeking an experienced Architect – MS Fabric to design and implement enterprise-level data warehouse and BI solutions. The role involves data modelling, ETL development, cloud integration, and working closely with stakeholders to deliver scalable and efficient solutions for Prudential Financial, Inc.

Key Responsibilities

Design and build Data Warehouse structures (databases, SSAS cubes).

Develop scalable data architecture, data modelling, and ETL mapping solutions.

Support the complete data warehousing and BI lifecycle – design, development, validation, and maintenance.

Manage and support data warehouse technical ecosystems, including SharePoint-based reporting solutions.

Document business, functional, and technical requirements.

Lead cross-functional teams in delivering innovative client solutions.

Present technical solutions to senior executives and stakeholders in a clear and concise manner.

Ensure data quality, security, and metadata management in reporting environments.

Troubleshoot reporting databases and resolve performance issues.

Generate reports from single or multiple systems, ensuring data accuracy.

Commissioning / decommissioning datasets and managing reporting environments.

Requirements

10+ years of experience as a Data Warehouse Architect and ETL Developer.

Minimum 3 years of Data Modelling experience (3NF, Star Schema, Dimensional Modelling).

Proficiency in T-SQL development with strong query optimization (MS SQL Server preferred).

Expertise in SQL Server Analysis Services (SSAS) including Tabular Modelling.

Strong hands-on experience with BI Reporting Tools.

5+ years of data analysis and profiling experience using SQL and related tools.

Exposure to Big Data and Advanced Analytics.

Experience analyzing existing tools / databases and recommending solutions.

Knowledge of cloud data warehouse platforms (Azure preferred).

MS Fabric knowledge / certification highly desirable.

Excellent communication skills – written, verbal, and presentation.

Thanks & Regards ,

Somesh Singh

TCS AI. Cloud Recruiter

Talent Acquisition Group

Website : :

http : / / www.tcs.com

E-Mail : - somesh.singh7@tcs.com

LinkedIn : - linkdin.com / in / mrsomeshsingh

To Register for Jobs, Visit :

https : / / ibegin.tcs.com / iBegin / register

Address : - Tower-2, Okaya Centre Plot No. B-5,Sector - 62 Noida.