Ayush Nigam

Director of Engineering

Bangalore Urban, Karnataka, India11 yrs 7 mos experience

Most Likely To SwitchHighly Stable

Key Highlights

Over 12 years of IT experience in Data Warehousing.
Expert in ETL processes and data modeling techniques.
Proven track record in leading cross-functional agile teams.

Stackforce AI infers this person is a Data Engineering expert in Fintech and Insurance sectors.

Contact

Skills

Core Skills

Data WarehousingEtlData Modeling

Other Skills

ASP.NETAirflowAzure Data FactoryAzure DatabricksBig DataBusiness Intelligence (BI)CC#CSSCore JavaCustomer ServiceDB2Data AnalysisData governanceData virtualization

About

• 12+ years in Information Technology with Expertise in Data Warehouse/Data Mart development, Data Modeling, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications. • Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment,documentation, production support and extensive experience in Project Management methodologies. • Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments. • Collaborated with business and technical stakeholders to come up with long-term data strategy aligned with business objectives, including data acquisition, storage, processing, and analysis. • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables in both on premises and cloud architecture set up. • Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Azure Databricks , ADF and Informatica. • Skilled in leading cross-functional agile teams, facilitating sprint ceremonies, managing backlogs, and ensuring timely, high-quality deliverables.

Experience

11 yrs 7 mos

Total Experience

3 yrs 10 mos

Average Tenure

4 yrs 4 mos

Current Experience

Morgan stanley

Director - Lead Data Engineer

Dec 2021 – Present · 4 yrs 4 mos · Bengaluru, Karnataka, India · Hybrid

Led the design and implementation of a centralized Snowflake data warehouse with integrated Azure
Databricks processing, consolidating trade, market, and client datasets from 10+ sources for unified
investment analytics.
Developed automated ETL/ELT pipelines using Python, SQL, Unix/Linux shell scripting, and Airflow to
process large volumes of portfolio, risk, and transaction data with <2% error rate.
Created dimensional data models (Star & Snowflake schema) optimized for financial performance analytics and regulatory reporting.
Integrated market data feeds (Bloomberg, MSCI) into Snowflake for near real-time analytics.
Leveraged data virtualization (TDV) to provide real-time, federated access to heterogeneous data sources without data duplication, improving analyst productivity by 40%.
Achieved 50% faster time-to-insight by replacing manual processes with automated reporting and scheduled data refreshes.
Implemented data governance frameworks using Collibra ensuring 99.9% data quality compliance.
Served as Scrum Master for the agile squad, facilitating sprint planning, backlog grooming, and daily
stand-ups, ensuring timely delivery of project milestones and fostering collaboration between data engineers, analysts, and business stakeholders.

SnowflakeAzure DatabricksPythonSQLUnix/Linux shell scriptingAirflow+4

Capgemini

Senior Consultant - Lead Data Modeler & Developer

Sep 2018 – Dec 2021 · 3 yrs 3 mos · Pune/Pimpri-Chinchwad Area · Hybrid

Studied in-house requirements for the Data warehouse to be developed & conducted one-on-one sessions with business users to gather data warehouse requirements.
Analyzed database requirements in detail with the project stakeholders by conducting Joint Requirements Development sessions.
Developed Conceptual models using Erwin based on requirements analysis. Developed normalized Logical and Physical database models to design OLTP system for insurance applications.
Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin.
Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model.
Created important documents like STTM file, Data dictionaries primarily for Data Governance, Data
Visualization, Data Lineage and Data Quality purposes.
Created end-to end Data Quality & ETL pipelines using Informatica Power Center, Azure Data Factory
(ADF) and Azure Databricks.

ErwinInformatica Power CenterAzure Data FactoryAzure DatabricksData ModelingETL

Tata consultancy services

IT Analyst - ETL Lead

Aug 2014 – Aug 2018 · 4 yrs · Pune/Pimpri-Chinchwad Area · On-site

Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center.
Worked on various sourcing platforms i.e. Oracle, Teradata, DB2, Greenplum & SQL Server to design &
create SQLs.
Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
Worked with several facets of the Informatica PowerCenter tool - Source Analyzer, Data Warehousing
Designer, Mapping & Mapplet Designer and Transformation Designer. Responsible for Performance
Tuning at the Mapping Level, Session Level, Source Level and the Target Level for Slowly Changing
Dimensions Type1, Type2 for Data Loads.