Eric Mencarini Email & Phone Number

⇾5 years of experience in the Data field, with expertise in Optimized queries on DWs such as Redshift using SQL, utilized Python for extracting data from REST APIs, and manipulated dataframes with Pandas to ensure data quality and integrity. Developed cloud-based pipelines (AWS/Azure).⇾Developed projects using Databricks, employing SQL and Pyspark for ingestion into the Delta Lake, creating a data catalog, and designing the entire medallion architecture.⇾Participated in projects aimed at automating manual processes to reduce costs and operational time, planning and designing the entire architecture, and implementing pipelines on AWS. Created Python scripts and used services such as Lambda, S3, Glue, Aurora, Step Functions, and on Azure with Data Factory, Data Lake Gen 2, Azure Databricks, Azure Synapse Analytics, and Databricks, where we reduced time spent on certain tasks by up to 90%.⇾Skills:SQL, Python, REST API, ETL/ELT, Azure, Databricks, Pyspark, Spark, AWS, Redshift, Medallion Architecture, Data Modeling, Oracle, MySQL, SQL Server, PowerCenter, Data Lake, Data Warehouses, Data Marts, Big Data, Jira, Agile Methodologies.⇾Certifications:PL-300 - Power BI Data Analyst Associate⇾Upcoming Certifications:DP-900: Microsoft Azure Data Fundamentals - 01/10/2024 (estimated)DP-203: Microsoft Certified Azure Data Engineer Associate - 01/12/2024