Juan Pablo Botta

Oversight of the architecture and development of a data lake on Google Cloud Platform to support data and analytics operations for Transelect Chile. It leverages Medallion Architecture, implementing robust data governance, visualization tools, secure access controls, reliable backup, data obfuscation, detailed logging, and vigilant monitoring. It optimizes data intake by refactoring as many as 400 ingestion workflows across various data sources.

Involved in designing and implementing Informatica's cloud-based data governance solution on Azure for Toyota's Argentine operations. Played a key role in the deployment and the setup of workflows to generate detailed metrics for stakeholder consumption. By automating data analysis, profiling, and lineage tracking for 5 core business data domains, this solution enhances data quality and traceability within the customer's data lake.

As head of Data Engineering, lead the migration of Informatica data integration to Azure for Customer CIPD (UK). Designing, estimating, and configuring new cloud environments were critical components of this project. The project included the adaptation of a substantial volume of more than 200 existing real-time data pipelines to the new platform.

Built partnerships with up to 30 distinct Latin American Ergo clients to explore and execute data-driven initiatives. Requiring identifying business challenges and developing corresponding data strategies using optimal technologies. This includes project scoping, resource planning, and team building to achieve project objectives.

Managed a Data Integration Software Factory of up to 20 employees, responsible for designing, developing, and maintaining Informatica PowerCenter data pipelines to support Customer Telecom Argentina's operations. Took full ownership of the solution lifecycle, ensuring optimal operations and delivering high-quality, scalable outcomes. By integrating diverse technologies within the customer ecosystem, these solutions empowered informed business decision-making.