• Worked for Capital One Risk Department with data containing forecasted risk and reported loss data from over 20 sources for analysis of compliance and reporting. • Designed, enhanced, and troubleshooted ETL pipelines utilizing AWS services such as S3, Redshift, EMR, Lambda, Batch, QuickSight, and Cloudwatch.• Implemented compliance-driven enhancements to ensure data accuracy, optimized workflows, and provide scalable solutions.• Performed troubleshooting, risk assessments, and vulnerability remediation across multiple projects to maintain secure and reliable infrastructure.• Performed data analysis, optimization and ad-hoc querying of data stored in Amazon S3, Snowflake and Redshift using SQL.• Utilized PySpark, Databricks, and Snowflake for large-scale data transformation and analytics processes.• Created and maintained comprehensive documentation on technical specifications and user guides to assist the product team in source-to-target transformations.• Worked with stakeholders to understand data requirements to transform them into business solutions

GenC Next Data Engineer: AIA & AWS Domain - AWS, Databricks, Python, SQL, Abinitio