Pedro

Pedro is a highly skilled Data Engineer l with 9 years of expertise in databases like DB2, Oracle, Teradata, and SQL Server. He excels in analyzing, developing, and supporting cutting-edge tools such as DataStage, Pentaho, and Talend. Pedro seamlessly migrates data to Snowflake, optimizes Teradata, and ensures flawless ETL processes with SQL Server. His proficiency extends to Informatica PowerCenter, cloud platforms like AWS, and versatile programming languages like Python and Shell Scripting. Trust Pedro to deliver exceptional results, streamline workflows, and leverage advanced data warehousing technologies for your success.

• Demonstrated an expertise  in DB2, Oracle, Teradata, and SQL Server, complemented by strong proficiency in Informatica PowerCenter. Seamlessly analyze, develop, and support cutting-edge tools like DataStage, Pentaho, and Talend. Migrate data effortlessly to Snowflake, optimize Teradata, and achieve flawless ETL processes with SQL Server. Experience seamless data integration and streamlined workflows through our mastery of Informatica PowerCenter. Troubleshooting and tuning any ETL issues.) processes.

• Expert in Dimensional Modeling, ETL tuning, and ELT, we optimize data transformation and loading processes to enhance performance significantly. He excels in analyzing, developing, and documenting BI projects, utilizing cutting-edge tools. Also, he is well-versed in leveraging pushdown capabilities on Talend for efficient ELT operations, along with comprehensive data modeling expertise. 

• His proficiency extends to cloud platforms, particularly AWS, where he showcases exceptional expertise. With hands-on experience, we leverage AWS services like EC2, RDS, S3, and Athena to drive data integration projects. 

• He possesses versatile programming skills, including expertise in Python for updating scripts and familiarity with Shell Scripting. This enables him to automate and script ETL routines with precision and efficiency. As a result, he delivers seamless automation and streamlined ETL processes, enhancing the overall effectiveness of your data workflows.

• Experienced in working with advanced data warehousing technologies like Snowflake, he excels in utilizing advanced Snowflake script features such as Snowpipe, task, and procedure. This expertise enables seamless data migration and efficient implementation of BI projects. Trust him to leverage the power of Snowflake, delivering exceptional results for your data management and analytics initiatives.

Tech Skills 

DB2

Oracle

Teradata

SQL Server

Informatica PowerCenter

DataStage

Pentaho

Talend

Snowflake

AWS (specifically EC2, RDS, S3, and Athena)

Python

Shell Scripting