Direct Access to Expert Insights

Ask me anything

Ask away anything related to my expertise. I will try my best to help you out 🙂

Start a Priority DM - It's Free! Book a 1:1 Call
Srikanth Pinisetti profile

My Expertise

Snowflake Architect @ Squadron Data

I build scalable, secure, and analytics-ready data platforms using Snowflake.

Key Skills:

Snowflake RBAC Row Access Dynamic Masking Azure Entra ID Azure DevOps Fivetran CDC

Current Focus

End-to-end Snowflake implementation, data governance, and automation.

  • Snowflake-Centric Architecture
  • Data Governance
  • Automation

Key Areas of Work

Core Areas:

Data Migration Data Governance CI/CD Pipelines Cost Optimization Data Modeling Platform Monitoring Data Integrity

DevOps & Tooling:

Puppet Bash Python Cron

Background

Master's in Computer Science, specialization in Data Science – University of Missouri – Kansas City

Passionate about building cloud-native, data-driven solutions.

Legacy & Cloud Experience

Cloud Expertise – Snowflake Migration Projects

Current: Securus

  • Migrating justice system data into Snowflake using OpenFlow ETL pipelines.
  • Designing and supporting the Snowflake migration strategy across critical domains.
  • Assisting with the development of secure, governed pipelines using Snowflake-native features for compliance and scalability.
OpenFlow Snowflake ETL Pipelines Data Governance Migration Strategy

Previous: Imperial PFS (via Squadron Data)

  • Snowflake Data Migration & Integration with Power BI, Tableau, and REST APIs
  • RBAC implementation for access control
  • Azure Entra ID integration for SSO
  • CI/CD Pipelines with Azure DevOps
  • CDC implementation via Fivetran from SQL Server
  • Cost optimization dashboard in Snowflake
  • Data Governance with Row Access & Dynamic Masking
  • Monitoring & alerting implementation
Snowflake Power BI Tableau REST APIs RBAC Azure Entra ID CI/CD Azure DevOps Fivetran Cost Monitoring Data Masking

Legacy Hadoop Projects

Commerce Bank:

  • Cloudera Hadoop Admin (Data Engineering)
  • Built open-source Hadoop cluster (focus on HBase)
  • Migrated HBase data from RHEL 7 (CDH) to RHEL 9 (Open Source)
  • System Admin + Python Developer for automation using Bash, Python, and cron
Cloudera CDH HBase Open Source Hadoop Python Bash Automation Cron

Bank of Montreal:

  • Led data migration from HDP to CDP, ensuring compatibility with updated platform features.
  • Used PySpark and Hive queries to extract metadata and table structure, saving schema info to CSVs.
  • Performed distributed copy (DistCp) for moving data to the destination environment.
  • Reconstructed Hive schemas and tables on the CDP cluster before migrating the actual data.
  • Addressed ACID table compatibility issues by redesigning data models to external (non-transactional) tables where internal Hive ACID support was lacking.
HDP CDP PySpark Hive DistCp Schema Migration ACID Modeling

Why Ask Me Anything?

Direct Answers

Get straight to the point with personalized advice directly from an expert. No more searching through generic articles.

Save Time

Receive quick, actionable insights without the need for scheduling calls or long meetings. Efficiency is key.

Tailored Solutions

Your questions are unique. I provide responses specific to your situation and challenges, ensuring relevant guidance.

Let’s Con