Involved in requirements gathering on data subjects and analysis of the source data before designing. Served as DBA for Teradata to Snowflake migration using hybrid lift-and-shift and staged migration. Designed dimensional model, data lake architecture, and data vault 2.0 on Snowflake. Led end-to-end data migration from Hadoop to Snowflake, optimized migration workflows, collaborated with cross-functional teams to minimize downtime. Expertise with MDM, dimensional modeling, data architecture, data lake & data governance. Built Hadoop data lakes/delta lake architectures and ingested legacy datasets into HDFS via Sqoop, loading tables into partitioned Hive tables. Implemented AWS data lake leveraging S3, Terraform, EC2, Lambda, and IAM; wrote complex SQL on Snowflake. Built near real-time visualizations in Tableau. Implemented streaming and CDC patterns using Spark Streaming and Kafka; integrated with Cassandra. Created and managed data pipelines from S3 to Redshift. Prepared ETL framewo

Sr. Data Engineer at Wells Fargo

April 1, 2021 - July 31, 2024

Designed and developed architecture for data services spanning relational, NoSQL, and big data technologies. Extracted data from Redshift, AWS, and Elastic Search; generated business reports from Data Lake using Hadoop SQL (Impala) and automated reports via UNIX Bash scripts. Managed Hadoop-based jobs (Sqoop, Pig, Hive, MapReduce, Spark) feeding Data Lake (S3) and business user access. Developed custom SQL queries to load and transform data within Snowflake; implemented data ingestion via Spark wrappers. Ensured data security and access controls in Snowflake; monitored production jobs and optimized performance. Contributed to Catalog as Code and Runway configurations; created DDL to copy data from Hadoop to Snowflake; integrated data from Teradata, Hadoop, and Greenplum into Snowflake. Built conceptual/logical/physical models for OLTP/OLAP, including Star/Snowflake schemas and data vault constructs.

Data Engineer/Analyst at Elements Talent Consultancy

July 1, 2017 - March 31, 2020

Designed system interfaces and data models using ERwin; delivered PDM, DDL scripts, and STTM documents. Implemented data governance practices and lifecycle management. Worked on data transfer architectures from OLTP to OLAP with ETL/MDM tools; built data warehouse components, including star and snowflake schemas. Migrated ETL jobs from Hadoop to Pig scripts; deployed and managed data pipelines in Hadoop ecosystems; leveraged Tableau for dashboards; performed data extraction, transformation, and loading using Sqoop to HDFS and Hive, and utilized Rest APIs to access HBase analytics.

Data Analyst at TritonExec

September 1, 2014 - June 30, 2016

Architected system interfaces and data models using ER Studio; developed ETL mappings using PowerCenter; supported BI reporting using Tableau. Created metadata repositories and ensured data governance. Performed back-end testing with SQL/PL/SQL; designed data marts and data warehouse structures; built reports and dashboards.