Marcelo Alexandre Stefani
Verified Expert in Engineering
Data Warehouse Developer
São Paulo - State of São Paulo, Brazil
Toptal member since May 17, 2021
Marcelo has been working on developing data warehouse and ETL pipeline projects for the last ten years. He's always eager to learn and try new technologies and strategies to improve his skills and projects. He thoroughly understands the requirements for data warehouse projects and tries to provide the best infrastructures to allow his clients to grow and scale in a safe and fast way.
Portfolio
Experience
- Data Engineering - 14 years
- Databases - 10 years
- SQL - 10 years
- SQL Server BI - 9 years
- Snowflake - 5 years
- Amazon Web Services (AWS) - 5 years
- Python - 4 years
- Microsoft Power BI - 3 years
Availability
Preferred Environment
Visual Studio Code (VS Code), DataGrip, Windows, Git
The most amazing...
...thing I've developed is a simulator that emulated the weight loss (due to water loss) in the meat production chain.
Work Experience
Senior Data Engineer
Home Shopping Europe
- Performed a data warehouse migration from on-premise Oracle to Snowflake.
- Migrated Informatica and Talend ETL to Python on AWS.
- Implemented infrastructure as code for cloud objects and automated deployments.
- Tracked and fixed bugs using Jira as a reporting tool.
Senior Data Warehouse and Business Intelligence Developer
Best Secret
- Developed and extension of the ETL pipelines and data warehouse.
- Managed the data team infrastructure on Azure, as well as external developers.
- Created Tabular models for many business departments like sales, planning, and controlling.
- Helped plan and execute the data warehouse migration from on-premise SQL Server to Snowflake on the cloud.
- Tracked and fixed bugs using Jira as a reporting tool.
Lead Data Warehouse and Business Intelligence Developer
XAD spoteffects GmbH
- Developed the new algorithm used by the company. This allowed for parallel processing and system improvement.
- Tracked and fixed bugs using Jira as a reporting tool.
- Created code standards and refactored existing objects.
- Helped interview, hire, and train new team members.
Senior Business Intelligence Analyst
Marfrig Global Foods
- Helped create the BI team as the first developer in the company.
- Defined architecture, methodology, and standards for the BI team.
- Tracked and fixed bugs using Jira as a reporting tool.
- Helped interview, hire, and train new team members.
- Developed ETL pipelines, data warehouses, data marts, and OLAP models.
- Consulted the business teams on how to use BI solutions and define new models.
Experience
Weight Loss Simulator
Education
Bachelor's Degree in Information Systems
University of Sao Paulo - Sao Paulo, Brazil
Certifications
ITIL Foundation Certificate in IT Service Management (ITILF)
EXIN
Skills
Libraries/APIs
REST APIs
Tools
SQL Server BI, BigQuery, Microsoft Power BI, Automic (UC4), Apache Airflow, Jira, Confluence, GitLab, Bitbucket, Subversion (SVN), DataGrip, Git
Languages
Python, Snowflake, SQL, T-SQL (Transact-SQL), C#, Python 3
Paradigms
ETL, ITIL
Platforms
Amazon Web Services (AWS), Visual Studio Code (VS Code), Oracle, Azure, Talend, Docker, Windows, Linux
Storage
Databases, Microsoft SQL Server, Amazon S3 (AWS S3), Data Lakes, Database Lifecycle Management (DLM), SSAS Tabular, SQL Server Integration Services (SSIS), SQL Server 2017, IBM Informix, IBM Db2, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Neo4j
Other
Data Engineering, APIs, Data Warehousing, Data Warehouse Design, ETL Tools, ETL Pipelines, Data Extraction, English, DAX, Big Data, Query Optimization, Software Development, Informatica, Data Analytics, Data Reporting
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
Share your needs
Choose your talent
Start your risk-free talent trial
Top talent is in high demand.
Start hiring