Data Engineer
Current- Participated in collaborative business analysis and technical design sessions involving both business and technical teams to craft comprehensive requirements documents and ETL specifications. Worked closely with.
- Developed intricate SQL Stored Procedures to enhance the validation process and facilitate the seamless transfer of data from staging areas to production tables. Conducted in-depth SQL Index analysis for tables.
- Created advanced SQL queries and stored procedures to support web applications and generate data reports. Customized and optimized existing SQL stored procedures in alignment with technical specifications and executed.
- Leveraged Azure DevOps, Terraforms, and GIT Hub for version control and streamlined code deployment to subsequent environments. Operated within an Agile environment, delivering daily status updates to supervisors.
- Demonstrated expertise in relational and multidimensional data modeling, particularly in the transportation industry, with a strong command of concepts such as Star/Snowflake Schema, Fact, and Dimension