Oscar

Responsible for data ingestion using Snowflake and RedShift, map development using Informatica PowerCenter, and tasks development using Matillion.

Developed stored procedures and user functions, SQL tuning, jobs development and support using Talend, used Snowflake load from S3 buckets using Python scripts, data shares creation for third party consumption, RedShift rollup tables design for Looker dashboards, and Aurora tables loads.

Responsible for stored procedures maintenance, defining database logical model design with entities, attributes, and relationships, completed the physical build of a database in MSSQL for Data Warehouse, developed complex stored procedures and user functions, created and maintained tables design, performance, and tuning, index reviews, system migrations and updates, project documentation, and shell scripting maintenance.

Responsible for new data warehouse design and build, user acceptance testing, and tuning and deployment of several Microsoft SQL Server databases. Built native SQL queries for ad hoc reports as needed.