Skip to main content
Ajay RainaAR
Looking for a job

Ajay Raina

@ajayraina

Enterprise Data Architect | Microsoft Fabric & Cloud Modernization | 16+ Yrs Enterprise Warehousing & Data Governance | Medallion & Direct Lake Expert

India
Message

What I'm looking for

I'm seeking a Microsoft Fabric Architect role where I can design governed data platforms, semantic models, and enterprise-scale data solutions while leading and mentoring technical teams.

With over 16 years of experience driving enterprise data strategy, cloud modernizations, and platform governance, I specialize in transforming fragmented database landscapes into high-performance, secure, and AI-ready SaaS analytics ecosystems. My career bridges the gap between traditional enterprise data warehousing and cutting-edge cloud architectures—most recently focusing on building scalable frameworks within the Microsoft Fabric ecosystem.

As a Technical Manager and Solution Architect, I don't just engineer data movement; I design comprehensive blueprints that balance high-speed computation with financial guardrails and strict security compliance. I have a proven track record of guiding global enterprise clients through the architectural shifts required to transition legacy SQL Server, Oracle, and SSIS environments into modern, cloud-native structures.

Core Architectural Specializations:

• Microsoft Fabric Platform Design: Designing unified enterprise SaaS data estates using OneLake architecture, Medallion storage footprints, and PySpark notebooks.

• Performance Optimization: Engineering high-throughput Direct Lake semantic models utilizing V-Order byte alignment to stream multi-million row datasets instantly into memory, eliminating import latency.

• Capacity Management (Cost Control): Managing enterprise F-SKUs, optimizing compute distribution, and leveraging native smoothing and throttling patterns to prevent infrastructure bottlenecks while protecting operational budgets.

• Enterprise Governance & Security: Architecting highly automated, self-service Dynamic Data Masking (DDM) frameworks across multi-database environments (Snowflake, Oracle, SQL Server) and integrating Microsoft Purview for end-to-end data lineage tracking.

• Technical Leadership: Heading and mentoring cross-functional engineering teams, defining source-to-target mapping (STTM) schemas, and managing business stakeholder communication.

I am passionate about helping enterprise organizations unlock the true value of their data at scale without sacrificing security or inflating operational overhead.

Let’s connect to discuss modern cloud data design patterns, data mesh strategies, or enterprise Microsoft Fabric modernizations.

Experience

Work history, roles, and key accomplishments

Globant India logoGI

Senior Managing Consultant

Jan 2023 - Mar 2026 (3 years 2 months)

Led a team of 4 across SQL Server, Oracle and Power BI, and owned source-to-target data flow design for 100+ tables across the RDARR, IFRS and Wealth lines of business, engaging directly with source teams. Authored STTM documentation and identified data gaps ahead of ingestion into the centralized database, preventing downstream rework.

Globant India logoGI

Managing Consultant

Aug 2021 - Dec 2022 (1 year 4 months)

Led a team of 8 to design a self-service masking framework: DBAs supply the object list and the framework applies masking automatically across SQL Server, Oracle and Snowflake, covering 10+ databases. Designed an automated detection process that flags any sensitive data left unmasked, giving compliance teams continuous assurance.

Zensar Technologies logoZT

Technical Specialist

Jan 2019 - Aug 2021 (2 years 7 months)

Led data mapping and modeling for Guidewire policy-center-to-data-hub migrations, enabling downstream data science consumption. Transition lead for the annual SA tax reporting system; documented functional and technical scope and designed the upgrade path from SQL Server 2008 to 2016. Designed an ETL framework and data mart for global e-medicine tracking, built for Power BI reporting and restartab

Synechron Technologies logoST

Technical Lead

Sep 2015 - Jan 2019 (3 years 4 months)

Analyzed and maintained ETL processes (PETL, SSIS) feeding the enterprise data warehouse for a leading mobile-insurance provider; designed new data models, resolved client-reported data issues and mentored the technical team.

Concentrix logoCO

Assistant Manager

Oct 2014 - Sep 2015 (11 months)

Built SSRS reporting on high-volume customer-care data and monitored supporting SQL jobs.

Cybage Software logoCS

Software Engineer

Jan 2013 - Sep 2014 (1 year 8 months)

Built SSIS packages and SSRS reports and provided production support through stabilization.

Tech Mahindra logoTM

Technical Associate

Apr 2010 - Dec 2012 (2 years 8 months)

Developed OSS modules and GUI forms and migrated legacy code from VB6 to T-SQL.

Education

Degrees, certifications, and relevant coursework

University of Jammu logoUJ

University of Jammu

Master of Computer Applications, Computer Science

2006 - 2009

Grade: First Class

Master of Computer Applications in Computer Science from the University of Jammu, completed with First Class.

University of Jammu logoUJ

University of Jammu

Bachelor of Science, Electronics

2003 - 2006

Bachelor of Science in Electronics from the University of Jammu.

Get matched with your dream remote job

Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan