Marcio

Marcio is a highly experienced data professional specializing in designing and implementing efficient and scalable data pipelines. He has a proven track record in integrating data from multiple Oracle instances and various external sources. Proficient in SQL, Python, and ETL tools, he extracts, transforms, and loads data into modern data warehouses and lakes. With expertise in data modeling and performance optimization, he ensures high-quality data structures and efficient query execution. Collaborating closely with stakeholders, he delivers end-to-end data solutions that drive data-driven decision making.

Experience 

• Extensive experience in designing and implementing data pipelines, ensuring efficient and scalable data ingestion, transformation. As an example, he designed and developed a new Integrated System that has a Data Pipeline from 4 main Oracle Instances and more than 400 others Oracle Instances outside the company, located in many cities

• Proven ability to work with diverse data sources including databases, datasets, files, and APIs, leveraging SQL, Python, and ETL tools to extract, transform, and load data into modern data warehouses and data lakes like Snowflake and Azure Blob Storage. He Develop and Supports the metadata ingestion process to help the company create a Modern Data Warehouse/Data Lake from many sources (Databases, Datasets, Files, APIs) using Wherescape Red,

• Skilled in data modeling, database design, and performance optimization, enabling high-quality data structures and efficient query execution for improved analytics and reporting capabilities. As a result, this project made it possible to keep up-to-date near real-time critical data such as promotions, prizes, price of items, sales, items of sales, taxation, customers information and others, avoiding integrity errors and creating predictive actions alerts to solve possible errors. 

• Proficient in agile methodologies, collaborating closely with stakeholders, internal teams, and external clients to gather requirements, analyze systems, and provide end-to-end data solutions that meet business needs and drive data-driven decision making. 

Specialization: 

Data engineering 

Expertise:

• Oracle Instances

• SQL

• Python

• ETL Tools

• Snowflake