Lead Data Engineer
Current• Modern Data Stack Development: Built and maintained a modern data stack using Fivetran, Airflow (MWAA), Snowflake, DBT, and PowerBI. Implemented configuration-driven data ingestion, data quality, error logging, and data orchestration frameworks leveraging AWS services.• Data Ingestion and Pipeline Management: Designed, deployed, and maintained data ingestion frameworks for both streaming and batch data using Fivetran, AWS Lambda, DynamoDB, S3, and AWS Glue. Orchestrated data pipelines with Airflow and deployed them using Terraform, including an error logging framework to capture and alert the team about issues.• Custom Data Processing: Developed custom Python scripts to parse CSV and Excel data before ingestion into Snowflake, ensuring data integrity and quality.• Snowflake Administration and Optimization: Managed Snowflake as an admin, creating and granting roles using RBAC. Optimized cost and performance by creating dashboards to monitor costly warehouses, long-running queries, and idle times, and implemented guard rails to limit query durations.• Hackathons and Innovation: Participated in hackathons involving Amazon Bedrock/Chat-GPT for image recognition and web scraping data analysis, demonstrating adaptability and innovative problem-solving skills.