Looking for a job

Sarath Medarametla

@sarathmedarametla

Azure Data Engineer at Western Alliance Bank building Medallion data pipelines and ThoughtSpot Liveboards with governed access.

United States

Message

At Western Alliance Bank, I design Azure data pipelines with ADF, Synapse, and ADLS Gen2, and build transformations in Synapse and Databricks. I implemented a Bronze/Silver/Gold Medallion architecture with data quality checks and governed reporting access.

I also develop ThoughtSpot Liveboards and Worksheets, connecting SQL Server and Oracle sources and implementing row-level security. Across earlier roles, I delivered SQL Server BI and ETL solutions, ThoughtSpot analytics, and data migrations, including work with SSIS, SSRS, and Snowflake.

Experience

Work history, roles, and key accomplishments

Current

Azure Data Engineer & ThoughtSpot Developer

Current

Western Alliance Bank

Jan 2025 - Present (1 year 9 months)

Designed and delivered end-to-end data pipelines on Azure using ADF, Synapse, and ADLS Gen2. Implemented Medallion architecture with data quality checks and developed ThoughtSpot Liveboards and Worksheets with RLS.

Azure Data Factory Azure Synapse ADLS Gen2 Azure Key Vault azure monitor SparkSQL PySpark ThoughtSpot Row level security Data Quality Data Lineage Self Hosted Integration Runtime Azure SQL Database Azure Databricks

MSBI Developer / ThoughtSpot Developer

Intra Cellular Therapies

Jan 2024 - Dec 2024 (11 months)

Built and maintained ADF-based ELT pipelines into ADLS Gen2 and Synapse, implementing Medallion layering. Developed ThoughtSpot and Power BI dashboards and implemented RLS and governance controls.

Azure Data Factory ADLS Gen2 Azure Synapse ThoughtSpot Power BI SQL Oracle Redshift Snowflake Row level security SpotIQ SAGE Data Validation Data Modeling

Sr. Data Engineer / ThoughtSpot Developer

Walmart Labs

Apr 2023 - Jan 2024 (9 months)

Developed ADF pipelines and triggers to ingest data into Azure SQL Server. Built ThoughtSpot dashboards and reports, implemented RLS, and supported production operations.

Azure Data Factory Azure SQL Server ThoughtSpot Dataflow Denodo SQL Server Oracle Vertica Data Modeling Row level security Monitoring Debugging

Sr. Data Engineer / ThoughtSpot Developer

Albertsons

Jun 2022 - Apr 2023 (10 months)

Developed SSRS reports and SSIS packages for finance reporting and operational analytics. Built ThoughtSpot dashboards, implemented RLS, and configured Splunk alerts for data load failures.

SSRS SSIS SQL Server Teradata ThoughtSpot Row level security Splunk Data Integration ETL Error Handling

Sr. SQL BI Developer / ThoughtSpot Developer

Walmart Labs

Nov 2018 - Jun 2022 (3 years 7 months)

Developed SSIS packages for data loading and transformation, authored HiveQL and Spark SQL, and delivered ThoughtSpot analytics. Supported migration to GCP and built Looker dashboards.

SSIS Hive Spark SQL ThoughtSpot Looker SQL Server Agent Performance Optimization SQL Server Profiler Database Engine Tuning Advisor Sybase GCP Data Migration

Sr. SQL BI Developer

Capital One Auto Finance

May 2018 - Nov 2018 (6 months)

Supported Teradata-to-Snowflake migration, including feasibility analysis and conversion of SQL/ELT jobs. Managed historical and incremental loads and performed validation and performance optimization.

Teradata Snowflake SQL ELT Data Validation Performance Optimization Index Rebuilding Query Optimization

Sr. SQL BI Developer (SSIS/SSRS/SSAS)

Pacific Pulmonary Services Corp

Apr 2016 - Apr 2018 (2 years)

Designed summary tables and reporting standards, developed SSIS packages for heterogeneous sources, built SSAS cubes, and created SSRS reports with drilldown and subscriptions.