Mario Contreras - Data Engineer Resume and Experience

Vocabulary flashcards covering the technical tools, platforms, architectural concepts, and work experience details from Mario Contreras's data engineering profile.

Mario Contreras

A Data Engineer based in Manhattan, New York with 5 years of IT experience, specializing in Big Data, Python, SQL, and ETL pipeline development.

Medallion Architecture

A data design architecture implemented in Databricks using Python and PySpark to manage structured data flow from raw to curated layers.

Faker Data utility

A Python utility developed to allow SMEs to create target ERD models via configurations and generate synthetic data into SQLite for POCs and future-state planning.

Unity Catalog

An Azure Databricks tool used to verify data ingestion and data lineage, as well as conduct functional testing for Databricks applications.

Informatica IICS

An integration platform used at San Diego Health for data profiling to provide data quality metrics and migrate reports involving tables, Joins, and PK/FK relationships.

pkl file transformations

A serialization method used to optimize Python models into Databricks to achieve high read speeds with low storage costs.

Lakebase

A system implemented at First Service Residential for handling OLTP systems, facilitating branching and chain set logs for tracking.

Profisee

A Master Data Management (MDM) solution utilized via API at First Service Residential to support legacy and target systems.

Talend

An ETL tool leveraged at Cardinality for DBMS solutioning, utilizing SQL for data transformations.

Snowfakery

A tool utilized at Cardinality to generate synthetic test data and mimic user experiences during application testing.

Dbeaver

A database tool used at Cardinality to remotely connect to Postgres databases for data analysis.

Colibra

A data governance platform utilized at Carrion Health Group to map data sets and plan the target state of a Snowflake data warehouse.

Hyperlog Log queries

Query optimization algorithms utilized at Carrion Health Group to improve report generation speed by 5x and enhance data integrity turnaround.

Requirement Traceability Matrix (RTM)

A tracking document developed and updated at SR Solutionreach to trace software changes and align test cases with business requirements.

End-to-End Testing (SR Solutionreach)

A comprehensive testing process comprising Regression Testing, GUI testing, Integration Testing, System Testing, User Acceptance Testing, and Negative Testing of an application and its interfaces.

Boost Mobile

The telecommunications brand for which activations, reactivations, and port-ins were processed at New Citi Wireless.

SAS VAYA

An analytics tool utilized alongside Hadoop and PySpark (Databricks) within Palantir at San Diego Health to automate large-scale ETL pipelines.

DevDom

The consulting organization where Mario Contreras served as a Remote Contract Data Engineer starting in January 2022, supporting diverse corporate clients.