Manisha Sankalamaddi
Snowflake SnowPro Core Certified Data & AI Engineer with 4+ years of experience building enterprise data platforms and AI-enabled analytics on Snowflake — Cortex Agents, Semantic Views, and natural language analytics — backed by a strong foundation in SQL, dbt, medallion architecture, and large-scale migration.
Projects
Taxi HDFS to Snowflake Pipeline
Built an end-to-end NYC Taxi data pipeline using HDFS, PySpark, Snowflake, S3, and Streamlit. Ingested raw trip data, transformed it into analytics-ready datasets, loaded reference data from S3, and created reporting views.
AWS S3 to Snowflake Products Pipeline
AWS S3 to Snowflake data pipeline for product data ingestion, transformation, and task-based automation using storage integrations, external stages, raw staging tables, curated analytics tables, and scheduled refresh tasks.
GitHub Events Snowflake Pipeline
A free-access GitHub Events to Snowflake pipeline built with Python and Snowflake. Fetches GitHub event data through authenticated REST API calls, lands data as NDJSON, loads into RAW tables, and transforms into CURATED tables.
Streamlit Cortex Dashboard
Interactive Streamlit sales analytics dashboard built with Python and Snowflake, enhanced using Cortex Code CLI for prompt-driven code updates, UI improvements, and development acceleration.
Technical Skills
Snowflake & Cortex AI
Snowflake Cortex, Cortex Agents, Cortex Analyst, Cortex Search, Cortex Code CLI, Semantic Views, Natural Language Analytics, Streamlit in Snowflake, Snowflake SQL, Stored Procedures, Streams, Tasks, Dynamic Tables, Interactive Tables, Interactive Warehouses, Zero-Copy Cloning
Data Engineering & Warehousing
ETL/ELT, dbt, Fivetran, Data Migration, Data Transformation, Data Modeling, Dimensional & Semantic Modeling, Star Schema, Medallion Architecture, Data Validation, Data Reconciliation, Data Quality
Microsoft Stack, Cloud & Big Data
SQL Server, T-SQL, SSMS, SSIS Packages, Microsoft Azure, AWS S3, AWS Glue, Amazon Redshift, Amazon Athena, GCP BigQuery, Hadoop, HDFS, Apache Spark, PySpark, Spark SQL
Performance, BI & DevOps
Query Profile Analysis, Performance Tuning, Warehouse Optimization, RBAC, Row Access Policies, Dynamic Data Masking, SQL, Python, Pandas, NumPy, Power BI, Tableau, Azure DevOps, Agile, Git, Pull Requests, CI/CD, Docker, Kubernetes
Professional Experience
Snowflake Data Engineer (Consultant) — Squadron Data Inc.
- Migrating enterprise data warehouse workloads from on-premises SQL Server to Snowflake, using Fivetran connectors to automate incremental source ingestion into RAW schemas
- Rebuilding legacy stored procedure and SSIS transformation logic as version-controlled dbt models across medallion layers, validated with parallel SSMS and Snowflake reconciliation queries
- Delivering SOX-controlled audit reporting datasets and managing work in Azure DevOps through user stories, Git branches, pull requests, peer code review, and change-request approvals
- Designing and deploying Cortex Agents on Snowflake's managed agentic platform, configuring the tools each agent calls — Cortex Analyst over semantic views for structured metrics, Cortex Search for unstructured content
- Building Snowflake Semantic Views — logical tables, business metrics, dimensions, and synonyms — that power natural language analytics through Cortex Analyst
- Scoping agent data access through role privileges and each tool's execution context so conversational answers respect the same row- and column-level controls as direct queries
- Optimizing Snowflake query performance by profiling compilation and execution time separately, flattening nested view chains, and applying join restructuring and pruning-friendly clustering keys
- Implementing Dynamic Tables with declarative target lag to keep curated datasets incrementally refreshed with less custom scheduling
- Designing RBAC role hierarchies, row access policies, and dynamic data masking, and introducing Interactive Tables served by dedicated Interactive Warehouses for sub-second, high-concurrency dashboard queries
Data & Analytics Engineer – Snowflake Developer — Integrated Proteins
- Built Snowflake Semantic Views over curated sales and operations data and enabled natural language analytics through Cortex Analyst, letting business users ask questions in plain English and receive governed SQL answers
- Developed an interactive Streamlit data application in Snowflake delivering AI-assisted sales analytics, built and iterated using Cortex Code CLI for prompt-driven development
- Established validation routines for analytics and AI-generated outputs — source-to-target reconciliation, aggregate checks, and business-rule verification
- Designed and developed Snowflake ELT pipelines migrating operational data from source systems into external stages, staging tables, and curated warehouse layers
- Built advanced Snowflake SQL stored procedures and incremental load workflows using Streams and Tasks on CRON schedules
- Created reporting-ready Snowflake views powering Power BI dashboards, and used Zero-Copy Cloning for testing and environment replication
Data Analyst — Sodexo
- Built and maintained AWS-based data migration and ETL workflows using Amazon S3, AWS Glue, Amazon Redshift, and Athena
- Developed Glue jobs and crawlers to catalog raw S3 data, applying partitioning strategies that reduced scanned volume and improved Athena query performance and cost
- Designed dimensional models and curated reporting tables in Redshift with appropriate sort and distribution keys, improving KPI consistency and query efficiency
- Wrote advanced SQL in Redshift and Athena for transformation, reconciliation, validation, and trend analysis, and used Python (Pandas, NumPy) to automate recurring data preparation
- Supported incremental and scheduled refresh workflows ensuring timely movement of updated data into analytics-ready structures
- Applied data quality controls including source-to-target validation, reconciliation, and deduplication, supporting Power BI reporting on curated AWS-backed datasets
Data Engineer — RSoft Systems & Services Pvt. Ltd.
- Engineered ingestion workflows collecting data from databases, flat files, APIs, and enterprise source systems into Hadoop/HDFS for centralized storage and distributed processing
- Built PySpark and Spark SQL transformations to cleanse, standardize, validate, and reshape raw HDFS data into structured, analytics-ready datasets
- Developed logic for complex joins, aggregations, window functions, reconciliation, and deduplication, tuning Spark jobs through partitioning, caching, and broadcast joins
- Processed historical backfills and recurring incremental loads into curated reporting layers without reprocessing full datasets
- Developed ETL jobs and Python automation to land source data into raw layers with logging and validation checks for pipeline reliability
- Integrated Hadoop/Spark outputs with AWS including Amazon S3, and delivered curated datasets for Power BI and Tableau reporting
Education & Certifications
Master of Science, Computer Science — University of Missouri–Kansas City
Certifications
- Snowflake SnowPro Core Certified (Credential ID: 179071720)
- Microsoft Certified: Power BI Data Analyst Associate (PL-300)