Summary
Overview
Work History
Education
Skills
Skills - Software Hardware
Timeline
Generic

Sridhar Beeravelly

Dallas

Summary

Over 12+ years of IT experience in database development, design, migration, and support, specializing in Microsoft SQL Server 2008 R2/2012/2016 and cloud-based solutions. Hands-on experience with SSIS, developing ETL processes for data extraction, transformation, and loading into Snowflake and other cloud-based platforms. Proficient in SSRS, designing interactive reports and dashboards to visualize Snowflake and Matillion data insights for business stakeholders. Experience with Power BI, integrating cloud data sources from Snowflake to develop dynamic dashboards and business intelligence solutions. Proficient in Snowflake Cloud DB, a highly scalable and easy-to-use cloud data platform with expertise in data warehousing and ELT processes. Extensive hands-on experience with Matillion Cloud ELT/ETL, configuring data pipelines for seamless integration with Snowflake and AWS S3. Expert in Snowflake’s multi-cluster shared data architecture, optimizing query performance through clustering and micro-partitioning strategies. Experience implementing Snowflake Time Travel and Cloning features, ensuring data recovery, auditability, and efficient replication for testing and development. Proficient in Snowflake Virtual Warehouses and Snowpipe, automating live data ingestion for streaming applications. Developed data pipelines using Matillion Cloud ELT/ETL, leveraging orchestration components to streamline complex dependency table loads. Skilled in cloud-based ETL workflows, loading structured and semi-structured data into Snowflake Cloud DB using Matillion, SnapLogic, and AWS CLI. Experience defining clustering keys in Snowflake, optimizing partition pruning for enhanced query efficiency and storage management. Expertise in designing Star schema and Snowflake schema, leveraging dimensional modeling techniques for enterprise data architecture. Strong collaboration skills, working with cross-functional teams to deliver cloud-based analytics solutions using Snowflake and Matillion. Hands-on experience with data extraction using SSIS and staging data warehouses for cloud migration projects. Knowledgeable in secure data transfer strategies, utilizing PEM files, public/private keys, and encryption techniques for AWS S3 to Snowflake migrations.

Overview

14
14
years of professional experience

Work History

SNOWFLAKE /MATILLION DATA ENGINEER

Pacific Life Insurance
07.2025 - Current
  • Hands-on experience developing and optimizing data pipelines in Snowflake Cloud DB using Snow SQL and Matillion Cloud ELT/ETL for efficient data processing.
  • Expertise in configuring Matillion Cloud ELT/ETL and integrating it with AWS S3 to automate data ingestion workflows.
  • Skilled in defining and managing environment variables within Matillion to streamline project deployments and file loads into Snowflake.
  • Extensive experience building Master Orchestration Packages in Matillion Cloud ELT/ETL for seamless data movement and automated job execution.
  • Proficient in AWS CLI/Bash Scripting operations, including file transfers, archival processes, and handling job failure notifications via AWS SNS/Matillion.
  • Strong understanding of logging and auditing frameworks within Matillion ETL and Snowflake, leveraging Bash scripting for enhanced data monitoring.
  • Experience designing dependency-aware orchestration workflows in Matillion for foreign key and circular dependency data loads.
  • Hands-on expertise in loading structured and semi-structured files from AWS S3 to Snowflake DB using SSIS and Matillion ELT/ETL tools.
  • Skilled in secure data transfers using PEM files, public and private keys, ensuring integrity while migrating data from AWS S3 to Snowflake.
  • Knowledgeable in Snowflake Virtual Warehouses, Snowpipe, and cross-platform data-sharing techniques for optimizing cloud-based analytics.
  • Experience building modular ELT jobs in Matillion Cloud ETL, utilizing environment-specific configurations at package and project levels.
  • Expertise in processing multi-delimiter flat files and CSVs, leveraging S3 Load Generator for efficient ingestion into Snowflake.
  • Well-versed in real-time data ingestion strategies, utilizing Snowpipe for streaming data loads into Snowflake.
  • Proficiency in Snowflake utilities, Snow SQL, and Big Data modeling, incorporating Python and Java-based transformations for scalable analytics solutions.
  • Expertise in Snowflake Clustering, implementing automatic and manual re-clustering strategies to optimize query performance and minimize storage costs.
  • Hands-on experience using Snowflake Time Travel, enabling historical data access for data recovery, auditing, and point-in-time analysis.
  • Implemented Snowflake Table Cloning, efficiently creating zero-copy clones for development, testing, and parallel processing while conserving storage.
  • Optimized Snowflake micro-partitioning strategies, leveraging clustering keys to improve data pruning and reduce query execution time.
  • Verify production code, support first three executions of code in production, Transition of the code and Process to the Maintenance/Support team.

SNOWFLAKE /MATILLION DATA ENGINEER

Conga Analytics
07.2024 - 06.2025
  • Company Overview: CO
  • Extensively worked on Snowflake Cloud DB, Snow SQL and Matillion Cloud ELT/ETL Cloud ETL Tool to load data.
  • Extensively worked on Migration data from Netezza to Snowflake.
  • Experience setting up Matillion Cloud ELT/ETL Cloud Configuration and Integrating with AWS S3 Bucket.
  • Skilled in Performing Optimization and tuning SQL and Snowflake Queries.
  • Extensively worked on creating Standard and Materialized views in snowflake.
  • Experience setting up Roles, Environments, Databases, Schemas in Snowflake.
  • Experience in using Snowflake Clone and Time Travel.
  • Extensively worked on loading, unloading data in snowflake, and designing tables, materialized views.
  • Scheduled jobs on daily/weekly/monthly basis using Matillion job scheduler. Scheduled data loads from multiple sources (Oracle/NZ) into snowflake using Matillion.
  • Working on all looping Iterators while loading data and expertise in using Extract nested component to flatten data from Json using Matillion.
  • Extensively worked on loading Files from AWS S3 to Snowflake DB using SSIS and using Matillion Cloud ELT/ETL Cloud ETL Tool.
  • Experience generating PEM files, public and Private keys to load data from AWS S3 to Snowflake DB.
  • Skilled in Performing Optimization and tuning SQL and Snowflake Queries.
  • Experience setting up Roles, Environments, Databases, Schemas in Snowflake.
  • Experience in using Snowflake Clone and Time Travel.
  • Extensively worked on loading, unloading data in snowflake and designing tables, materialized views.
  • Experience with Snowflake Virtual Warehouses, Snow pipe and data sharing in snowflake.
  • Expertise working on Matillion Cloud ELT/ETL Jobs, creating Environment Variables at Package level and Project level.
  • Experience working with S3 Load Generator to load files from AWS S3 to Snowflake, also worked on Loading Multi delimiter Flat files and CSV to load into Snowflake DB using Matillion Cloud ELT/ETL.
  • CO

SNOWFLAKE /MATILLION DATA ENGINEER

Delta Dental
09.2022 - 06.2024
  • Company Overview: Oakland, CA
  • Provider Analytical, Claims Analytical, Customer Analytical, Calabrio and Policies (Implement using Snowflake, Matillion, Kafka, AWS).
  • Extensively worked on Snowflake Cloud DB, Snow SQL and Matillion Cloud ELT/ETL Cloud ETL Tool to load data.
  • Experience setting up Matillion Cloud ELT/ETL Cloud Configuration and Integrating with AWS S3 Bucket.
  • Experience creating Public, Private and Shared variables in respective to projects and loading the Files into Snowflake using Matillion Cloud ELT/ETL.
  • Worked on creating Master packages using Orchestration components in Matillion Cloud ELT/ETL and deploying the Projects from Matillion Cloud ELT/ETL Dev Environment to QA and SIT.
  • Expertise in loading, moving, archiving files using AWS CLI and experience in sending messages through SNS in case of job failures.
  • Experience working with Bash script and performing all Logging and Auditing mechanisms using Matillion ETL and Snowflake.
  • Skilled in creating Master packages in Matillion Cloud ELT/ETL using Orchestration Component for Circular and FK dependency table loads using Matillion Cloud ELT/ETL.
  • Extensively worked on loading Files from AWS S3 to Snowflake DB using SSIS and using Matillion Cloud ELT/ETL Cloud ETL Tool.
  • Experience generating PEM files, public and Private keys to load data from AWS S3 to Snowflake DB.
  • Experience with Snowflake Virtual Warehouses, Snow pipe and data sharing in snowflake.
  • Expertise working on Matillion Cloud ELT/ETL Jobs, creating Environment Variables at Package level and Project level.
  • Experience working with S3 Load Generator to load files from AWS S3 to Snowflake, also worked on Loading Multi delimiter Flat files and CSV to load into Snowflake DB using Matillion Cloud ELT/ETL.
  • Experience using Snow pipe to automatically ingest Live streaming data.
  • Hands-on experience with Snowflake utilities, Snow SQL, Snow Pipe, Big Data model techniques using Python / Java.
  • Oakland, CA

SNOWFLAKE/MATILLION DATA ENGINEER

Waste Management (WM)
03.2021 - 08.2022
  • Company Overview: Houston, TX
  • Smart Truck, Residential and Commercial data (Implemented using Snowflake, Matillion, AWS).
  • Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
  • Created stored procedures, views, triggers, and constraints to implement database consistency and integrity.
  • Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval and performing Query Optimization.
  • Experience working with Bash script and performing all Logging and Auditing mechanisms using Matillion ETL and Snowflake.
  • Skilled in creating Master packages in Matillion Cloud ELT/ETL using Orchestration Component for Circular and FK dependency table loads using Matillion Cloud ELT/ETL.
  • Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source systems which include loading nested JSON formatted data into snowflake table.
  • Houston, TX

Sr. SQL BI/SNOWFLAKE/Matillion Lead/Dev

Grange Insurance
10.2019 - 03.2021
  • Company Overview: Columbus, OH
  • Core4(GWPC Implementation using Snowflake Cloud DB and Matillion Cloud ELT Tool).
  • Analyzing user requirements and defining functional specifications using Agile methodology.
  • Leading the Team (onsite and Offshore) in designing, development, and modifications of complex applications.
  • Created stored procedures, views, triggers and constrains to implement database consistency and integrity.
  • Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval and performing Query Optimization.
  • I worked extensively on Snowflake Cloud DB, Snow SQL and Matillion Cloud ETL Tool to load data.
  • Extensively worked on Migration data from Netezza to Snowflake using SSIS and Matillion.
  • Extensively worked on loading Files from AWS S3 to Snowflake DB using SSIS and using Matillion Cloud ETL Tool.
  • Experience Cloning Snowflake Database to Multi Environments.
  • Experience generating PEM files, public and Private keys to load data from AWS S3 to Snowflake DB.
  • Skilled in Performing Optimization and tuning SQL and Snowflake Queries.
  • Created SSIS package to extract, transform and load (ETL) data from different sources into destination target, like data warehouse, Flat file, Excel, OLE DB, using SQL Server Integration Services.
  • Skilled in performing data transfers between different heterogeneous systems (Excel, MS Access, Flat Files, XML file & Oracle) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks.
  • Expertise in creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS 2016/2012/2008 R2/2008.
  • Experience in data migration from various data sources like Excel, SQL Server, Oracle, XML files, Flat files using SSIS packages and SQL commands. Monitoring, debugging and tuning ETL jobs and workflows.
  • Experience in developing SSIS packages to transfer data from OLTP to OLAP Databases with different types of control flow tasks, data flow transformations and deploying the packages to Production server.
  • Identified the field and column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the ETL packages.
  • Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports.
  • Explore data in a variety of ways and across multiple visualizations using Power BI.
  • Used Power BI Gateways to keep the dashboards and reports up to date.
  • Columbus, OH

Sr. SQL BI/SNOWFLAKE Lead/Dev

BMO Harris Bank
04.2018 - 09.2019
  • Company Overview: Milwaukee, WI
  • Level1 database structure. We have been working closely with my development team in loading the data files to database tables. We designed the automation process of using one generic loader to load multi-structured files to their respective tables.
  • We have been leading the team working on 2052A Project. The 2052A project consumes data from multiple portfolios, like Credit Cards, Auto Loans, Mortgage, HELOC, Trades, Retail and Wholesale, across US. We process the data send to AXIOM.
  • Define scope and write project chart to communicate high level requirements and define, derive, and manage requirements for the project.
  • Expert in leading the Team Offshore (India) and On Site (USA and Canada) with a team strength of 20.
  • Created complex SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
  • Worked as Production Support for India and Canada teams, Performance tuning and monitoring SQL jobs.
  • Experience working as 24/7 prod support, coordinating with India offshore team and Canada.
  • Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
  • Worked with Automation of Cube deployment and Cube processing with SSIS ETL packages.
  • Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
  • Worked on loading data to Snowflake DB using SSIS and Snaplogic(Cloud ETL tool).
  • Experience in building Snowpipe and in-depth knowledge of Data Sharing in Snowflake.
  • In-depth knowledge of Snowflake Database, Schema and Table structures.
  • Experience in using Snowflake Clone and Time Travel.
  • Performed several AWS CLI operations for S3 bucket like Moving files, deleting files, providing list of Instances, copying directory etc.
  • Proficient in using AWS CLI commands for AWS S3 bucket.
  • Milwaukee, WI

Sr. SQL BI/ETL Dev

Perr & Knight
01.2017 - 03.2018
  • Company Overview: Fort Worth, TX
  • Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
  • Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check and Unique etc.). Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries.
  • Created SSIS Packages, Informatica Mappings to load data from Source to destination database and generate a text file and email the same to the users.
  • Implemented Event Handlers, Package Configurations, Logging, System and User-defined Variables, and Expressions for SSIS Packages.
  • Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS/ETL) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
  • Involved in maintaining the Error-Logging for the SSIS/ETL packages Involved in the design of transformation strategy from OLTP to OLAP Interfaces using SSIS and the new SCD Task.
  • Created various reports such as Drill-through, Drill-down, Sub Reports and Matrix Report.
  • Fort Worth, TX

Sr. SQL BI Dev

SV (Superior Vision)
01.2016 - 12.2016
  • Company Overview: Linthicum Heights, MD
  • Involved in optimization of queries, improving the performance by using various approaches from execution plans, Index optimization, and DMV’s.
  • Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
  • Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
  • Applied various SSIS data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, For Loop, For Each Loop, Sequence containers.
  • Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Identified and worked with Parameters for parameterized reports in SSRS 2008/2012.
  • Experience in Dimensional Data Modeling Star and Snowflake Schemas.
  • Linthicum Heights, MD

SQL BI Dev

Molina Health Care
02.2014 - 12.2015
  • Company Overview: Richmond, VA
  • Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data.
  • Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
  • Involved in maintaining the Error-Logging for the SSIS/ETL packages Involved in the design of transformation strategy from OLTP to OLAP Interfaces using SSIS and the new SCD Task.
  • Scheduled Jobs to call ETL/SSIS packages and Stored Procedures.
  • Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.
  • Richmond, VA

SQL SSIS/SSRS Dev

Microsoft
02.2011 - 12.2013
  • Company Overview: Issaquah, WA
  • Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
  • Responsible for defining Check constraints, business rules, tuning data, indexes for SQL Queries.
  • Designed ETL SSIS packages to process data to target databases.
  • Created SSIS/ETL packages for migration of data which handles the synchronization process between the databases.
  • Implemented incremental Load for many SSIS packages.
  • Issaquah, WA

Education

Master’s - information technology

UMHB
Belton, TX
01.2012

Bachelor’s - information technology

JNTU
Hyderabad
01.2009

Skills

  • Data pipeline development
  • Snowflake administration
  • Matillion configuration
  • AWS integration
  • SQL optimization
  • Data migration

Skills - Software Hardware

  • MS SQL Server 2008 R2/2012/2016
  • MS SQL Reporting Services 2008 R2/2012/2016
  • MS SQL Server Analysis Services 2012
  • MS SQL Server Integration Services 2012
  • Snowflake Cloud
  • Matillion
  • MS-Access 2010
  • HTML
  • Java script
  • Windows NT
  • Windows 2008 R2 Server
  • TFS
  • Windows XP/7
  • Unix
  • Shell script

Timeline

SNOWFLAKE /MATILLION DATA ENGINEER

Pacific Life Insurance
07.2025 - Current

SNOWFLAKE /MATILLION DATA ENGINEER

Conga Analytics
07.2024 - 06.2025

SNOWFLAKE /MATILLION DATA ENGINEER

Delta Dental
09.2022 - 06.2024

SNOWFLAKE/MATILLION DATA ENGINEER

Waste Management (WM)
03.2021 - 08.2022

Sr. SQL BI/SNOWFLAKE/Matillion Lead/Dev

Grange Insurance
10.2019 - 03.2021

Sr. SQL BI/SNOWFLAKE Lead/Dev

BMO Harris Bank
04.2018 - 09.2019

Sr. SQL BI/ETL Dev

Perr & Knight
01.2017 - 03.2018

Sr. SQL BI Dev

SV (Superior Vision)
01.2016 - 12.2016

SQL BI Dev

Molina Health Care
02.2014 - 12.2015

SQL SSIS/SSRS Dev

Microsoft
02.2011 - 12.2013

Master’s - information technology

UMHB

Bachelor’s - information technology

JNTU

Similar Profiles

CREATE PROFILE
Sridhar Beeravelly