Raul Jose Diaz Capriles

Data Engineer

Infracommerce•  July 2023 - Present•  Argentina, Remote

I design and develop integrations that trigger ETL processes by creating and managing EndPoints. I utilize AWS Lambda to process 'Order Frames' and extract relevant data for VTEX API calls, retrieving order attributes that are transformed and loaded into Google BigQuery. Additionally, I automate reprocessing tasks using Google Cloud Scheduler and Google Cloud Functions, optimizing scheduled SQL queries in BigQuery. I am also responsible for managing ETL reprocessing for missing data, executing fractional functions to maintain data integrity across key tables. This ensures the smooth operation of the data pipeline, maintaining accuracy and consistency in reporting.